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.php
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);
?>
注册一个新用户insert.php
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);
?>
修改一个用户密码update.php
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...
Kenyataan:
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn