setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
if ($init) {
$pdo->exec('CREATE TABLE users (id INTEGER PRIMARY KEY, username TEXT UNIQUE, password TEXT)');
// store password hashed (password_hash)
$pw = password_hash('password123', PASSWORD_DEFAULT);
$stmt = $pdo->prepare('INSERT INTO users (username, password) VALUES (?, ?)');
$stmt->execute(['student', $pw]);
}
} catch (Exception $e) {
die('DB error: ' . $e->getMessage());
}
$err = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$u = $_POST['username'] ?? '';
$p = $_POST['password'] ?? '';
$stmt = $pdo->prepare('SELECT * FROM users WHERE username = ? LIMIT 1');
$stmt->execute([$u]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
if ($user && password_verify($p, $user['password'])) {
// Login success
header('Location: assignment11_dashboard.php?user=' . urlencode($u));
exit;
} else {
$err = 'Invalid credentials';
}
}
?>
Simple Login
11. Simple Login (PHP + mysql)
Sample account created if DB was missing: student / password123