query("SELECT invoice_no FROM ds_invoice WHERE invoice_no = '".$ip_invoiceNo."'"); // 4nd Query $result = $db->query("call SP_Web_based_Barcode_tracking_history_Details('".$ip_referenceNo."')"); if($result){ // Cycle through results while ($row = $result->fetch_object()){ //print_r($row); $referenceNo = $row->barcode_no; } // Free result set $result->close(); $db->next_result(); } if($referenceNo != $ip_referenceNo) { $referenceNoErr = "Invalid reference No"; } } ?>

Track your shipment

Track an Order

Enter the order number you would like to track in the form below.

query("call SP_Web_Tracking_Barcode_Details('".$referenceNo."')"); if($result){ while ($row = $result->fetch_object()){ $invoice_no = $row->Invoice_no; $Ctn_No = $row->total_Pcs; $Transit_Date = $row->Invoice_date; $weight = $row->total_wt; $Current_Location = $row->origin; $destination=$row->destination; $invoice_status = str_replace("_"," ",$row->shipment_status); $scheduled_date=$row->assuredDeliveryDate; ?>
Scheduled Delivery Date :

Shipment Status

Docket Number Booking Date Total Carton Total Weight Origin Destination Status
close(); $db->next_result(); } ?>
query("call SP_Web_based_Barcode_tracking_history_Details('".$referenceNo."')"); if($result){ // Cycle through results ?>

Transaction History

fetch_object()){ //print_r($row); $Carton_No = $row->barcode_no; $Transit_Date = $row->Transit_Date; $Origin = $row->Origin; $Destination = $row->Destination; //$Operation = $row->Operation; $Ctn_Status =str_replace("_"," ",$row->Ctn_Status); ?>
Barcode No Date Origin Destination Status
close(); $db->next_result(); } else echo($db->error); // Close connection $db->close(); }?>