Delete data from database by ID in php

Code:

<html>
<body>
<?php
$cnx = mysql_connect('server','user','password');
mysql_select_db('dbname');

$id = '1';
$ok1 = @mysql_query("DELETE FROM Employee WHERE ID='$id'");
if ($ok1) {
  echo('<p>Author deleted successfully!</p>');
} else {
  echo('<p>Error deleting author from database!<br />'.
       'Error: ' . mysql_error() . '</p>');
}

?>
</body>
</html>

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : Delete data from database by ID in php
Delete data from database table in php -
Displaying images from database instead of the url from data -
How to fill a ComboBox with data from a database in jsp -
Display data from database as Tree Structure in JSP -
form to insert data, upload many files and images , database -
Delete a file in php -
Delete file -
DELETE Commands -
delete file in asp -
Delete directory in php -

Topic Tags

PHP Database

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com