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

?>

从服务器中获取用户所有信息（SQL SELECT语句）并以表格形式出现
$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
$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

$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

Insert:

username:


password:

---

Delete

username:


Are you sure?

---

Update

username:


You want to change your password into:

---

以上三个功能的提交源Operate.html

蜻蜓睦圆财政金融号排