php中mysql的增删_php中mysql实现的增删改查功能

本篇文章主要介绍php中mysql实现的增删改查功能，感兴趣的朋友参考下，希望对大家有所帮助。

列表代码<?php

$con = mysql_connect("localhost:3306","root","");

if (!$con) {

die('Could not connect: ' . mysql_error());

}

mysql_select_db("test", $con);

$result = mysql_query("SELECT * FROM user");

echo "

Username	Password

while($row = mysql_fetch_array($result)) {

echo "

";

echo "

" . $row['username'] . "";

echo "

" . $row['password'] . "";

echo "

";

}

echo "

";

mysql_close($con);

?>

删除<?php

$con = mysql_connect("localhost","root","");

if (!$con) {

die('Could not connect: ' . mysql_error());

}

mysql_select_db("test", $con);

mysql_query("DELETE FROM user WHERE username = '$_POST[username]'");

mysql_close($con);

?>

添加<?php

$con = mysql_connect("localhost:3306","root","");

if (!$con) {

die('Could not connect: ' . mysql_error());

}

mysql_select_db("test", $con);

$sql = "INSERT INTO user (username,password)

VALUES

('$_POST[username]','$_POST[password]')";

if (!mysql_query($sql,$con)) {

die('Error: ' . mysql_error());

}

echo "1 record added";

mysql_close($con);

?>

修改<?php

$con = mysql_connect("localhost","root","");

if (!$con) {

die('Could not connect: ' . mysql_error());

}

mysql_select_db("test", $con);

mysql_query("UPDATE user SET password = '$_POST[password]' WHERE username = '$_POST[username]'");

mysql_close($con);

?>

用PHP向数据库中实现简单的增删改查

Insert:

username:

password:

---

Delete

username:

Are you sure?

---

Update

username:

You want to change your password into:

---

总结：以上就是本篇文的全部内容，希望能对大家的学习有所帮助。

相关推荐：