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