.


:




:

































 

 

 

 


 

, , . , :

<table border='1'>

<tr>

<td></td>

<td></td>

<td></td>

</tr>

<?php

$sql = mysql_query("SELECT `ID`, `Name`, `Price` FROM `products`", $link);

while ($result = mysql_fetch_array($sql)) {

echo '<tr><td>'.$result['ID'].'</td>'.

'<td>'.$result['Name'].'</td>'.

'<td>'.$result['Price'].' </td>'.

'<td><a href="?del_id='.$result['ID'].'"></a></td></tr>';

}

?>

</table>

:

<?php

if (isset($_GET['del_id'])) { //,

$sql = mysql_query('DELETE FROM `products` WHERE `ID` = '.$_GET['del_id']); //

}

?>

 

<!doctype html>

<html lang="ru">

<head>

<title>MySQL</title>

</head>

<body>

<?php

$host="localhost"; //

$user="root"; //

$pass="123456"; //

$db_name="my_db"; //

$link=mysql_connect($host,$user,$pass); //

mysql_select_db($db_name,$link); //

if (isset($_GET['del_id'])) { //,

$sql = mysql_query('DELETE FROM `products` WHERE `ID` = '.$_GET['del_id']); //

}

if (isset($_GET['red_id'])) { //,

if (isset($_POST['Name'])) { // ,

$sql = mysql_query('UPDATE `products` SET '

.'`Name` = "'.$_POST['Name'].'",'

.'`Price` = '.$_POST['Price'].' '

.'WHERE `ID` = '.$_GET['red_id']);

}

}

?>

<table border='1'>

<tr>

<td></td>

<td></td>

<td></td>

</tr>

<?php

$sql = mysql_query("SELECT `ID`, `Name`, `Price` FROM `products`", $link);

while ($result = mysql_fetch_array($sql)) {

echo '<tr><td>'.$result['ID'].'</td>'.

'<td>'.$result['Name'].'</td>'.

'<td>'.$result['Price'].' </td>'.

'<td><a href="?del_id='.$result['ID'].'"></a></td>'.

'<td><a href="?red_id='.$result['ID'].'"></a></td></tr>';

}

?>

</table>

<?php

if (isset($_GET['red_id'])) { //

//

$sql = mysql_query("SELECT `ID`, `Name`, `Price` FROM `products` WHERE `ID`=".$_GET['red_id'], $link); //

$result = mysql_fetch_array($sql); //

?>

<table>

<form action="" method="post">

<tr>

<td>:</td>

<td><input type="text" name="Name" value="<?php echo ($result['Name']);?>"></td>

</tr>

<tr>

<td>:</td>

<td><input type="text" name="Price" size="3" value="<?php echo ($result['Price']);?>"> .</td</tr> \<tr>

<td colspan="2"><input type="submit" value="OK"></td>

</tr></form>

</table>

<?php

}

?>

</body>

</html>

, - : , , , -, web-, , . html , html - - , , , - web-.

PHP - , , . - PHP SQL - - , .

 

1. . PHP

2. , . 75 web- ;

3. . . . PHP MySQL;

4. . HTML, JavaScript, PHP MySQL. Web-, 20.



<== | ==>
| . .
:


: 2018-10-14; !; : 191 |


:

:

.
==> ...

1032 - | 878 -


© 2015-2024 lektsii.org - -

: 0.014 .