php+mysql实现简单的增删改查功能

发布时间：2020-12-12 21:00:14 所属栏目：PHP教程来源：网络整理

导读：列表代码 if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("test",$con); $result = mysql_query("SELECT * FROM user"); echo " tr Username Password while($row = mysql_fetch_array($result)) { echo "tr"; echo "td" . $r

列表代码

if (!$con) {
die('Could not connect: ' . mysql_error());
}

mysql_select_db("test",$con);

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

echo "

<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);

删除

mysql_select_db("test",$con);

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

mysql_close($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);

修改

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

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

mysql_close($con);
?>

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

Insert:

password:

Delete

Are you sure?

Update

You want to change your password into:

以上所述就是本文的全部内容了，希望大家能够喜欢。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

Username	Password