Primary Specialty:
Qualifications:
Additional Specialities:
Contact Phone:
Consultation Fee: $
Availability:
Affiliated Hospital
, , ,
prepare("SELECT d.full_name, d.email, d.specialty, d.qualifications, d.specialities, d.contact_phone, d.license_number, d.consultation_fee, d.availability, h.hospital_name, h.address, h.city, h.state, h.country FROM doctors d LEFT JOIN hospitals h ON d.hospital_id = h.id WHERE d.id = ?"); $stmt->execute([$doctorId]); $doctor = $stmt->fetch(PDO::FETCH_ASSOC); if (!$doctor) { $error_message = "Doctor not found."; } } catch (PDOException $e) { $error_message = "Database error: " . $e->getMessage(); } } else { $error_message = "No doctor ID provided."; } ?>
Primary Specialty:
Qualifications:
Additional Specialities:
Contact Phone:
Consultation Fee: $
Availability:
, , ,