Use PHP to implement simple additions, deletions, modifications and queries in the database (pure code, to be improved), PHP additions and deletions
![Use PHP to implement simple additions, deletions, modifications and queries in the database (pure code, to be improved), php additions and deletions_PHP tutorial]()
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
![Use PHP to implement simple additions, deletions, modifications and queries in the database (pure code, to be improved), php additions and deletions_PHP tutorial]()
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
![Use PHP to implement simple additions, deletions, modifications and queries in the database (pure code, to be improved), php additions and deletions_PHP tutorial]()
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
![Use PHP to implement simple additions, deletions, modifications and queries in the database (pure code, to be improved), php additions and deletions_PHP tutorial]()
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
![Use PHP to implement simple additions, deletions, modifications and queries in the database (pure code, to be improved), php additions and deletions_PHP tutorial]()
<html>
<head>
<title>FORM
title>
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...
Statement：The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
