alert("Invalid Tracking number");'; $error = "Invalid Tracking number"; } else { $tracking_number = trim($_POST["tracking_number"]); } // check if tracking number exists //$sql = "SELECT * FROM packages WHERE tracking_number LIKE '%{$tracking_number}%'"; $sql = "SELECT * FROM packages WHERE tracking_number = UPPER('$tracking_number')"; if($stmt = mysqli_prepare($db, $sql)) { // Bind variables to the prepared statement as parameters //mysqli_stmt_bind_param($stmt, "s", $tracking_number); // Attempt to execute the prepared statement if(mysqli_stmt_execute($stmt)) { /* store result */ mysqli_stmt_store_result($stmt); if(mysqli_stmt_num_rows($stmt) == 1) { // tracking number is available //echo $stmt['id']; //echo "

user stat is available

"; echo ""; } else { // no tracking number echo ""; $error = "tracking number not found"; //echo "

no user stat

"; } //header("location: index.php"); //exit; } else { echo ""; $error = "Oops! couldnt check for tracking number. Please try again later."; } // Close statement mysqli_stmt_close($stmt); } if (empty($error)) { //if($query = $db->prepare("SELECT * FROM packages WHERE tracking_number LIKE '%{$tracking_number}%'")) if($query = $db->prepare("SELECT * FROM packages WHERE tracking_number = UPPER('$tracking_number')")) { //$query->bind_param('s', $email); $query->execute(); $result = $query->get_result(); $row = $result->fetch_assoc(); //destroy the session unset($_SESSION); if (ini_get("session.use_cookies")) { $params = session_get_cookie_params(); setcookie(session_name(), '', time() - 42000, $params["path"], $params["domain"], $params["secure"],$params["httponly"]); } session_destroy(); // Initialize the session session_start(); $_SESSION['tracking_id'] = $row['id']; $_SESSION['tracking_number'] = $row['tracking_number']; if(!empty($row['lat_initial'])){$_SESSION['lat_initial'] = $row['lat_initial'];}else{$_SESSION['lat_initial'] = '1';}; if(!empty($row['long_initial'])){$_SESSION['long_initial'] = $row['long_initial'];}else{$_SESSION['long_initial'] = '1';}; if(!empty($row['lat_position'])){$_SESSION['lat_position'] = $row['lat_position'];}else{$_SESSION['lat_position'] = '1';}; if(!empty($row['long_position'])){$_SESSION['long_position'] = $row['long_position'];}else{$_SESSION['long_position'] = '1';}; if(!empty($row['lat_destination'])){$_SESSION['lat_destination'] = $row['lat_destination'];}else{$_SESSION['lat_destination'] = '1';}; if(!empty($row['long_destination'])){$_SESSION['long_destination'] = $row['long_destination'];}else{$_SESSION['long_destination'] = '1';}; $_SESSION['sender_name'] = $row['sender_name']; $_SESSION['sender_address'] = $row['sender_address']; $_SESSION['sender_email'] = $row['sender_email']; $_SESSION['receiver_name'] = $row['receiver_name']; $_SESSION['receiver_address'] = $row['receiver_address']; $_SESSION['receiver_email'] = $row['receiver_email']; $_SESSION['item_type'] = $row['item_type']; $_SESSION['Weight'] = $row['Weight']; $_SESSION['Content'] = $row['Content']; $_SESSION['Value'] = $row['Value']; $_SESSION['Status'] = $row['Status']; $_SESSION['Booked_when'] = $row['Booked_when']; $_SESSION['delivery_date'] = $row['delivery_date']; if(!empty($row['postal_code'])){$_SESSION['postal_code'] = $row['postal_code'];}else{$_SESSION['postal_code'] = '1';}; $_SESSION['current_location'] = $row['current_location']; $id = $_SESSION['tracking_id']; //echo ""; mysqli_stmt_close($query); //get tracking History function build_table($array) { // start table $html = ''; //$html = ''; // header row //$html .= ''; //foreach($array[0] as $key=>$value){ //$html .= ''; //} //$html .= ''; // data rows foreach( $array as $key=>$value) { $html .= ''; foreach($value as $key2=>$value2) { $html .= ''; } $html .= ''; } // finish table and return it //$html .= '
' . htmlspecialchars($key) . '
' . htmlspecialchars($value2) . '
'; return $html; } //$query2 = "SELECT Locations, Status_Description, Dates FROM tracking_history WHERE tracking_number LIKE '%{$tracking_number}%'"; $query2 = "SELECT Locations, Status_Description, Dates FROM tracking_history WHERE tracking_number = UPPER('$tracking_number')"; if($result2 = mysqli_query($db, $query2)) { // Fetch all $data = mysqli_fetch_all($result2, MYSQLI_ASSOC); // Free result set mysqli_free_result($result2); //print_r($data[0]); //echo ""; //echo build_table($data); $tracking_history_table = build_table($data); $_SESSION['tracking_history'] = $tracking_history_table; //echo $_SESSION['tracking_history']; } else { echo ""; } //get tracking History } else { echo ""; } } mysqli_close($db); } ?> Wing Delivery Hub, We Ship
Contact Us EMAIL USinfo@byxpresslog.com
...
WORKING HOURSMon-Fri: 05.00-17.00
Sat: 05:00-08:00;
Sun: 05:00-08:00 and 18:0 0-22:00


Track Your Parcel

TRUSTED CLIENTS

Customer Testimonials

WHY CHOOSE US

What makes us stand out in the Feild of Delivery and Freight Services

  • Flexible and competitive freight Shipping Rates

    At Wing Delivery Hub, we endevour to offer flexible services, at the cheapest possible rates so as to satisfy every customers' shipping need at all levels.

    +
  • Door to door delivery cargo services

    Wing Delivery Hub has integrated freight trucking solutions for door-to-door delivery throughout the continental U.S. and other international points in our service region for commercial and residential markets. Every country has its own set of Customs rules, regulations, and restrictions. It is the shipper's responsibility to verify and provide Wing Delivery Hub with all permits, licenses, visa's and/or any other government authorization documentation prior to international shipping orders.

    +
  • Experienced and friendly staff

    Wing Delivery Hub's primary goal has always been, and will continue to be, developing long-term relationships with customers by providing first-class service, equipment, and facilities. Anlocalhostdeliverychorage Delivery Delivery Service's dedication to quality service and its entrepreneurial spirit motivate the company to constantly seek the best methods of providing optimal service to its customers.

    +
  • Quality Guaranteed Services

    With Wing Delivery Hub, your shipment is guaranteed, we have fast and reliable fleets and trucks to deliver your shipment at anytime.

    +

Projects Done
Clients Worldwide
Owned Vehicles
People In Team

TRUSTED partners

COMPANIES WE WORK WITH