//获得连接
$db = mysql_connect("localhost", "root", "root") or die(mysql_error());
echo "Connected to MySQL
";
//连接数据库
mysql_select_db("php") or die(mysql_error());
echo "Connected to Database";
//增加操作
if ($submit){
$sql = "INSERT INTO student (id,name) VALUES ('$id','$name')";
$result = MySQL_query($sql);
echo "记录添加成功!
";
}
//删除操作
if($delete){
$sql ="delete from student where id = $id";
$result = mysql_query($sql);
echo "删除了id为 $id 的记录 ";
}
//修改操作
if($update){
$sql = "update student set name='$name' where id = $id";
$result = mysql_query($sql);
echo "修改成功!!";
}
//查询数据,并用表格显示出来
$result = mysql_query("select * from student",$db);
echo "
echo "
id姓名";echo "
\n";//循环遍历
while ($myrow = mysql_fetch_row($result)){
printf("
%s%s", $myrow[0], $myrow[1]);}
echo "
\n";?>