PHP/MySQL Database/Database Delete

Материал из Web эксперт
Перейти к: навигация, поиск

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>
Источник — «http://wbex.ru/index.php?title=PHP/MySQL_Database/Database_Delete&oldid=1025»