Create DELETE FROM query
| public deleteFrom ( string $table, string $primaryKey = null ) : DeleteQuery | ||
| $table | string | |
| $primaryKey | string | |
| return | DeleteQuery | |
/**
* Performs a delete query using FluentPDO
*/
public function delete($table, $key, $keyValue = null)
{
if (!$this->isConnected()) {
static::connect();
}
$this->num_queries++;
return $this->fpdo->deleteFrom($table)->where($key, $keyValue)->execute();
}
$data = $app->request->post();
if (empty($data)) {
$data = json_decode($app->request->getBody(), true);
}
$savedId = $fpdo->insertInto('persons', $data)->execute();
if (!$savedId) {
throw new \Exception('Saving person failed.');
}
$app->render(200, ['saved' => true, 'id' => $savedId]);
});
// PUT /persons/:id
$app->put('/persons/:id', function ($id) use($app, $fpdo) {
$data = $app->request->post();
if (empty($data)) {
$data = json_decode($app->request->getBody(), true);
}
$updated = $fpdo->update('persons', $data, $id)->execute();
if (!$updated) {
throw new \Exception('Person with id ' . $id . ' does not exist.');
}
$app->render(200, ['updated' => true, 'id' => $id]);
});
// DELETE /persons/:id
$app->delete('/persons/:id', function ($id) use($app, $fpdo) {
$deleted = $fpdo->deleteFrom('persons', $id)->execute();
if (!$deleted) {
throw new \Exception('Person with id ' . $id . ' does not exist.');
}
$app->render(200, ['deleted' => $deleted]);
});
$app->run();