public static function GetTruckDriver($truckid) { $sql = "SELECT TruckDriver FROM GPSTruck WHERE TruckID = :truckid"; $params = array(':truckid' => $truckid); $stm = pdo_execute_scalar($sql, $params); if ($stm) { return $stm; } else { return FALSE; } }
public static function CanViewPage($usernum, $customerid) { $sql = View::SELECT_CLAUSE; $params = array(':usernum' => $usernum, ':customerid' => $customerid); return pdo_execute_scalar($sql, $params); }
public function AreYouTracked($truckid) { $sql = "SELECT Tracking FROM GPSTruck WHERE TruckID = :truckid"; $params = array(':truckid' => $truckid); $tracker = pdo_execute_scalar($sql, $params); if ($tracker) { return 1; // You are a driver. } else { return 0; // You are not a driver. } }