PDO ব্যবহার করে PHP তে কীভাবে লগইন এবং সাইনআপ সিস্টেম তৈরি করবেন?

*/ ld-auth (Parent Folder or Project)
    */ assets (Our Css And Js Lives Here)
        */ css
    */controller
        /Controller.php
        /Dashboard.php
        /Login.php
        /Logout.php
        /Register.php
    */Model
        /DashboardModel.php
        /Db.php
        /LoginModel.php
        /RegisterModel.php
    dashboard.php
    index.php
    logout.php
    nav.php
    register.php

<?php
 class Db {
 protected $dbName = 'learning_dollars_db'; /** Database Name */
 protected $dbHost = 'localhost'; /** Database Host */
 protected $dbUser = 'root'; /** Database Root */
 protected $dbPass = ''; /** Databse Password */
 protected $dbHandler, $dbStmt;
 
 /**
 * @param null|void
 * @return null|void
 * @desc Creates or resume an existing database connection...
 **/
 public function __construct()
 {
 // Create a DSN Resource...
 $Dsn = "mysql:host=" . $this->dbHost . ';dbname=' . $this->dbName;
 //create a pdo options array
 $Options = array(
 PDO::ATTR_PERSISTENT => true,
 PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
 );
 try {
 $this->dbHandler = new PDO($Dsn, $this->dbUser, $this->dbPass, $Options);
 } catch (Exception $e) {
 var_dump('Couldn\'t Establish A Database Connection. Due to the following reason: ' . $e->getMessage());
 }
 }
 
 
 /**
 * @param string
 * @return null|void
 * @desc Creates a PDO statement object
 **/
 public function query($query)
 {
 $this->dbStmt = $this->dbHandler->prepare($query);
 }
 
 
 /**
 * @param string|integer|
 * @return null|void
 * @desc Matches the correct datatype to the PDO Statement Object.
 **/
 public function bind($param, $value, $type = null)
 {
 if (is_null($type)) {
 switch (true) {
 case is_int($value):
 $type = PDO::PARAM_INT;
 break;
 case is_bool($value):
 $type = PDO::PARAM_BOOL;
 break;
 case is_null($value):
 $type = PDO::PARAM_NULL;
 break;
 default:
 $type = PDO::PARAM_STR;
 break;
 }
 }
 
 $this->dbStmt->bindValue($param, $value, $type);
 }
 
 
 /**
 * @param null|void
 * @return null|void
 * @desc Executes a PDO Statement Object or a db query...
 **/
 public function execute()
 {
 $this->dbStmt->execute();
 return true;
 }
 
 /**
 * @param null|void
 * @return null|void
 * @desc Executes a PDO Statement Object an returns a single database record as an associative array...
 **/
 public function fetch()
 {
 $this->execute();
 return $this->dbStmt->fetch(PDO::FETCH_ASSOC);
 }
 
 /**
 * @param null|void
 * @return null|void
 * @desc Executes a PDO Statement Object an returns nultiple database record as an associative array...
 **/
 public function fetchAll()
 {
 $this->execute();
 return $this->dbStmt->fetchAll(PDO::FETCH_ASSOC);
 }
 }
 ?>

<?php
 require_once(__dir__ . '/Db.php');
 class LoginModel extends Db {
 
 /**
 * @param string
 * @return array
 * @desc Returns a user record based on the method parameter....
 **/
 public function fetchEmail(string $email) :array
 {
 $this->query("SELECT * FROM `db_user` WHERE `email` = :email");
 $this->bind('email', $email);
 $this->execute();
 
 $Email = $this->fetch();
 if (empty($Email)) {
 $Response = array(
 'status' => true,
 'data' => $Email
 );
 
 return $Response;
 }
 
 if (!empty($Email)) {
 $Response = array(
 'status' => false,
 'data' => $Email
 );
 
 return $Response;
 }
 }
 }
 ?>

