prepare("SELECT * FROM shipments WHERE tracking_number = ?"); $stmt->bind_param("s", $tracking); $stmt->execute(); $result = $stmt->get_result(); $shipment = $result->fetch_assoc(); $logs = []; $currentLocation = "Not Available"; if ($shipment) { $logQuery = $conn->query("SELECT * FROM shipment_logs WHERE shipment_id={$shipment['id']} ORDER BY log_date DESC"); while($row = $logQuery->fetch_assoc()) { $logs[] = $row; } // Current location from latest log if (!empty($logs)) { $currentLocation = $logs[0]['location']; } } ?> Tracking
Shipment Tracking #:
Current Location:
Current Status:
$step): ?>

Origin

Destination

Shipment Details

Type

Weight

Shipment Date

Expected Delivery

Shipment Content

S/N Description Quantity

Tracking History


- Signed by:

No shipment found

Need any help?
contact us!