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 = '' . htmlspecialchars($key) . ' | '; //} //$html .= '
---|
' . htmlspecialchars($value2) . ' | '; } $html .= '
"Wing Delivery Hub International offers great rates and service for our shipments. The Representatives are dependable, quick and very responsive to our bookings requests. Working with the Amerijet team is always convenient and easy, and we are looking forward to doing more business in the future".
"In our many years doing business with Wing Delivery Hub, we have found them to be especially efficient and a great partner. They have been a major factor in growing our import business their slogan "We take It There", is on the mark for our business. It should say "We Take It Here – On Time, intact and always ready to go…Thank you Wing Delivery Hub".
"I find Wing Delivery Hub highly dependable. There were times when my consignments had to be collected from different locations within the country. WFS organized for the goods to be collected and packed; saving me a lot of trouble. They also arranged for consolidated shipment for these consignments which greatly brought down the shipping cost.".
"I rely only on Wing Delivery Hub Company for all my import related needs in UK. Working with A.L. is always a pleasure. Having interacted with the company for several years I have noticed that they work with clockwork precession. Everything in the company is streamlined to perfection".
"Our experience with Wing Delivery Hub has been one of complete satisfaction. The company comprises of highly dedicated and skilled professionals that make a sincere effort to cater to our requests.".
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.
+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.
+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.
+With Wing Delivery Hub, your shipment is guaranteed, we have fast and reliable fleets and trucks to deliver your shipment at anytime.
+