'', 'name' => '', 'qualification' => '', 'speciality' => '', 'bio' => '', 'image_url' => '' ]; // --- 1. HANDLE FORM SUBMISSION (ADD OR UPDATE) --- if (isset($_POST['save_doctor'])) { $name = $conn->real_escape_string($_POST['name']); $qual = $conn->real_escape_string($_POST['qualification']); $spec = $conn->real_escape_string($_POST['speciality']); $bio = $conn->real_escape_string($_POST['bio']); // Check if updating or adding new $doc_id = $_POST['doctor_id']; // Image Upload Logic $image_query_part = ""; if (!empty($_FILES["photo"]["name"])) { $target_dir = "../assets/"; $file_name = time() . "_" . basename($_FILES["photo"]["name"]); $target_file = $target_dir . $file_name; if (move_uploaded_file($_FILES["photo"]["tmp_name"], $target_file)) { $image_query_part = ", image_url='$file_name'"; } else { $msg = "Error uploading image."; } } if (!empty($doc_id)) { // UPDATE EXISTING DOCTOR $sql = "UPDATE doctors SET name='$name', qualification='$qual', speciality='$spec', bio='$bio' $image_query_part WHERE id=$doc_id"; if ($conn->query($sql)) { $msg = "Doctor Updated Successfully!"; // Reset form after update $doc_id = ""; } else { $msg = "Error updating record: " . $conn->error; } } else { // INSERT NEW DOCTOR // For new insert, image is required if not handled differently, but here we assume file_name is set if uploaded $img_val = isset($file_name) ? $file_name : 'default.jpg'; $sql = "INSERT INTO doctors (name, qualification, speciality, bio, image_url) VALUES ('$name', '$qual', '$spec', '$bio', '$img_val')"; if ($conn->query($sql)) { $msg = "Doctor Added Successfully!"; } else { $msg = "Error adding record: " . $conn->error; } } } // --- 2. HANDLE DELETE --- if (isset($_GET['delete'])) { $id = intval($_GET['delete']); $conn->query("DELETE FROM doctors WHERE id=$id"); header("Location: doctors.php"); exit(); } // --- 3. HANDLE EDIT CLICK (FETCH DATA) --- if (isset($_GET['edit'])) { $edit_mode = true; $id = intval($_GET['edit']); $res = $conn->query("SELECT * FROM doctors WHERE id=$id"); if($res->num_rows > 0) { $doctor_data = $res->fetch_assoc(); } } ?> Manage Doctors

$msg

"; ?>
Current Image

Leave empty to keep current photo.

Current Medical Team

query("SELECT * FROM doctors ORDER BY id ASC"); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { // Card Color based on Doctor Name (Visual Aid) $borderColor = (strpos($row['name'], 'Anita') !== false) ? 'border-pink-500' : 'border-teal-500'; echo '
'; // Content echo '
'; echo ''; echo '
'; echo '

' . $row['name'] . '

'; echo '

' . $row['qualification'] . '

'; echo '

' . $row['speciality'] . '

'; echo '
'; echo '
'; // Buttons echo '
'; echo 'Edit'; echo 'Delete'; echo '
'; echo '
'; } } else { echo "

No doctors found. Add one to get started.

"; } ?>