Method POST
In this method is you can insert data into your table
$app->post('/addmovie', function($request, $response){
try{
$con = getDB();
$sql = "INSERT INTO t_movie (movie_title, movie_rate) VALUES (:movie_title, :movie_rate)";
$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')
);
$result = $pre->execute($values);
if($result){
return $response->withJson(array('status' => 'Movie Added'), 200);
}else{
return $response->withJson(array('status' => 'Movies Not Added'),422);
}
}
catch(\Exception $ex){
return $response->withJson(array('error' => $ex->getMessage()),422);
}
});