prepare("UPDATE `driver_master` SET `driver_name` = ?, `mobile_no` = ?, `aadhar_no` = ?, `pan_no` = ?, `dl_no` = ?, `dl_exp_date` = ?, `updated_at` = ? WHERE `id` = ?");
if ($stmt) {
$stmt->bind_param("sssssssi", $driver_name, $mobile_no, $aadhar_no, $pan_no, $dl_no, $dl_exp_date, $updated_at, $id);
if ($stmt->execute()) {
echo "";
} else {
echo "Error updating record: " . $stmt->error;
}
$stmt->close();
} else {
echo "Failed to prepare statement: " . $conn->error;
}
exit;
}
// Fetch existing driver data
$stmt = $conn->prepare("SELECT * FROM `driver_master` WHERE `id` = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows === 0) {
echo "Driver not found.";
exit;
}
$driver = $result->fetch_assoc();
$stmt->close();
require_once('includes/header.php');
?>