<?php
 require_once(__dir__ . '/Db.php');
 class RegisterModel extends Db {
 
 /**
 * @param array
 * @return array
 * @desc Creates and returns a user record....
 **/
 public function createUser(array $user) :array
 {
 $this->query("INSERT INTO `db_user` (name, email, phone_no, password) VALUES (:name, :email, :phone_no, :password)");
 $this->bind('name', $user['name']);
 $this->bind('email', $user['email']);
 $this->bind('phone_no', $user['phone']);
 $this->bind('password', $user['password']);
 
 if ($this->execute()) {
 $Response = array(
 'status' => true,
 );
 return $Response;
 } else {
 $Response = array(
 'status' => false
 );
 return $Response;
 }
 }
 
 /**
 * @param string
 * @return array
 * @desc Returns a user record based on the method parameter....
 **/
 public function fetchUser(string $email) :array
 {
 $this->query("SELECT * FROM `db_user` WHERE `email` = :email");
 $this->bind('email', $email);
 $this->execute();
 
 $User = $this->fetch();
 if (!empty($User)) {
 $Response = array(
 'status' => true,
 'data' => $User
 );
 return $Response;
 }
 return array(
 'status' => false,
 'data' => []
 );
 }
 }
 ?>

<?php
 require_once(__dir__ . '/Db.php');
 class DashboardModel extends Db {
 
 /**
 * @param null
 * @return array
 * @desc Returns an array of news....
 **/
 public function fetchNews() :array
 {
 $this->query("SELECT * FROM `db_news` ORDER BY `id` DESC");
 $this->execute();
 $News = $this->fetchAll();
 
 if (count($News) > 0) {
 $Response = array(
 'status' => true,
 'data' => $News
 );
 return $Response;
 }
 
 $Response = array(
 'status' => false,
 'data' => []
 );
 return $Response;
 }
 
 }
 ?>

<?php
session_start();
class Controller { }
?>

<?php
 require_once(__dir__ . '/Controller.php');
 require_once('./Model/DashboardModel.php');
 class Dashboard extends Controller {
 
 public $active = 'dashboard'; //for highlighting the active link...
 private $dashboardModel;
 
 /**
 * @param null|void
 * @return null|void
 * @desc Checks if the user session is set and creates a new instance of the DashboardModel...
 **/
 public function __construct()
 {
 if (!isset($_SESSION['auth_status'])) header("Location: index.php");
 $this->dashboardModel = new DashboardModel();
 }
 
 /**
 * @param null|void
 * @return array
 * @desc Returns an array of news by calling the DashboardModel fetchNews method...
 **/
 public function getNews() :array
 {
 return $this->dashboardModel->fetchNews();
 }
 }
 ?>

<?php
require_once(__dir__ . '/Controller.php');
require_once('./Model/LoginModel.php');
 
class Login extends Controller {
 
 public $active = 'login'; //for highlighting the active link...
 private $loginModel;
 
 /**
 * @param null|void
 * @return null|void
 * @desc Checks if the user session is set and creates a new instance of the LoginModel...
 **/
 public function __construct()
 {
 if (isset($_SESSION['auth_status'])) header("Location: dashboard.php");
 $this->loginModel = new LoginModel();
 }
 
 /**
 * @param array
 * @return array|boolean
 * @desc Verifies and redirects a user by calling the login method on the LoginModel...
 **/
 public function login(array $data)
 {
 $email = stripcslashes(strip_tags($data['email']));
 $password = stripcslashes(strip_tags($data['password']));
 
 $EmailRecords = $this->loginModel->fetchEmail($email);
 
 if (!$EmailRecords['status']) {
 if (password_verify($password, $EmailRecords['data']['password'])) {
 //check if the remember_me was selected...
 $Response = array(
 'status' => true
 );
 
 $_SESSION['data'] = $EmailRecords['data'];
 $_SESSION['auth_status'] = true;
 header("Location: dashboard.php");
 }
 
 $Response = array(
 'status' => false,
 );
 return $Response;
 }
 
 $Response = array(
 'status' => false,
 );
 return $Response;
 }
}
 ?>

