php、添加、刪除、修改、查詢

1、主頁：學(xué)生信息管理1.顯示2.修改3.插入4.刪除刪除頁面：mysql_connect("localhost","root"$query="select * from stu"$result=mysql_db_query("jiaoxue","$query"echo"學(xué)生信息表" echo'echo'while($row=mysql_fetch_array($result$stu_id=$row"stu_id"$name=$row"

2、;name"$dep_id=$row"dep_id"$class=$row"class_id"echo'echo"echo"echo"echo"echo'' ' ' " " " " 學(xué)號(hào)姓名系部班級(jí)".$stu_id."".$name."".$dep_id."".$class."'?>請(qǐng)輸入帶修改學(xué)生的學(xué)號(hào)學(xué)號(hào):返回刪除：$db =

3、mysql_connect("localhost", "root"mysql_select_db("jiaoxue",$db;$sql="delete from stu where stu_id=$stu_id"$result=mysql_query($sql;if($resultecho"記錄刪除成功!"$query="select * from stu"$result=mysql_db_query("jiaoxue","$query"

4、;echo'echo'while($data=mysql_fetch_object($resultecho'echo"echo"echo"echo"echo'' ' ' " " " " 學(xué)號(hào)姓名系部班級(jí)".$data->stu_id."".$data->name."".$data->dep_id."".$data->class_id."' elsee

5、cho"刪除記錄失敗!"?>返回修改頁面：mysql_connect("localhost","root"$query="select * from stu"$result=mysql_db_query("jiaoxue","$query"echo"學(xué)生信息表" echo'echo'while($data=mysql_fetch_object($resultecho'echo"echo"echo"

6、echo"echo'' ' ' " " " " 學(xué)號(hào)姓名系部班級(jí)".$data->stu_id."".$data->name."".$data->dep_id."".$data->class_id."'?>請(qǐng)輸入帶修改學(xué)生的學(xué)號(hào)學(xué)號(hào):返回修改：$db = mysql_connect("localhost", "root"mysql_select_db(&qu

7、ot;jiaoxue",$db;if ($submit $sql = "UPDATE stu SET name='$name',dep_id='$dep_id',class_id='$class_id' WHERE stu_id=$stu_id"$result = mysql_query($sql;echo "數(shù)據(jù)修改完成"mysql_connect("localhost","root"$query="select * from stu"

8、$result=mysql_db_query("jiaoxue","$query"echo'echo'while($data=mysql_fetch_object($resultecho'echo"echo"echo"echo"echo'' ' ' " " " " 學(xué)號(hào)姓名系部班級(jí)".$data->stu_id."".$data->name."".$data-

9、>dep_id."".$data->class_id."' ?>返回修改頁面：$db=mysql_connect("localhost","root"/mysql_select_db("jiaoxue","$db"$sql="select * from stu where stu_id=$stu_id"$result=mysql_db_query("jiaoxue","$sql"$data=mysql

10、_fetch_object($result;echo''echo"".$data->stu_id.""echo"".$data->name.""echo"".$data->dep_id.""echo"".$data->class_id.""echo''?>學(xué)生信息修改學(xué)號(hào):<?php echo $data->stu_id;?>姓名:<?php echo

11、 $data->name;?>系部:<?php echo $data->dep_id;?>班級(jí):<?php echo $data->class_id;?>onclick="hstory.back(-1">添加頁面：學(xué)號(hào):姓名:系部:班級(jí):返回添加：mysql_connect("localhost","root"$query_insert="insert into stu (stu_id,name,dep_id,class_id values('$stu_id

12、9;,'$name','$dep','$class'"$result_insert=mysql_db_query("jiaoxue","$query_insert"if($result_insertecho ""$query="select * from stu where dep_id='19'"$result=mysql_db_query("jiaoxue","$query"echo'ech

13、o'while($data=mysql_fetch_object($resultecho'echo"echo"echo"echo"echo'' ' ' " " " " 學(xué)號(hào)姓名系部班級(jí)".$data->stu_id."".$data->name."".$data->dep_id."".$data->class_id."' elseecho ""?>返回查詢：mysql_connect("localhost","root"$query="select * from stu"$result=mysql_db_query("jiaoxue","$query"echo'echo'while($data=mysql_fetch_object($resultecho'echo"echo&quo