<?php include 'includes/session.php'; if(isset($_POST['edit'])){ $id = $_POST['id']; $date = $_POST['date']; $doctor = $_POST['doct']; $pssn = $_POST['pssn']; $complains = $_POST['comp']; $allergies = $_POST['aller1']; $medicine = $_POST['meds1']; $treatments = $_POST['treat1']; $findings = $_POST['find1']; $sql = "UPDATE consultation SET Date_Time = '$date', Patient_SSN = '$pssn', Complains = '$complains', Allergies = '$allergies', Findings = '$findings', Doctor_SSN = '$doctor',Medicines = '$medicine',Treatments = '$treatments' WHERE nom1 = '$id'"; if($conn->query($sql)){ $_SESSION['success'] = 'Consultations updated successfully'; } else{ $_SESSION['error'] = $conn->error; } } else{ $_SESSION['error'] = 'Fill up edit form first'; } header('location:consul.php'); ?> SIMPAN PERUBAHAN