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>
以上所述就是本文的全部内容了，希望大家能够喜欢。
热门推荐
1 训练狗狗憋尿
2 狗狗追踪训练
3 狗狗训练要多少钱
5 深圳狗狗训练
6 训练狗狗唤回
7 狗狗叫怎么训练
8 狗狗训练班
10 狗狗社会化训练
11 狗狗叫回训练
12 广州狗狗训练学校
13 狗狗训练躺下
14 狗狗随行训练
15 训练狗狗巡回
16 狗狗要怎么训练
17 狗狗喂食训练
18 训练狗狗躺下