php 删除mysql表中的数据
Delete a Record from MySQL Databaseif(isset($_POST['delete']))
{
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'root';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect ');
}
$emp_id = $_POST['emp_id'];
$sql = "DELETE from employee ".
"WHERE emp_id = $emp_id" ;
print "sql" . $sql;
mysql_select_db('test_db');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not delete data');
}
echo "Deleted data successfully\n";
mysql_close($conn);
}
else
{
?>
Employee ID | |
}
?>
本文原创发布php中文网,转载请注明出处,感谢您的尊重!