Untitled

public static function register($data) {
    global $pdo;

    // Check if email already exists
    $stmt = $pdo->prepare("SELECT * FROM students WHERE email = ?");
    $stmt->execute([$data['email']]);
    if ($stmt->rowCount() > 0) {
        return ['status' => 'error', 'message' => 'Email already exists.'];
    }

    // Hash the password
    $hashedPassword = md5($data['password']);

    // FIXED: Add column list before VALUES
    $sql = "INSERT INTO students 
            (first_name, last_name, birthdate, email, password, contact, address, gender) 
            VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

    $stmt = $pdo->prepare($sql);

    $stmt->execute([
        $data['first_name'],
        $data['last_name'],
        $data['birthdate'],
        $data['email'],
        $hashedPassword,
        $data['contact'],
        $data['address'],
        $data['gender']
    ]);

    return ['status' => 'success', 'message' => 'Registration successful.'];
}