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

results matching ""

    No results matching ""