How to develop PHP web service part 3: Connecting to Database and get result in JSON formate

You haven’t read my previous tutorial then read them by the following link

How to develop php web service part 1:Basic set-up for development

How to connect to a database using you PHP RESTful API

Constants.php file code as below

//Constants.php file
<?php
//Constants to connect with the database
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_HOST', 'localhost');
define('DB_NAME', 'logindetail');
define('USER_CREATED_SUCCESSFULLY', 0);
define('USER_CREATE_FAILED', 1);
define('USER_ALREADY_EXISTED', 2);
?>

DbConnect.php code as below

<?php
class DbConnect {
      private $conn;
      function __construct() {}
/**
Establishing database connection
@return database connection handler
*/
function connect() {

       //include_once dirname(__FILE__) . './Constants.php';

       include_once 'Constants.php';  // we can use above code also

       // Connecting to mysql database

       $this->conn = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);

       // Check for database connection error

       if (mysqli_connect_errno()) {

           echo "Failed to connect to MySQL: " . mysqli_connect_error();

       }

        // returing connection resource

        return $this->conn;

     }

}

?>

PassHash.php  code as below

<?php

class PassHash {
 
    // blowfish
    private static $algo = '$2a';
    // cost parameter
    private static $cost = '$10';
 
    // mainly for internal use
    public static function unique_salt() {
        return substr(sha1(mt_rand()), 0, 22);
    }
 
    // this will be used to generate a hash
    public static function hash($password) {
 
        return crypt($password, self::$algo .
                self::$cost .
                '$' . self::unique_salt());
    }
 
    // this will be used to compare a password against a hash
    public static function check_password($hash, $password) { //first from db second from user
    
        $full_salt = substr($hash, 0, 29);
        $new_hash = crypt($password, $full_salt);
        
        return ($hash == $new_hash);
     
        //$new_hash = crypt($password, $full_salt);
         //echo $new_hash;
        //return ($new_hash_pass == $password);
    }
 
}

In index.php file write login and registration web service call as below

<?php
use PsrHttpMessageServerRequestInterface as Request;
use PsrHttpMessageResponseInterface as Response;
require '../vendor/autoload.php';
require '../include/Constants.php';
require '../include/DbOperation.php';
$app = new SlimApp(['settings' => ['displayErrorDetails' => true]]);
$app->get('/hello/{name}', function (Request $request, Response $response) {
    $name = $request->getAttribute('name');
    $response->getBody()->write("Hello, $name");
    return $response;]
});
//this method will create a student    ['settings' => ['displayErrorDetails' => true]]
//the first parameter is the URL address that will be added at last to the root url
//The method is post
$app->post('/register', function (Request $request, Response $response) use ($app) {
    //Creating a response array
    $response = array();
    //reading post parameters
    $parms = $request->getParsedBody();
    $password = $parms['password'];
    $email = $parms['email'];
    $name = $parms['name'];
    //Creating a DbOperation object
    require '../include/DbConnect.php';
    $db = new DbOperation();
    $res = $db->createUser($name, $email, $password);
    if ($res == USER_CREATED_SUCCESSFULLY) {
        $response["error"] = false;
        //$response["message"] = "You are successfully registered";
        $response["message"] = $db->getUserByEmail($email);
        //echoRespnse(201, $response);
        echo json_encode($response);
    } else if ($res == USER_CREATE_FAILED) {
        $response["error"] = true;
        $response["message"] = "Oops! An error occurred while registereing";
        //echoRespnse(200, $response);
        echo json_encode($response);
    } else if ($res == USER_ALREADY_EXISTED) {
        $response["error"] = true;
        $response["message"] = "Sorry, this email already existed";
        //echoRespnse(200, $response);
        echo json_encode($response);
    }]
});
$app->post('/login', function(Request $request, Response $response)use($app) {
    //Creating a response array
    $response = array();
    //reading post parameters
    $parms = $request->getParsedBody();
    $email = $parms['email'];
    $password = $parms['password'];
    require '../include/DbConnect.php';
    $db = new DbOperation();
    if ($db->checkLogin($email, $password)) {
        // get the user by email
        $user = $db->getUserByEmail($email);
        if ($user != NULL) {
            $response["error"] = false;
            $response['message'] = $user;
            echo json_encode($response);
        } else {
            // unknown error occurred
            $response['error'] = true;
            $response['message'] = "An error occurred. Please try again";
            echo json_encode($response);
        }
    } else {
        // user credentials are wrong
        $response['error'] = true;
        $response['message'] = 'Login failed. Incorrect credentials';
        echo json_encode($response);
    }
});
$app->run();
?>

http://localhost/webAppTest/V1/register

Body as shown in the following picture. content-type application/json should be in the header section