標籤:log pos eth 處理 登入 mysqli 密碼 mit oca
登陸頁面
<body>
<h1>登入頁面</h1>
<form action="./dengluchuli.php" method="post">
<div>使用者名稱:<input type="text" name="uid" /></div>
<div>密碼:<input type="password" name="pwd" /></div>
<div><input type="submit" value="登入" /></div>
</form>
</body>
登陸處理
<?php
$uid = $_POST["uid"];
$pwd = $_POST["pwd"];
//1.造連線物件
$db = new MySQLi("localhost","root","123","mydb");
//2.寫SQL語句
$sql = "select password from login where username=‘{$uid}‘";
//3.執行
$reslut = $db->query($sql);
//4.取資料
$attr = $reslut->fetch_row();
if($attr[0]==$pwd && !empty($pwd))
{
echo "登入成功!";
}
else
{
echo "登入失敗!";
}
註冊頁面
<body>
<h1>註冊頁面</h1>
<form action="./zhucechuli.php" method="post">
<div>使用者名稱:<input type="text" name="uid" /></div>
<div>密碼:<input type="text" name="pwd" /></div>
<div>姓名:<input type="text" name="name" /></div>
<div><input type="submit" value="註冊" /></div>
</form>
</body>
註冊處理
<?php
$uid = $_POST["uid"];
$pwd = $_POST["pwd"];
$name = $_POST["name"];
//1.造連線物件
$db = new MySQLi("localhost","root","123","mydb");
//2.寫SQL語句
$sql = "insert into login values(‘{$uid}‘,‘{$name}‘,‘{$pwd}‘,0)";
//3.執行
$r = $db->query($sql);
if($r)
{
echo "註冊成功!";
}
else
{
echo "註冊失敗!";
}
php登陸與註冊