в 10:37, 26 мая 2010

2010-05-26T10:37:34Z

Admin: 1 версия

2010-05-26T07:06:16Z

1 версия

Новая страница

==Delete data from database by ID==



<source lang="html4strict">

<html>
<body>
<?php
$cnx = mysql_connect("mysql153.secureserver.net","wbex","password");
mysql_select_db("wbex");
$id = "1";
$ok1 = @mysql_query("DELETE FROM Employee WHERE ID="$id"");
if ($ok1) {
echo("Author deleted successfully!");
} else {
echo("Error deleting author from database! ".
"Error: " . mysql_error() . "");
}
?>
</body>
</html>

</source>

==Delete data from database table==



<source lang="html4strict">

<?php
mysql_connect("mysql153.secureserver.net","wbex","password");
mysql_select_db("wbex");
$rowID = "001";
$query = "DELETE FROM Employee WHERE ID="$rowID"";
$result = mysql_query($query);
if ((mysql_affected_rows() == 0) || mysql_affected_rows() == -1) {
echo "There was a problem deleting some of the selected items.";
exit;
}
?>

</source>

← Предыдущая	Версия 10:37, 26 мая 2010
(нет различий)

PHP/MySQL Database/Database Delete - История изменений

в 10:37, 26 мая 2010

Admin: 1 версия