PHP Driver::select Examples

Example #1

File: main.php Project: rhalf/app_track

Flight::route('GET /v1/main/driver', function () {
    $company = Flight::request()->query->company;
    try {
        if ($company) {
            $array = Driver::selectByCompany($company);
        } else {
            $array = Driver::selectAll();
        }
        Flight::ok($array);
    } catch (Exception $exception) {
        Flight::error($exception);
    }
});
Flight::route('GET /v1/main/driver/@id', function ($id) {
    try {
        $object = Driver::select($id);
        Flight::ok($object);
    } catch (Exception $exception) {
        Flight::error($exception);
    }
});
Flight::route('POST /v1/main/driver', function () {
    try {
        $object = Driver::insert();
        Flight::ok($object);
    } catch (Exception $exception) {
        Flight::error($exception);
    }
});
Flight::route('PUT /v1/main/driver/@id', function ($id) {
    try {

Example #2

File: vehicle.php Project: rhalf/app_track

 public static function selectByCompany($id)
 {
     $connection = Flight::dbMain();
     try {
         $sql = "SELECT * FROM vehicle WHERE company_id = :company;";
         $query = $connection->prepare($sql);
         $query->bindParam(':company', $id, PDO::PARAM_INT);
         $query->execute();
         $rows = $query->fetchAll(PDO::FETCH_ASSOC);
         $result = array();
         foreach ($rows as $row) {
             $vehicle = new Vehicle();
             $vehicle->Id = (int) $row['id'];
             $vehicle->DtCreated = $row['vehicle_dt_created'];
             $vehicle->DtSubscribed = $row['vehicle_dt_subscribed'];
             $vehicle->Plate = $row['vehicle_plate'];
             $vehicle->Name = $row['vehicle_name'];
             $vehicle->Model = $row['vehicle_model'];
             $vehicle->MaInitial = (int) $row['vehicle_ma_initial'];
             $vehicle->MaLimit = (int) $row['vehicle_ma_limit'];
             $vehicle->MaMaintenance = (int) $row['vehicle_ma_maintenance'];
             $vehicle->SpeedMax = (int) $row['vehicle_speed_max'];
             $vehicle->FuelMax = (int) $row['vehicle_fuel_max'];
             // $vehicle->Status = (int)$row['e_status_id'];
             // $vehicle->Driver =  $row['driver_id'] == null ? null : (int)$row['driver_id'];
             // $vehicle->Unit = $row['unit_id'] == null ? null : (int)$row['unit_id'];
             // $vehicle->Company = (int) $row['company_id'];
             // $vehicle->TrackeeType = (int) $row['e_trackee_type_id'];
             $vehicle->Status = (int) $row['e_status_id'];
             $vehicle->Driver = Driver::select($row['driver_id']);
             $vehicle->Unit = Unit::select($row['unit_id']);
             $vehicle->Company = Company::select($row['company_id']);
             $vehicle->TrackeeType = TrackeeType::select($row['e_trackee_type_id']);
             $vehicle->Status = Status::select($row['e_status_id']);
             array_push($result, $vehicle);
         }
         return $result;
     } catch (PDOException $pdoException) {
         throw $pdoException;
     } catch (Exception $exception) {
         throw $exception;
     } finally {
         $connection = null;
     }
 }