, , . , :
<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.