public function TrackBook() { $connector = new connector(); $sql = ""; $sql .= " SELECT"; $sql .= " ReferenceNo"; $sql .= " , DelSender"; $sql .= " , DelReceiver"; $sql .= " , Status"; $sql .= " , Reason"; $sql .= " , ServiceLevel"; $sql .= " , DeliveryBoxSize"; $sql .= " , WaybillNumber"; $sql .= " , LBC "; $sql .= " FROM booking_details "; $sql .= " WHERE"; $sql .= " ReferenceNo \t= '" . $this->referenceNo . "' OR "; $sql .= " WaybillNumber \t= '" . $this->referenceNo . "' OR "; $sql .= " LBC \t\t\t= '" . $this->referenceNo . "'"; $mysqliQuery = mysqli_query($connector->GetConnection(), $sql); $counter = 0; $trackBookOutput = new TrackBookOutput(); $row = mysqli_fetch_array($mysqliQuery); $trackBookOutput->onlineReferenceNo = $row["ReferenceNo"]; $trackBookOutput->waybillNo = $row["WaybillNumber"]; $trackBookOutput->provincialTrackingNo = $row["LBC"]; $trackBookOutput->sender = $row["DelSender"]; $trackBookOutput->receiver = $row["DelReceiver"]; $trackBookOutput->latestStatus = $row["Status"]; $trackBookOutput->reason = $row["Reason"]; $trackBookOutput->serviceLevel = $row["ServiceLevel"]; $trackBookOutput->size = $row["DeliveryBoxSize"]; return $trackBookOutput; }