public static function select($id) { $connection = Flight::dbMain(); try { $sql = "SELECT * FROM company_address WHERE id = :id;"; $query = $connection->prepare($sql); $query->bindParam(':id', $id, PDO::PARAM_INT); $query->execute(); if ($query->rowCount() < 1) { return null; } $row = $query->fetch(PDO::FETCH_ASSOC); $address = new Address(); $address->Id = (int) $row['id']; $address->Name = $row['address_name']; $address->Full = $row['address_full']; $address->Coordinate = new Coordinate((double) $row['address_latitude'], (double) $row['address_longitude']); $address->Country = $row['address_country']; $address->City = $row['address_city']; $address->Area = $row['address_area']; $address->Nation = Nation::select($row['e_nation_id']); return $address; } catch (PDOException $pdoException) { throw $pdoException; } catch (Exception $exception) { throw $exception; } finally { $connection = null; } }
public static function select($id) { $connection = Flight::dbMain(); try { $sql = "SELECT * FROM e_sim_vendor WHERE id = :id;"; $query = $connection->prepare($sql); $query->bindParam(':id', $id, PDO::PARAM_INT); $query->execute(); if ($query->rowCount() < 1) { return null; } $row = $query->fetch(PDO::FETCH_ASSOC); $simVendor = new SimVendor(); $simVendor->Id = (int) $row['id']; $simVendor->Name = $row['sim_vendor_name']; $simVendor->Desc = $row['sim_vendor_desc']; $simVendor->Nation = Nation::select($row['e_nation_id']); return $simVendor; } catch (PDOException $pdoException) { throw $pdoException; } catch (Exception $exception) { throw $exception; } finally { $connection = null; } }
} }); //============================================================================= //Nation //============================================================================= Flight::route('GET /v1/main/nation', function () { try { $array = Nation::selectAll(); Flight::ok($array); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('GET /v1/main/nation/@id', function ($id) { try { $object = Nation::select($id); Flight::ok($object); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('POST /v1/main/nation', function () { try { $object = Nation::insert(); Flight::ok($object); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('PUT /v1/main/nation/@id', function ($id) { try {