prepare($sql); $stmt->bind_param("i", $broker_id); $stmt->execute(); $res = $stmt->get_result(); if ($res->num_rows !== 1) { echo ""; exit; } $row = $res->fetch_assoc(); $stmt->close(); // 3) If form submitted, process updates if ($_SERVER['REQUEST_METHOD'] === 'POST') { // Read POSTed values $transporter_name = $_POST['transporter_name']; $vehicle_no = $_POST['vehicle_no']; $vehicle_model = $_POST['vehicle_model']; $vehicle_capacity = $_POST['vehicle_capacity']; $vehicle_insurance_validy = $_POST['vehicle_insurance_validy']; $vehicle_status = $_POST['vehicle_status']; $broker_status = $_POST['broker_status']; $updated_at = date('Y-m-d H:i:s'); // a) Update vehicle_master $upd1 = $conn->prepare(" UPDATE vehicle_master SET vehicle_no = ?, vehicle_model = ?, vehicle_capacity = ?, vehicle_insurance_validy = ?, status = ?, updated_at = ? WHERE id = ? "); $upd1->bind_param( "ssssssi", $vehicle_no, $vehicle_model, $vehicle_capacity, $vehicle_insurance_validy, $vehicle_status, $updated_at, $row['vehicle_id'] ); $ok1 = $upd1->execute(); $upd1->close(); // b) Update broker_master $upd2 = $conn->prepare(" UPDATE broker_master SET transporter_name = ?, status = ?, updated_at = ? WHERE id = ? "); $upd2->bind_param( "sisi", $transporter_name, $broker_status, $updated_at, $broker_id ); $ok2 = $upd2->execute(); $upd2->close(); if ($ok1 && $ok2) { echo ""; exit; } else { $error = $conn->error; } } // 4) Show form require_once('includes/header.php'); ?>

Edit Transporter

Cancel