<?php
 require_once(__dir__ . '/Controller.php');
 require_once('./Model/RegisterModel.php');
 class Register extends Controller {
 
 public $active = 'Register'; //for highlighting the active link...
 private $registerModel;
 
 /**
 * @param null|void
 * @return null|void
 * @desc Checks if the user session is set and creates a new instance of the RegisterModel...
 **/
 public function __construct()
 {
 if (isset($_SESSION['auth_status'])) header("Location: dashboard.php");
 $this->registerModel = new RegisterModel();
 }
 
 /**
 * @param array
 * @return array|boolean
 * @desc Verifies, Creates, and returns a user by calling the register method on the RegisterModel...
 **/
 public function register(array $data)
 {
 $name = stripcslashes(strip_tags($data['name']));
 $email = stripcslashes(strip_tags($data['email']));
 $phone = stripcslashes(strip_tags($data['phone']));
 $password = stripcslashes(strip_tags($data['password']));
 
 $EmailStatus = $this->registerModel->fetchUser($email)['status'];
 
 $Error = array(
 'name' => '',
 'email' => '',
 'phone' => '',
 'password' => '',
 'status' => false
 );
 
 if (preg_match('/[^A-Za-z\s]/', $name)) {
 $Error['name'] = 'Only Alphabets are allowed.';
 return $Error;
 }
 
 if (!empty($EmailStatus)) {
 $Error['email'] = 'Sorry. This Email Address has been taken.';
 return $Error;
 }
 
 if (preg_match('/[^0-9_]/', $phone)) {
 $Error['phone'] = 'Please, use a valid phone number.';
 return $Error;
 }
 
 if (strlen($password) < 7) {
 $Error['password'] = 'Please, use a stronger password.';
 return $Error;
 }
 
 $Payload = array(
 'name' => $name,
 'email' => $email,
 'phone' => $phone,
 'password' => password_hash($password, PASSWORD_BCRYPT)
 );
 
 $Response = $this->registerModel->createUser($Payload);
 
 $Data = $this->registerModel->fetchUser($email)['data'];
 unset($Data['password']); //Makes a whole lot of sense to get rid of any critical information...
 
 if (!$Response['status']) {
 $Response['status'] = 'Sorry, An unexpected error occurred and your request could not be completed.';
 return $Response;
 }
 
 $_SESSION['data'] = $Data;
 $_SESSION['auth_status'] = true;
 header("Location: dashboard.php");
 return true;
 }
 }
 ?>

<?php
 require_once(__dir__ . '/Controller.php');
 
 class Logout extends Controller {
 
 /**
 * @param null|void
 * @return null|void
 * @desc Destroys the application session and redirects to the login page...
 **/
 public function __construct()
 {
 session_destroy();
 header("Location: index.php");
 }
 }
 ?>

