php+mysql实现简单的增删改查功能
列表代码
<?php
$con=mysql_connect("localhost:3306","root","");
if(!$con){
die('Couldnotconnect:'.mysql_error());
}
mysql_select_db("test",$con);
$result=mysql_query("SELECT*FROMuser");
echo"<tableborder='1'>
<tr>
<th>Username</th>
<th>Password</th>
</tr>";
while($row=mysql_fetch_array($result)){
echo"<tr>";
echo"<td>".$row['username']."</td>";
echo"<td>".$row['password']."</td>";
echo"</tr>";
}
echo"</table>";
mysql_close($con);
?>
删除
<?php
$con=mysql_connect("localhost","root","");
if(!$con){
die('Couldnotconnect:'.mysql_error());
}
mysql_select_db("test",$con);
mysql_query("DELETEFROMuserWHEREusername='$_POST[username]'");
mysql_close($con);
?>
添加
<?php
$con=mysql_connect("localhost:3306","root","");
if(!$con){
die('Couldnotconnect:'.mysql_error());
}
mysql_select_db("test",$con);
$sql="INSERTINTOuser(username,password)
VALUES
('$_POST[username]','$_POST[password]')";
if(!mysql_query($sql,$con)){
die('Error:'.mysql_error());
}
echo"1recordadded";
mysql_close($con);
?>
修改
<?php
$con=mysql_connect("localhost","root","");
if(!$con){
die('Couldnotconnect:'.mysql_error());
}
mysql_select_db("test",$con);
mysql_query("UPDATEuserSETpassword='$_POST[password]'WHEREusername='$_POST[username]'");
mysql_close($con);
?>
<html> <head> <title>用PHP向数据库中实现简单的增删改查</title> </head> <body> <br/> <h1>Insert:</h1> <formaction="insert.php"method="post"> username:<inputtype="name"name="username"/> <br/> password:<inputtype="password"name="password"/> <inputtype="submit"value="submit"/> </form> <br/><hr/><br/> <h1>Delete</h1> <formaction="delete.php"method="post"> username:<inputtype="name"name="username"/> <br/> Areyousure?<inputtype="submit"value="sure"/> </form> <br/><hr/><br/> <h1>Update</h1> <formaction="update.php"method="post"> username:<inputtype="name"name="username"/> <br/> Youwanttochangeyourpasswordinto:<inputtype="password"name="password"/> <inputtype="submit"value="submit"/> </form> <br/><hr/><br/> </body> </html>
以上所述就是本文的全部内容了，希望大家能够喜欢。