prepare( "INSERT INTO `vehicle_master` (`vehicle_no`, `vehicle_model`, `vehicle_capacity`, `vehicle_insurance_validy`, `status`, `created_at`) VALUES (?, ?, ?, ?, ?, ?)" ); if (! $stmt) { die("Prepare failed: " . $conn->error); } $stmt->bind_param("ssssss", $vehicle_no, $vehicle_model, $vehicle_capacity, $vehicle_insurance_validy, $status, $created_at); if (! $stmt->execute()) { die("Vehicle insert failed: " . $stmt->error); } $vehicle_id = $conn->insert_id; $stmt->close(); $stmt2 = $conn->prepare( "INSERT INTO `broker_master` (`vehicle_id`, `transporter_name`, `status`, `created_at`, `updated_at`) VALUES (?, ?, ?, ?, ?)" ); if (! $stmt2) { die("Prepare broker insert failed: " . $conn->error); } $stmt2->bind_param("issss", $vehicle_id, $transporter_name, $status, $created_at, $created_at); if ($stmt2->execute()) { echo ""; } else { die("Broker insert failed: " . $stmt2->error); } $stmt2->close(); } require_once('includes/header.php'); ?>

Transporter Dashboard

Transporter's Inventory
query($query); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { echo ""; } } else { echo ''; } ?>
ID Transportar Name Vehicle Number Vehicle Model Vehicle Capacity Vehicle Insurance Valid Actions
{$row['id']} {$row['transporter_name']} {$row['vehicle_no']} {$row['vehicle_model']} {$row['vehicle_capacity']} {$row['vehicle_insurance_validy']}
No records found.