$dbhost = 'localhost'; $dbuser = '******'; $dbpass = '******'; $dbname = 'car_park'; $dbmethod = 'mysql:dbname='; $dsn = $dbmethod . $dbname; $pdo = new PDO($dsn, $dbuser, $dbpass); $db = new NotORM($pdo); $app->post('/car', function ($req, $res, $args) use($db) { $car = $req->getParsedBody(); $result = $db->cars->insert($car); return $res->write($result['id']); }); $app->get('/cars', function ($req, $res, $args) use($db) { $cars = array(); foreach ($db->cars() as $car) { $cars[] = array('number' => $car['number'], 'region' => $car['region'], 'ticket' => $car['ticket']); } return $res->withHeader('Content-Type', 'application/json')->write(json_encode($cars)); }); $app->delete('/car/{num}/{region}', function ($req, $res, $args) use($db) { $num = $args['num']; $region = $args['region']; $car = $db->cars()->where(array("number" => $num, "region" => $region)); if ($car->fetch()) { $result = $car->delete(); $responseBody = json_encode(array("status" => true, "message" => "Car deleted successfully.")); } else { $responseBody = json_encode(array("status" => false, "message" => "Car with {$num} number and {$region} region does not exist.")); } return $res->withHeader('Content-Type', 'application/json')->write($responseBody);
$dbuser = '******'; $dbpass = '******'; $dbname = 'garage'; // get it open... $dsn = 'mysql:host=' . $dbhost . ';dbname=' . $dbname; $pdo = new PDO($dsn, $dbuser, $dbpass); $db = new NotORM($pdo); /* Routes */ // Home route ... not actually part of REST api... $app->get('/', function () { echo 'Home - My Slim Application'; }); // Get all cars $app->get('/cars', function () use($app, $db) { $cars = array(); foreach ($db->cars() as $car) { $cars[] = array('id' => $car['id'], 'year' => $car['year'], 'make' => $car['make'], 'model' => $car['model']); } $app->response()->header("Content-Type", "application/json"); echo json_encode($cars, JSON_FORCE_OBJECT); }); // Get a single car $app->get('/cars/:id', function ($id) use($app, $db) { $app->response()->header("Content-Type", "application/json"); $car = $db->cars()->where('id', $id); if ($data = $car->fetch()) { echo json_encode(array('id' => $data['id'], 'year' => $data['year'], 'make' => $data['make'], 'model' => $data['model'])); } else { echo json_encode(array('status' => false, 'message' => "Car ID {$id} does not exist")); } });