Use PHP to implement simple additions, deletions, modifications and queries in the database (pure code, to be improved), PHP additions and deletions
![](http://www.bkjia.com/uploads/allimg/150713/164IM344-0.gif)
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);
?>
Get all user information (SQL SELECT statement) from the server and present it in table form
![](http://www.bkjia.com/uploads/allimg/150713/164IM344-0.gif)
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);
?>
Delete all information of this user delete.php
![](http://www.bkjia.com/uploads/allimg/150713/164IM344-0.gif)
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);
?>
Register a new user insert.php
![](http://www.bkjia.com/uploads/allimg/150713/164IM344-0.gif)
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);
?>
Change a user’s password update.php
![](http://www.bkjia.com/uploads/allimg/150713/164IM344-0.gif)
<html>
<head>
<title>FORMtitle>
head>
<body>
<br />
<h1>Insert:h1>
<form action="insert.php" method="post">
username:<input type="name" name="username"/>
<br />
password:<input type="password" name="password"/>
<input type="submit" value="submit"/>
form>
<br /><hr /><br />
<h1>Deleteh1>
<form action="delete.php" method="post">
username:<input type="name" name="username" />
<br />
Are you sure?<input type="submit" value="sure" />
form>
<br /><hr /><br />
<h1>Updateh1>
<form action="update.php" method="post">
username:<input type="name" name="username"/>
<br />
You want to change your password into:<input type="password" name="password"/>
<input type="submit" value="submit"/>
form>
<br /><hr /><br />
body>
html>
以上三个功能的提交源Operate.html
http://www.bkjia.com/PHPjc/1030847.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/1030847.htmlTechArticle用PHP向数据库中实现简单的增删改查(纯代码,待完善),php增删 ? php $con = mysql_connect ("localhost:3306","root","" ); if (! $con ) { die ('Could not con...