$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"));
}
});
