多说无益,直接上代码,仔细看完就明白了。
<!DOCTYPE html>
<?phpheader("content-type:text/html; charset=utf-8");
?>
<head>
<meta charset="utf-8" />
</head>
<html>
<body>
<?php
if(isset($_POST['add']))// isset() 只能用于变量,因为传递任何其它参数都将造成解析错误。若想检测常量是否已设置,可使用 defined() 函数。
{
$dbhost = 'localhost:3306'; //mysql服务器主机地址
$dbuser = 'root'; //mysql用户名
$dbpass = '';//mysql用户名密码
$conn = mysql_connect($dbhost, $dbuser, $dbpass);//连接数据库
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
mysql_query("set names utf8"); //定义编码格式 这个很重要,不加这个可能会引起数据乱码
$sql = 'SELECT student_id, student_name,
student_sex
FROM student'; //查询出数据库中数据
mysql_select_db('students');
$retval = mysql_query( $sql, $conn);
if(! $retval )
{
die('Could not enter data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) //mysql_fetch_array(data,array_type)取得关联数组,输出数组
{
echo "<label>学号:</label><span>{$row['student_id']}</span>".
"<label>姓名:</label><span>{$row['student_name']}</span>".
"<label>性别:</label><span>{$row['student_sex']}</span>".
"<br> ";
}
echo "Entered data successfully\n";
mysql_close($conn);//关闭数据库
}
if(isset($_POST['delete'])){
$dbhost = 'localhost:3306'; //mysql服务器主机地址
$dbuser = 'root'; //mysql用户名
$dbpass = '';//mysql用户名密码
$conn = mysql_connect($dbhost, $dbuser, $dbpass);//连接数据库
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
mysql_query("set names utf8");
$sql = 'DELETE FROM student
WHERE student_id=9131101'; //删除 字段student_id=9131101'这条数据
mysql_select_db('students');
$retval = mysql_query( $sql, $conn);
if(! $retval )
{
die('Could not enter data: ' . mysql_error());
}
echo "Delete data successfully\n";
mysql_close($conn);//关闭数据库
}
?>
<form name="form1" method="post" action="<?php $_PHP_SELF ?>">
<input name="add" type="submit" id="add" value="查询" />
<input name="delete" type="submit" id="delete" value="删 除" />
</form>
</body>
</html>