get_expert_schedules.php

<?php
header('Content-Type: application/json');
require_once 'db/config.php';

if (!isset($_GET['expert_id'])) {
    echo json_encode([]);
    exit();
}

$expert_id = $_GET['expert_id'];

// Get available schedules for the expert
$sql = "
    SELECT 
        s.shid,
        s.eid,
        s.schedule_date,
        s.start_time,
        s.end_time,
        s.session_type,
        s.max_appointments,
        s.current_appointments,
        s.notes,
        s.status
    FROM schedule s
    WHERE s.eid = ? 
    AND s.schedule_date >= CURDATE()
    AND s.status = 'available'
    ORDER BY s.schedule_date ASC, s.start_time ASC
";

$stmt = $conn->prepare($sql);
if ($stmt) {
    $stmt->bind_param("i", $expert_id);
    $stmt->execute();
    $result = $stmt->get_result();
    
    $schedules = [];
    while ($row = $result->fetch_assoc()) {
        $schedules[] = $row;
    }
    
    echo json_encode($schedules);
    $stmt->close();
} else {
    echo json_encode([]);
}
?>