本文给大家分享的是使用 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 "";
- while($row = mysql_fetch_array($result)) {
- echo "";
- echo "";
- echo "";
- echo "";
- }
- echo "Username Password" . $row['username'] . "" . $row['password'] ."
- ";
- 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);
- ?>
- Insert:
- username:
- password:
- Delete
- username:
- Are you sure?
- Update
- username:
- You want to change your password into:
来源: https://www.php1.cn/detail/php-f9267ae7e3.html