📁 File Manager
Editing:
/home/wvl7mof7402e/www/remindyourdata.live/admin/update_medical.php
<?php include "dbconnect.php"; // Check if the form is submitted if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Get and sanitize the form input $id = $_POST['id']; $name = $con->real_escape_string($_POST['name']); $passport_no = $con->real_escape_string($_POST['passport_no']); $medical_date = $con->real_escape_string($_POST['medical_date']); $medical_exp_date = $con->real_escape_string($_POST['medical_exp_date']); $sleep = isset($_POST['sleep']) ? 1 : 0; // Handle file upload (if a file is selected) if (isset($_FILES['medical_upload']) && $_FILES['medical_upload']['error'] == UPLOAD_ERR_OK) { $medical_upload = $_FILES['medical_upload']['name']; $upload_dir = 'uploads/'; $file_path = $upload_dir . basename($medical_upload); if (move_uploaded_file($_FILES['medical_upload']['tmp_name'], $file_path)) { // File upload successful, use the new file path $medical_upload = $file_path; } else { echo "Error uploading the file."; exit; } } else { // If no file is uploaded, keep the existing file path (fetch it from the database) $query = "SELECT medical_upload FROM medical_records WHERE applicant_id = $id"; $result = $con->query($query); if ($result && $row = $result->fetch_assoc()) { $medical_upload = $row['medical_upload']; } else { $medical_upload = null; } } // Update the medical record in the medical_records table $sql = "UPDATE medical_records SET medical_date = '$medical_date', medical_exp_date = '$medical_exp_date', medical_upload = '$medical_upload', sleep = '$sleep' WHERE applicant_id = $id"; if ($con->query($sql)) { // Redirect to a page (e.g., a list of records) after successful update header("Location: medicallist.php"); exit; } else { echo "Error updating record: " . $con->error; } } ?>
Save
Cancel