<?php
use PsrHttpMessageServerRequestInterface as Request;
use PsrHttpMessageResponseInterface as Response;

require '../vendor/autoload.php';

function dbConnect(){
    $host='127.0.0.1';
    $user='root';
    $pass='';
    $dbname='testdbmysql';
    $pdo= new PDO("mysql:host=$host; dbname= $dbname", $user, $pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
    return $pdo;
}

$app = new SlimApp;
$app->post('/hello/{id}', function (Request $request, Response $response, $args) {
    echo "hello";
    $names = $request->getParsedBody();
    $db=dbConnect();
    $names_arr=[];
    $names_arr['name1']= filter_var($names['name1'], FILTER_SANITIZE_STRING);
    $names_arr['name2']= filter_var($names['name2'], FILTER_SANITIZE_STRING);
    $response->getBody()->write("Hello , ".$names_arr['name1']);
    $query=mysqli_prepare($db, "INSERT into info(fname, lname) VALUES(?, ?)");
    mysqli_stmt_bind_param($query, "ss", $names_arr['name1'], $names_arr['name2']);
    $result=mysqli_stmt_execute($query);
    $rows=mysqli_stmt_insert_id($query);
    echo "Rows: ".$rows;
    return $response;
});
$app->run();
?>