最近学PHP,操作SQL的时候,一般会有一个基本的操作语句,现在以删除为例,这样以后做相应的数据库操作只要直接复制就好了。
<?
echo $id;
//基本设定
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "admin";
$mysql_database = "bbsunchen";
$sql = "DELETE FROM book WHERE id = '$id'";
$conn = mysql_connect($mysql_server_name, $mysql_username, $mysql_password);
mysql_select_db($mysql_database, $conn);
$result = mysql_query($sql);
mysql_close($conn);
?>