Login

📄 authenticate.php – PHP Script to Check MySQL and Redirect php Copy Edit connect_error) { die("Connection failed: " . $conn->connect_error); } $user_id = $_POST['user_id']; $password = $_POST['password']; // Prevent SQL injection $stmt = $conn->prepare("SELECT * FROM users WHERE user_id = ? AND password = ?"); $stmt->bind_param("ss", $user_id, $password); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows === 1) { $_SESSION['user_id'] = $user_id; header("Location: dashboard.php"); exit; } else { echo ""; } $stmt->close(); $conn->close(); ?>