首页 / 网页编程 / PHP / PHP MySql增删改查的简单实例

<?php$con=@mysql_connect（"localhost","root","root"）;//连接数据库mysql_select_db（"test",$con）;//选择数据库$userInfo=mysql_query（"select * from user",$con）;//创建sql语句echo "<table>";while（$row=mysql_fetch_assoc（$userInfo））//获取结果集每一行的数据{echo "<tr>";echo "<td>";echo $row["id"];//获取行中的idecho "</td>";echo "<td>";echo $row["username"];echo "</td>";echo "<td>";echo $row["password"];echo "</td>";echo "</tr>";}echo "</table>";mysql_free_result（$userInfo）;//释放结果集mysql_close（$con）; //关闭数据库/*delete$d=@mysql_connect（"localhost","root","root"）;mysql_select_db（"test",$d）;mysql_query（"delete from user where id=1",$d）;mysql_close（$d）;*//*insert$i=@mysql_connect（"localhost","root","root"）;mysql_select_db（"test",$i）;mysql_query（"insert into user（username,password） values（"ad","ad"）",$i）;mysql_close（$i）;*///update$u=@mysql_connect（"localhost","root","root"）;mysql_select_db（"test",$u）;mysql_query（"update user set username="aaa" where username="00"",$u）;echo "update user set username="ax" where id=2";mysql_close（$u）;?>