一个简单的登录界面(login.php): 帐号密码的数据库查询判断(confirm.php):
header("Content-Type:text/html; charset=utf-8");
//创建数据库链接:本地数据库,用户名:root,密码:空,数据库名称:test。 $connect = mysqli_connect("localhost","root","","test");
// 定义变量并设置为空值 $name = "";
if ($_SERVER["REQUEST_METHOD"] == "POST") { $name = test_input($_POST["name"]);
$password = test_input($_POST["password"]); }
function test_input($data) { $data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data); return $data; }
$flags=0;
//从表admin中查询
$result = mysqli_query($connect,"SELECT * FROM admin where name = '".$name."'"); while($row = mysqli_fetch_array($result)) {
if($row['password']==$password) {$flags=1;} }
if($flags) {
mysqli_query($connect,"UPDATE admin SET times = times+1 WHERE name = '".$name."'"); echo "";//跳转回首页
(index.php) } else {
echo "";//跳转回登录界面 }
//关闭数据库链接
mysqli_close($connect);
本文来源:https://www.wddqw.com/doc/d9c837ebfbb069dc5022aaea998fcc22bcd143e6.html