php 剔除mysql表中的数据

php 删除mysql表中的数据
<html>
<head>
<title>Delete a Record from MySQL Database</title>
</head>
<body>

<?php
	if(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>
php 剔除mysql表中的数据

相关推荐