<?php
 define("BASE_URL", 'http://localhost/&#39; . basename(__DIR__) . '/');
 ?>

<?php require_once('./config.php'); ?>
<!DOCTYPE html>
<html lang="en" dir="ltr">
 <head>
 <meta charset="utf-8">
 <meta name="application-name" content="LD Talent Login Project">
 <meta name="author" content="Ilori Stephen A">
 <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
 <title>LD Talent | <?php echo ucfirst($active); ?></title>
 <!-- Css Styles... -->
 <link rel="stylesheet" href="./assets/css/bootstrap.min.css">
 <link rel="stylesheet" href="./assets/css/style.css">
 <!-- Script -->
 <script src="./assets/js/jquery.js" charset="utf-8"></script>
 <script src="./assets/js/bootstrap.min.js" charset="utf-8"></script>
 </head>
 <body>
 <nav class="navbar navbar-expand-md navbar-dark fixed-top bg-dark">
 <div class="container">
 <a class="navbar-brand" href="#">LD Talent</a>
 <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarCollapse" aria-controls="navbarCollapse" aria-expanded="false" aria-label="Toggle navigation">
 <span class="navbar-toggler-icon"></span>
 </button>
 <div class="collapse navbar-collapse" id="navbarCollapse">
 <ul class="navbar-nav ml-auto">
 <?php if (!isset($_SESSION['auth_status'])) : ?>
 <li class="nav-item">
 <a class="nav-link <?php if (strtolower($active) === 'login') echo 'active'; ?>" href="<?php echo BASE_URL; ?>index.php">Login</a>
 </li>
 <li class="nav-item">
 <a class="nav-link <?php if (strtolower($active) === 'register') echo 'active'; ?>" href="<?php echo BASE_URL; ?>register.php" tabindex="-1" aria-disabled="true">Register</a>
 </li>
 <?php elseif (isset($_SESSION['auth_status'])) : ?>
 <li class="nav-item">
 <a href="<?php echo BASE_URL; ?>dashboard.php" class="nav-link <?php if (strtolower($active) === 'dashboard') echo 'active'; ?>">Dashboard</a>
 </li>
 <?php endif; ?>
 <?php if (isset($_SESSION['auth_status'])) : ?>
 <li class="nav-item">
 <a class="nav-link" href="<?php echo BASE_URL; ?>logout.php">Logout</a>
 </li>
 <?php endif; ?>
 </ul>
 </div>
 </div>
 </nav>

<?php require_once('./controller/Login.php'); ?>
<?php
 $Login = new Login();
 $Response = [];
 $active = $Login->active;
 if (isset($_POST) && count($_POST) > 0) $Response = $Login->login($_POST);
?>
 <?php require('./nav.php'); ?>
 <main role="main" class="container">
 <div class="container">
 <div class="row justify-content-center mt-10">
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-4 col-lg-4 center-align center-block">
 <?php if (isset($Response['status']) && !$Response['status']) : ?>
 <div class="alert alert-danger" role="alert">
 <span><B>Oops!</B> Invalid Credentials Used.</span>
 <button type="button" class="close" data-dismiss="alert" aria-label="Close">
 <span aria-hidden="true" class="text-danger">&times;</span>
 </button>
 </div>
 <?php endif; ?>
 <div class="card shadow-lg p-3 mb-5 bg-white rounded">
 <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" class="form-signin">
 <h4 class="h3 mb-3 font-weight-normal text-center">Sign in</h4>
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-12 col-lg-12 mt-4">
 <div class="form-group">
 <label for="inputEmail" class="sr-only">Email address</label>
 <input type="email" id="inputEmail" class="form-control" placeholder="Email address" name="email" required autofocus>
 </div>
 </div>
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-12 col-lg-12">
 <div class="form-group">
 <label for="inputPassword" class="sr-only">Password</label>
 <input type="password" name="password" id="inputPassword" class="form-control" placeholder="Password" required>
 </div>
 </div>
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-12 col-lg-12">
 <button class="btn btn-md btn-primary btn-block" type="submit">Sign in</button>
 </div>
 <p class="mt-5 text-center mb-3 text-muted">&copy; Ilori Stephen A <?php echo date('Y'); ?></p>
 </form>
 </div>
 </div>
 </div>
 </div>
 </main>
 </body>
 </html>

<?php require_once('./controller/Register.php'); ?>
<?php
 $Register = new Register();
 $Response = [];
 $active = $Register->active;
 if (isset($_POST) && count($_POST) > 0) $Response = $Register->register($_POST);
?>
<?php require('./nav.php'); ?>
 <main role="main" class="container">
 <div class="container">
 <div class="row justify-content-center mt-5">
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-4 col-lg-4 center-align center-block">
 <?php if (isset($Response['status']) && !$Response['status']) : ?>
 <br>
 <div class="alert alert-danger" role="alert">
 <span><B>Oops!</B> Some errors occurred in your form.</span>
 <button type="button" class="close" data-dismiss="alert" aria-label="Close">
 <span aria-hidden="true" class="text-danger">&times;</span>
 </button>
 </div>
 <?php endif; ?>
 <div class="card shadow-lg p-3 mb-5 bg-white rounded">
 <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" class="form-signin">
 <h4 class="h3 mb-3 font-weight-normal text-center">Register</h4>
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-12 col-lg-12 mt-4">
 <div class="form-group">
 <label for="inputName" class="sr-only">Names</label>
 <input type="text" id="inputName" class="form-control" placeholder="Enter Full Name" name="name" required autofocus value="<?php if (isset($_POST['name'])) echo $_POST['name']; ?>">
 <?php if (isset($Response['name']) && !empty($Response['name'])): ?>
 <small class="text-danger"><?php echo $Response['name']; ?></small>
 <?php endif; ?>
 </div>
 </div>
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-12 col-lg-12 mt-4">
 <div class="form-group">
 <label for="inputEmail" class="sr-only">Email</label>
 <input type="email" id="inputEmail" class="form-control" placeholder="Enter Email Address" name="email" required autofocus value="<?php if (isset($_POST['email'])) echo $_POST['email']; ?>">
 <?php if (isset($Response['email']) && !empty($Response['email'])): ?>
 <small class="text-danger"><?php echo $Response['email']; ?></small>
 <?php endif; ?>
 </div>
 </div>
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-12 col-lg-12 mt-4">
 <div class="form-group">
 <label for="inputPhone" class="sr-only">Phone Number</label>
 <input type="text" id="inputPhone" class="form-control" placeholder="Enter Phone" name="phone" required autofocus value="<?php if (isset($_POST['phone'])) echo $_POST['phone'] ?>">
 <?php if (isset($Response['phone']) && !empty($Response['phone'])): ?>
 <small class="text-danger"><?php echo $Response['phone']; ?></small>
 <?php endif; ?>
 </div>
 </div>
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-12 col-lg-12">
 <div class="form-group">
 <label for="inputPassword" class="sr-only">Password</label>
 <input type="password" name="password" id="inputPassword" class="form-control" placeholder="Password" required>
 <?php if (isset($Response['password']) && !empty($Response['password'])): ?>
 <small class="text-danger"><?php echo $Response['password']; ?></small>
 <?php endif; ?>
 </div>
 </div>
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-12 col-lg-12">
 <button class="btn btn-md btn-primary btn-block" type="submit">Register</button>
 </div>
 <p class="mt-5 text-center mb-3 text-muted">&copy; Ilori Stephen A <?php echo date('Y'); ?></p>
 </form>
 </div>
 </div>
 </div>
 </div>
 </main>
</body>
</html>

<?php require_once('./controller/Dashboard.php'); ?>
<?php
 $Dashboard = new Dashboard();
 $Response = [];
 $active = $Dashboard->active;
 $News = $Dashboard->getNews();
?>
<?php require('./nav.php'); ?>
<main role="main" class="container">
 <div class="container">
 <div class="row mt-5">
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-12 col-lg-12">
 <h2>News</h2>
 <hr>
 </div>
 </div>
 <div class="row">
 <?php if ($News['status']) : ?>
 <?php foreach ($News['data'] as $new) : ?>
 <div class="col-xs-12 col-sm-12 col-md-12 col-xl-4 col-lg-4">
 <div class="card shadow-lg p-3 mb-5 bg-white rounded">
 <div class="news_title">
 <h3><?php echo ucwords($new['title']); ?></h3>
 </div>
 <div class="news_body">
 <p><?php echo $new['content']; ?> <a href="javascript:void(0)">Read More</a></p>
 </div>
 </div>
 </div>
 <?php endforeach; ?>
 <?php endif; ?>
 </div>
 </div>
</main>
</body>
</html>

<?php require_once('./controller/Logout.php'); ?>
<?php new Logout(); ?>