prepare($query);
$stmt->bind_param("s", $tracking_id);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
$shipment = $result->fetch_assoc();
echo "Tracking ID: " . $shipment['tracking_id'] . "
";
echo "Status: " . $shipment['status'] . "
";
echo "Location: " . $shipment['location'] . "
";
echo "Updated At: " . $shipment['created_at'] . "
";
} else {
echo "Invalid Tracking ID";
}
}
?>