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();

results matching ""

    No results matching ""