PHPÁ¬½ÓMYSQLÊý¾Ý¿â

<p>04¼¶ÐÂÉúÃûµ¥</p>
<table border="1" width="80%" cellpadding="0">
<tr>
<td width="10%" align="center">Id</td>
<td width="20%" align="center">Name</td>
<td width="10%" align="center">Age</td>
<td width="10%" align="center">Sex</td>
<td width="30%" align="center">Address</td>
<td width="20%" align="center">DoWith</td>
</tr>
<?php
//Á¬½ÓÊý¾Ý¿â
//´ò¿ªÒ»¸öÁ¬½Ó,Á¬½Óµ½±¾µØmysqlÊý¾Ý¿â
$conn=mysql_connect("localhost","root","dalyluo");//ip£¬user£¬pwd
//Ñ¡Ôñ²Ù×÷µÄ×ÊÁÏ¿â
mysql_select_db("test",$conn);// ×ÊÁÏ¿âÃû³Æ,Á¬½Ó
$sql="select * from student";

//ÓÃmysql_queryº¯Êý´Ó×ÊÁÏ¿âÖвéѯ
mysql_query("set names gbk");//´¦ÀíÖÐÎÄÂÒÂëÎÊÌ⣬gbk¿ÉÒÔÊÇÆäËüÖµ
$result=mysql_query($sql,$conn);// search sql, connection
//Ñ­»·¶ÁÈ¡¼Ç¼
while($row=mysql_fetch_array($result)){
?>
<tr>
<td width="10%" align="center"><?php echo $row["stuid"] ?></td>
<td width="20%" align="center"><?php echo $row["stuname"] ?></td>
<td width="10%" align="center"><?php echo $row["stuage"] ?></td>
<td width="10%" align="center"><?=$row["stusex"]?></td>
<td width="30%" align="center"><?=$row["stuaddress"]?></td>
<td width="20%" align="center"><a href="#" mce_href="#" onClick="<?php doDel($row["stuid"]) ?>">ɾ³ý</a></td>
</tr>
<?php
}
//¹Ø±ÕÁ¬½Ó
mysql_close($conn);
function doDel($sid){
global $conn;
mysql_select_db("test",$conn);
$del_sql="delect from student where stuid="+$sid;
mysql_query($del_sql,$conn);
}
?>
</table>