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
Need any help?
contact us!