<html><head><title>Delete a Record from MySQL Database</title></head><body><?phpif(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{?><form method="post" action="<?php $_PHP_SELF ?>"><table width="400" border="0" cellspacing="1" cellpadding="2"><tr><td width="100">Employee ID</td><td><input name="emp_id" type="text" id="emp_id"></td></tr><tr><td width="100"> </td><td> </td></tr><tr><td width="100"> </td><td><input name="delete" type="submit" id="delete" value="Delete"></td></tr></table></form><?php}?></body></html>
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
