CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
email VARCHAR(100),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
]]>
function authenticate($username, $password) {
global $conn;
$stmt = $conn->prepare("SELECT * FROM users WHERE username = ?");
$stmt->bind_param("s", $username);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
$user = $result->fetch_assoc();
if (password_verify($password, $user['password'])) {
return true;
}
}
return false;
}
]]>
$hashed_password = password_hash($plain_password, PASSWORD_DEFAULT);
]]>
session_start();
$_SESSION['user_id'] = $user['id'];
header("Location: dashboard.php");
]]>
