Method DELETE
This method used for delete or remove your data in the table
$app->delete('/deletemovie/{id}', function($request, $response){
$id = $request->getAttribute('id');
$con = getDB();
$sql = "DELETE FROM t_movie WHERE id_movie = :id_movie";
$pre = $con->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$values = array(
':id_movie' => $id
);
$result = $pre->execute($values);
if($result){
return $response->withJson(array('status' => 'Movie Deleted'), 200);
}else{
return $response->withJson(array('status' => 'Movies Not Deleted'),422);
}
});
$app->run();