Method PUT

PUT is on of for update your data in table

$app->put('/updatemovie/{id}', function($request, $response){
    try{
        $id  = $request->getAttribute('id');
        $con    = getDB();
        $sql    = "UPDATE t_movie SET movie_title = :movie_title, movie_rate = :movie_rate WHERE id_movie = :id_movie";
        $pre    = $con->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
        $values = array(
            ':movie_title'  => $request->getParam('movie_title'),
            ':movie_rate'   => $request->getParam('movie_rate'),
            ':id_movie'     => $id
        );
        $result = $pre->execute($values);

        if($result){
            return $response->withJson(array('status' => 'Movie Updated'), 200);
        }else{
            return $response->withJson(array('status' => 'Movies Not Updated'),422);
        }
    }
    catch(\Exception $ex){
        return $response->withJson(array('error' => $ex->getMessage()),422);
    }
});

results matching ""

    No results matching ""