[教學] 看到板上有人發PDO的文,我來寫個登入的吧
請各位多指教囉！
<?php
$db = new PDO("mysql:host=localhost;dbname=web", "username", "password");
if (isset($_POST['username']) && isset($_POST['password'])) {
$username = $_POST['username'];
$password = $_POST['password'];
$sql = "SELECT `id`, `password` FROM `users` " .
"WHERE `username` = :username LIMIT 1";
$login = $db->prepare($sql);
$login->bindParam(":username", $username);
$login->execute();
$user = $login->fetch();
if ($user && $user['password'] == $password) {
$_SESSION['login'] = true;
$_SESSION['uid'] = $user['id'];
header("location: /");
} else {
header("location: /login.php");
}
} else {
$html = '<!DOCTYPE html>
<form action="login.php" method="post">
<input type="text" name="username" />
<input type="password" name="password" />
<input type="submit" value="登入" />
</form>';
header("Content-Type: text/html;charset=utf-8");
header("Content-Length: " . strlen($html));
echo($html);
}
?>
--
★∥ ○ ◢ 〞` ◣ ◥◣◢◣◢◣ ◢▏。 ○ ο ∣★
★｜ ° ◢ ╮ ██◤ █◤◥◤█ ∥ o ° ∥★
★∥ 。 ● ● ◤ ◥ █ █ ∥ ◢╱﹋◣ 。 ∣★
★∣ ◥ˍ ◤◤ ◢◤ ◢◢◤██◤ ◣ ◢╱ ● ︶ （ ∥★
★∥ （ ◢◤ ◤ing ∥say ◢███ ╰ ◤ ζ ） ∣★
★│ ） mt.rmstudio.tw ︾ mt@moztw.org ◤ ◥◢ ◤◤ wnqui ∥★
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.42.67.27
→
07/14 22:52, , 1F
07/14 22:52, 1F
推
07/14 23:01, , 2F
07/14 23:01, 2F
→
07/15 00:43, , 3F
07/15 00:43, 3F
→
07/15 08:04, , 4F
07/15 08:04, 4F
→
07/15 08:04, , 5F
07/15 08:04, 5F
推
07/15 09:49, , 6F
07/15 09:49, 6F
→
07/15 09:50, , 7F
07/15 09:50, 7F
推
07/15 20:45, , 8F
07/15 20:45, 8F
→
07/15 21:26, , 9F
07/15 21:26, 9F
推
07/15 21:33, , 10F
07/15 21:33, 10F
→
07/15 21:37, , 11F
07/15 21:37, 11F
→
07/15 21:47, , 12F
07/15 21:47, 12F
推
07/15 22:19, , 13F
07/15 22:19, 13F
→
07/15 22:31, , 14F
07/15 22:31, 14F
→
07/15 22:39, , 15F
07/15 22:39, 15F
→
07/15 22:39, , 16F
07/15 22:39, 16F
→
07/16 02:40, , 17F
07/16 02:40, 17F
→
07/16 02:40, , 18F
07/16 02:40, 18F
→
07/16 02:42, , 19F
07/16 02:42, 19F
→
07/16 02:43, , 20F
07/16 02:43, 20F
→
07/16 11:34, , 21F
07/16 11:34, 21F
→
07/16 11:35, , 22F
07/16 11:35, 22F
推
07/16 21:29, , 23F
07/16 21:29, 23F
推
07/18 17:44, , 24F
07/18 17:44, 24F
→
07/18 17:45, , 25F
07/18 17:45, 25F
→
07/18 18:06, , 26F
07/18 18:06, 26F
討論串 (同標題文章)
完整討論串 (本文為第 1 之 2 篇)：
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
4
18
6
15
