Error: Cannot find db_connect.php!
Make sure it is in public_html folder."); } include '../db_connect.php'; if ($_SERVER["REQUEST_METHOD"] == "POST") { $username = $conn->real_escape_string($_POST['username']); $password = $conn->real_escape_string($_POST['password']); // 3. Check if Table Exists (Common Error) $checkTable = $conn->query("SHOW TABLES LIKE 'staff_users'"); if($checkTable->num_rows == 0) { die("

Error: Table 'staff_users' does not exist. Please run the SQL command from the previous step.

"); } $sql = "SELECT * FROM staff_users WHERE username = '$username' AND password = '$password'"; $result = $conn->query($sql); if ($result && $result->num_rows > 0) { $row = $result->fetch_assoc(); // Identify which doctor is logging in if ($username == 'doctor') { $_SESSION['doctor_logged_in'] = true; $_SESSION['doctor_name'] = "Dr. Gajanan Padghan"; $_SESSION['theme_color'] = "teal"; header("Location: dashboard.php"); exit(); } elseif ($username == 'anita') { $_SESSION['doctor_logged_in'] = true; $_SESSION['doctor_name'] = "Dr. Anita Padghan"; $_SESSION['theme_color'] = "pink"; header("Location: dashboard.php"); exit(); } else { $error = "Access Denied. Doctor account not recognized."; } } else { $error = "Invalid Username or Password"; } } ?> Doctor Login | Aastha Hospital

Doctor's Desk

Authorized Medical Personnel Only

$error

"; ?>