• library-management-system
  • config
    • Config.php
  • class
    • Author.php
    • Books.php
    • Category.php
    • IssueBooks.php
    • Publisher.php
    • Rack.php
    • User.php
  • templates
    • footer.php
    • header.php
    • left_menus.php
    • menus.php
  • css
    • style.css
  • js
  • images
    • author.js
    • books.js
    • category.js
    • issue_books.js
    • publisher.js
    • rack.js
    • user.js
  • popup
    • add-author.php
    • add-book.php
    • add-category.php
    • add-issue-books.php
    • add-publisher.php
    • add-rack.php
    • add-user.php
• author.php
• author_action.php
• books.php
• books_action.php
• category.php
• category_action.php
• dashboard.php
• index.php
• issue_books.php
• issue_books_action.php
• logout.php
• publisher.php
• publisher_action.php
• rack.php
• rack_action.php
• user.php
• user_action.php

• Users/Members records Management
• Category records Management
• Author/Writer records Management
• Publisher records Management
• Rack records Management
• Book records Management
• Issue Books records Management

CREATE TABLE `user` (
      `id` int(11) UNSIGNED NOT NULL,
      `first_name` varchar(255) DEFAULT NULL,
      `last_name` varchar(255) DEFAULT NULL,
      `email` varchar(255) DEFAULT NULL,
      `password` varchar(64) NOT NULL,
      `role` enum('admin','user') DEFAULT 'admin'
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

    ALTER TABLE `user`
      ADD PRIMARY KEY (`id`);

    ALTER TABLE `user`
      MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

CREATE TABLE `book` (
      `bookid` int(11) NOT NULL,
      `categoryid` int(11) NOT NULL,
      `authorid` int(11) NOT NULL,
      `rackid` int(11) NOT NULL,
      `name` text NOT NULL,
      `picture` varchar(250) NOT NULL,
      `publisherid` int(11) NOT NULL,
      `isbn` varchar(30) NOT NULL,
      `no_of_copy` int(5) NOT NULL,
      `status` enum('Enable','Disable') NOT NULL,
      `added_on` datetime NOT NULL DEFAULT current_timestamp(),
      `updated_on` datetime NOT NULL DEFAULT current_timestamp()
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

    ALTER TABLE `book`
      ADD PRIMARY KEY (`bookid`);

    ALTER TABLE `book`
      MODIFY `bookid` int(11) NOT NULL AUTO_INCREMENT;

CREATE TABLE `author` (
      `authorid` int(11) NOT NULL,
      `name` varchar(200) NOT NULL,
      `status` enum('Enable','Disable') NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

    ALTER TABLE `author`
      ADD PRIMARY KEY (`authorid`);

    ALTER TABLE `author`
      MODIFY `authorid` int(11) NOT NULL AUTO_INCREMENT;

CREATE TABLE `publisher` (
      `publisherid` int(11) NOT NULL,
      `name` varchar(255) NOT NULL,
      `status` enum('Enable','Disable') NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

    ALTER TABLE `publisher`
      ADD PRIMARY KEY (`publisherid`);

    ALTER TABLE `publisher`
      MODIFY `publisherid` int(11) NOT NULL AUTO_INCREMENT;

CREATE TABLE `category` (
      `categoryid` int(11) NOT NULL,
      `name` varchar(200) NOT NULL,
      `status` enum('Enable','Disable') NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
   
    ALTER TABLE `category`
      ADD PRIMARY KEY (`categoryid`);

    ALTER TABLE `category`
      MODIFY `categoryid` int(11) NOT NULL AUTO_INCREMENT;

CREATE TABLE `rack` (
      `rackid` int(11) NOT NULL,
      `name` varchar(200) NOT NULL,
      `status` enum('Enable','Disable') NOT NULL DEFAULT 'Enable'
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

    ALTER TABLE `rack`
      ADD PRIMARY KEY (`rackid`);

    ALTER TABLE `rack`
      MODIFY `rackid` int(11) NOT NULL AUTO_INCREMENT;

CREATE TABLE `issued_book` (
      `issuebookid` int(11) NOT NULL,
      `bookid` int(11) NOT NULL,
      `userid` int(11) NOT NULL,
      `issue_date_time` datetime NOT NULL DEFAULT current_timestamp(),
      `expected_return_date` datetime NOT NULL,
      `return_date_time` datetime NOT NULL,
      `status` enum('Issued','Returned','Not Return') NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

    ALTER TABLE `issued_book`
      ADD PRIMARY KEY (`issuebookid`);

    ALTER TABLE `issued_book`
      MODIFY `issuebookid` int(11) NOT NULL AUTO_INCREMENT;

<?php

/**
 * Description of Config Class
 *
 * @author Team TechArise
 *
 * @email info@techarise.com
 */

session_start();
class Config
{

    private $host  = 'localhost';
    private $user  = 'root';
    private $password   = "";
    private $database  = "lms_DB";

    public function getConnection()
    {
        $conn = new mysqli($this->host, $this->user, $this->password, $this->database);
        if ($conn->connect_error) {
            die("Error failed to connect to MySQL: " . $conn->connect_error);
        } else {
            return $conn;
        }
    }
}
?>

<?php

/**
 * Description of User Class
 *
 * @author Team TechArise
 *
 * @email info@techarise.com
 */

class User
{

    private $userTable = 'user';
    private $conn;

    public function __construct($db)
    {
        $this->conn = $db;
    }

    public function login()
    {
        if ($this->email && $this->password) {
            $sqlQuery = "
                SELECT * FROM " . $this->userTable . " 
                WHERE email = ? AND password = ?";
            $stmt = $this->conn->prepare($sqlQuery);
            $password = md5($this->password);
            $stmt->bind_param("ss", $this->email, $password);
            $stmt->execute();
            $result = $stmt->get_result();
            if ($result->num_rows > 0) {
                $user = $result->fetch_assoc();
                $_SESSION["userid"] = $user['id'];
                $_SESSION["role"] = $user['role'];
                $_SESSION["name"] = ucfirst($user['first_name']) . " " . ucfirst($user['last_name']);;
                $_SESSION["email"] = $user['email'];
                return 1;
            } else {
                return 0;
            }
        } else {
            return 0;
        }
    }

    public function loggedIn()
    {
        if (!empty($_SESSION["userid"])) {
            return 1;
        } else {
            return 0;
        }
    }

    public function isAdmin()
    {
        if (!empty($_SESSION["userid"]) && $_SESSION["role"] == 'admin') {
            return 1;
        } else {
            return 0;
        }
    }

    public function listUsers()
    {

        $sqlQuery = "SELECT id, first_name, last_name, email, password, role
            FROM " . $this->userTable . " ";

        if (!empty($_POST["search"]["value"])) {
            $sqlQuery .= ' WHERE (id LIKE "%' . $_POST["search"]["value"] . '%" ';
            $sqlQuery .= ' OR first_name LIKE "%' . $_POST["search"]["value"] . '%" ';
            $sqlQuery .= ' OR email LIKE "%' . $_POST["search"]["value"] . '%" ';
            $sqlQuery .= ' OR password LIKE "%' . $_POST["search"]["value"] . '%" ';
            $sqlQuery .= ' OR role LIKE "%' . $_POST["search"]["value"] . '%" ';
        }

        if (!empty($_POST["order"])) {
            $sqlQuery .= 'ORDER BY ' . $_POST['order']['0']['column'] . ' ' . $_POST['order']['0']['dir'] . ' ';
        } else {
            $sqlQuery .= 'ORDER BY id DESC ';
        }

        if ($_POST["length"] != -1) {
            $sqlQuery .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
        }

        $stmt = $this->conn->prepare($sqlQuery);
        $stmt->execute();
        $result = $stmt->get_result();

        $stmtTotal = $this->conn->prepare($sqlQuery);
        $stmtTotal->execute();
        $allResult = $stmtTotal->get_result();
        $allRecords = $allResult->num_rows;

        $displayRecords = $result->num_rows;
        $records = array();
        $count = 1;
        while ($user = $result->fetch_assoc()) {
            $rows = array();
            $rows[] = $count;
            $rows[] = ucfirst($user['first_name']) . " " . ucfirst($user['last_name']);
            $rows[] = $user['email'];
            $rows[] = $user['role'];
            $rows[] = '<button type="button" name="update" id="' . $user["id"] . '" class="btn btn-primary btn-sm update"><span class="fa fa-edit" title="Edit"> Edit</span></button>';
            $rows[] = '<button type="button" name="delete" id="' . $user["id"] . '" class="btn btn-danger btn-sm delete" ><span class="fa fa-trash-o" title="Delete"> Delete</span></button>';
            $records[] = $rows;
            $count++;
        }

        $output = array(
            "draw"  =>  intval($_POST["draw"]),
            "iTotalRecords" =>  $displayRecords,
            "iTotalDisplayRecords"  =>  $allRecords,
            "data"  =>  $records
        );

        echo json_encode($output);
    }

    public function insert()
    {
        if ($this->role && $this->email && $this->password && $_SESSION["userid"]) {
            $stmt = $this->conn->prepare("
                INSERT INTO " . $this->userTable . "(`first_name`, `last_name`, `email`, `password`, `role`)
                VALUES(?, ?, ?, ?, ?)");
            $this->role = htmlspecialchars(strip_tags($this->role));
            $this->email = htmlspecialchars(strip_tags($this->email));
            $this->first_name = htmlspecialchars(strip_tags($this->first_name));
            $this->last_name = htmlspecialchars(strip_tags($this->last_name));
            $this->password = md5($this->password);
            $stmt->bind_param("sssss", $this->first_name, $this->last_name, $this->email, $this->password, $this->role);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function update()
    {

        if ($this->role && $this->email && $_SESSION["userid"]) {

            $updatePass = '';
            if ($this->password) {
                $this->password = md5($this->password);
                $updatePass = ", password = '" . $this->password . "'";
            }

            $stmt = $this->conn->prepare("
                UPDATE " . $this->userTable . " 
                SET first_name = ?, last_name = ?, email = ?, role = ? $updatePass
                WHERE id = ?");

            $this->role = htmlspecialchars(strip_tags($this->role));
            $this->email = htmlspecialchars(strip_tags($this->email));
            $this->first_name = htmlspecialchars(strip_tags($this->first_name));
            $this->last_name = htmlspecialchars(strip_tags($this->last_name));

            $stmt->bind_param("ssssi", $this->first_name, $this->last_name, $this->email, $this->role, $this->id);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function delete()
    {
        if ($this->id && $_SESSION["userid"]) {

            $stmt = $this->conn->prepare("
                DELETE FROM " . $this->userTable . " 
                WHERE id = ?");

            $this->id = htmlspecialchars(strip_tags($this->id));

            $stmt->bind_param("i", $this->id);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function getUserDetails()
    {
        if ($this->user_id && $_SESSION["userid"]) {

            $sqlQuery = "
                SELECT id, first_name, last_name, email, password, role
                FROM " . $this->userTable . "           
                WHERE id = ? ";

            $stmt = $this->conn->prepare($sqlQuery);
            $stmt->bind_param("i", $this->user_id);
            $stmt->execute();
            $result = $stmt->get_result();
            $records = array();
            while ($user = $result->fetch_assoc()) {
                $rows = array();
                $rows['id'] = $user['id'];
                $rows['first_name'] = $user['first_name'];
                $rows['last_name'] = $user['last_name'];
                $rows['email'] = $user['email'];
                $rows['role'] = $user['role'];
                $records[] = $rows;
            }
            $output = array(
                "data"  =>  $records
            );
            echo json_encode($output);
        }
    }

    function getUsersList()
    {
        $stmt = $this->conn->prepare("
        SELECT id, first_name, last_name 
        FROM " . $this->userTable . " 
        WHERE role = 'user'");
        $stmt->execute();
        $result = $stmt->get_result();
        return $result;
    }

    function getTotalUsers()
    {
        $stmt = $this->conn->prepare("
        SELECT *
        FROM " . $this->userTable);
        $stmt->execute();
        $result = $stmt->get_result();
        return $result->num_rows;
    }
}
?>

<?php
include_once 'config/Config.php';
include_once 'class/User.php';

$conn = new Config();
$db = $conn->getConnection();

$user = new User($db);

if (!$user->loggedIn()) {
    header("Location: index.php");
}
include('templates/header.php');
?>
<div class="container-fluid">
    <div class="row">
        <?php include('templates/left_menus.php'); ?>
        <div class="col-md-10 col-lg-10">
            <h2>Users</h2>
            <div class="panel-heading">
                <div class="row">
                    <div class="col-md-10">
                        <h3 class="panel-title"></h3>
                    </div>
                    <div class="col-md-2" align="right">
                        <button type="button" id="addUser" class="btn btn-info btn-sm" title="Add User"><span class="fa fa-plus"> Add</span></button>
                    </div>
                </div>
            </div>
            <table id="userListing" class="table table-striped table-bordered">
                <thead>
                    <tr>
                        <th>Sn.</th>
                        <th>Name</th>
                        <th>Email</th>
                        <th>Role</th>
                        <th></th>
                        <th></th>
                    </tr>
                </thead>
            </table>
        </div>
    </div>
</div>
<?php
include('popup/add-user.php');
include('templates/footer.php');
?>

<?php
include_once 'config/Config.php';
include_once 'class/User.php';

$conn = new Config();
$db = $conn->getConnection();

$user = new User($db);

if(!empty($_POST['action']) && $_POST['action'] == 'listUsers') {
    $user->listUsers();
}

if(!empty($_POST['action']) && $_POST['action'] == 'getUserDetails') {
    $user->user_id = $_POST["id"];
    $user->getUserDetails();
}

if(!empty($_POST['action']) && $_POST['action'] == 'addUser') {
    $user->role = $_POST["role"];
    $user->first_name = $_POST["first_name"];
    $user->last_name = $_POST["last_name"];
    $user->email = $_POST["email"];
    $user->password = $_POST["password"];
    $user->insert();
}

if(!empty($_POST['action']) && $_POST['action'] == 'updateUser') {
    $user->id = $_POST["id"];
    $user->role = $_POST["role"];
    $user->first_name = $_POST["first_name"];
    $user->last_name = $_POST["last_name"];
    $user->email = $_POST["email"];
    $user->password = $_POST["password"];
    $user->update();
}

if(!empty($_POST['action']) && $_POST['action'] == 'deleteUser') {
    $user->id = $_POST["id"];
    $user->delete();
}
?>

jQuery(document).ready(function () {

    var userRecords = jQuery('#userListing').DataTable({
        "lengthChange": false,
        "processing": true,
        "serverSide": true,
        "bFilter": false,
        'serverMethod': 'post',
        "order": [],
        "ajax": {
            url: "user_action.php",
            type: "POST",
            data: { action: 'listUsers' },
            dataType: "json"
        },
        "columnDefs": [
            {
                "targets": [0, 4, 5],
                "orderable": false,
            },
        ],
        "pageLength": 10
    });

    jQuery('#addUser').click(function () {
        jQuery('#userModal').modal({
            backdrop: 'static',
            keyboard: false
        });
        jQuery("#userModal").on("shown.bs.modal", function () {
            jQuery('#userForm')[0].reset();
            jQuery('.modal-title').html("<i class='fa fa-plus'></i> Add User");
            jQuery('#action').val('addUser');
            jQuery('#save').val('Save');
        });
    });

    jQuery("#userListing").on('click', '.update', function () {
        var id = jQuery(this).attr("id");
        var action = 'getUserDetails';
        jQuery.ajax({
            url: 'user_action.php',
            method: "POST",
            data: { id: id, action: action },
            dataType: "json",
            success: function (respData) {
                jQuery("#userModal").on("shown.bs.modal", function () {
                    jQuery('#userForm')[0].reset();
                    respData.data.forEach(function (item) {
                        jQuery('#id').val(item['id']);
                        jQuery('#role').val(item['role']);
                        jQuery('#first_name').val(item['first_name']);
                        jQuery('#last_name').val(item['last_name']);
                        jQuery('#email').val(item['email']);
                    });
                    jQuery('.modal-title').html("<i class='fa fa-plus'></i> Edit User");
                    jQuery('#action').val('updateUser');
                    jQuery('#save').val('Save');
                }).modal({
                    backdrop: 'static',
                    keyboard: false
                });
            }
        });
    });

    jQuery("#userModal").on('submit', '#userForm', function (event) {
        event.preventDefault();
        jQuery('#save').attr('disabled', 'disabled');
        var formData = jQuery(this).serialize();
        jQuery.ajax({
            url: "user_action.php",
            method: "POST",
            data: formData,
            success: function (data) {
                jQuery('#userForm')[0].reset();
                jQuery('#userModal').modal('hide');
                jQuery('#save').attr('disabled', false);
                userRecords.ajax.reload();
            }
        })
    });

    jQuery("#userListing").on('click', '.delete', function () {
        var id = jQuery(this).attr("id");
        var action = "deleteUser";
        if (confirm("Are you sure you want to delete this record?")) {
            jQuery.ajax({
                url: "user_action.php",
                method: "POST",
                data: { id: id, action: action },
                success: function (data) {
                    userRecords.ajax.reload();
                }
            })
        } else {
            return false;
        }
    });

});

<?php

/**
 * Description of Books Class
 *
 * @author Team TechArise
 *
 * @email info@techarise.com
 */

class Books
{

    private $bookTable = 'book';
    private $issuedBookTable = 'issued_book';
    private $categoryTable = 'category';
    private $authorTable = 'author';
    private $publisherTable = 'publisher';
    private $rackTable = 'rack';
    private $conn;

    public function __construct($db)
    {
        $this->conn = $db;
    }

    public function listBook()
    {

        $sqlQuery = "SELECT book.bookid, book.picture, book.name, book.status, book.isbn, book.no_of_copy, book.updated_on, author.name as author_name, category.name AS category_name, rack.name As rack_name, publisher.name AS publisher_name 
            FROM " . $this->bookTable . " book          
            LEFT JOIN " . $this->authorTable . " author ON author.authorid = book.authorid
            LEFT JOIN " . $this->categoryTable . " category ON category.categoryid = book.categoryid
            LEFT JOIN " . $this->rackTable . " rack ON rack.rackid = book.rackid
            LEFT JOIN " . $this->publisherTable . " publisher ON publisher.publisherid = book.publisherid ";

        if (!empty($_POST["search"]["value"])) {
            $sqlQuery .= ' WHERE (book.bookid LIKE "%' . $_POST["search"]["value"] . '%" ';
            $sqlQuery .= ' OR book.name LIKE "%' . $_POST["search"]["value"] . '%" ';
            $sqlQuery .= ' OR book.status LIKE "%' . $_POST["search"]["value"] . '%" ';
        }

        if (!empty($_POST["order"])) {
            $sqlQuery .= 'ORDER BY ' . $_POST['order']['0']['column'] . ' ' . $_POST['order']['0']['dir'] . ' ';
        } else {
            $sqlQuery .= 'ORDER BY book.bookid DESC ';
        }

        if ($_POST["length"] != -1) {
            $sqlQuery .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
        }

        $stmt = $this->conn->prepare($sqlQuery);
        $stmt->execute();
        $result = $stmt->get_result();

        $stmtTotal = $this->conn->prepare($sqlQuery);
        $stmtTotal->execute();
        $allResult = $stmtTotal->get_result();
        $allRecords = $allResult->num_rows;

        $displayRecords = $result->num_rows;
        $records = array();
        $count = 1;
        while ($book = $result->fetch_assoc()) {
            $rows = array();
            if (!$book['picture']) {
                $book['picture'] = 'placeholder.png';
            }
            $rows[] = '<img src="images/' . $book['picture'] . '" width="50" height="50">';
            $rows[] = ucfirst($book['name']);
            $rows[] = ucfirst($book['isbn']);
            $rows[] = ucfirst($book['author_name']);
            $rows[] = ucfirst($book['publisher_name']);
            $rows[] = ucfirst($book['category_name']);
            $rows[] = ucfirst($book['rack_name']);
            $rows[] = ucfirst($book['no_of_copy']);
            $rows[] = $book['status'];
            $rows[] = $book['updated_on'];
            $rows[] = '<button type="button" name="update" id="' . $book["bookid"] . '" class="btn btn-primary btn-sm update"><span class="fa fa-edit" title="Edit"> </span></button>&nbsp;<button type="button" name="delete" id="' . $book["bookid"] . '" class="btn btn-danger btn-sm delete" ><span class="fa fa-trash-o" title="Delete"> </span></button>';
            $records[] = $rows;
            $count++;
        }

        $output = array(
            "draw"  =>  intval($_POST["draw"]),
            "iTotalRecords" =>  $displayRecords,
            "iTotalDisplayRecords"  =>  $allRecords,
            "data"  =>  $records
        );

        echo json_encode($output);
    }

    public function insert()
    {

        if ($this->name && $_SESSION["userid"]) {

            $stmt = $this->conn->prepare("
                INSERT INTO " . $this->bookTable . "(`name`, `status`, `isbn`, `no_of_copy`, `categoryid`, `authorid`, `rackid`, `publisherid`)
                VALUES(?, ?, ?, ?, ?, ?, ?, ?)");

            $this->name = htmlspecialchars(strip_tags($this->name));
            $this->isbn = htmlspecialchars(strip_tags($this->isbn));
            $this->no_of_copy = htmlspecialchars(strip_tags($this->no_of_copy));
            $this->author = htmlspecialchars(strip_tags($this->author));
            $this->publisher = htmlspecialchars(strip_tags($this->publisher));
            $this->category = htmlspecialchars(strip_tags($this->category));
            $this->rack = htmlspecialchars(strip_tags($this->rack));
            $this->status = htmlspecialchars(strip_tags($this->status));

            $stmt->bind_param("sssiiiii", $this->name, $this->status, $this->isbn, $this->no_of_copy, $this->category, $this->author, $this->rack, $this->publisher);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function update()
    {

        if ($this->name && $_SESSION["userid"]) {

            $stmt = $this->conn->prepare("
                UPDATE " . $this->bookTable . " 
                SET name = ?, status = ?, isbn = ?, no_of_copy = ?, categoryid = ?, authorid = ?, rackid = ?, publisherid = ?
                WHERE bookid = ?");

            $this->name = htmlspecialchars(strip_tags($this->name));
            $this->isbn = htmlspecialchars(strip_tags($this->isbn));
            $this->no_of_copy = htmlspecialchars(strip_tags($this->no_of_copy));
            $this->author = htmlspecialchars(strip_tags($this->author));
            $this->publisher = htmlspecialchars(strip_tags($this->publisher));
            $this->category = htmlspecialchars(strip_tags($this->category));
            $this->rack = htmlspecialchars(strip_tags($this->rack));
            $this->status = htmlspecialchars(strip_tags($this->status));
            $this->bookid = htmlspecialchars(strip_tags($this->bookid));

            $stmt->bind_param("sssiiiiii", $this->name, $this->status, $this->isbn, $this->no_of_copy, $this->category, $this->author, $this->rack, $this->publisher, $this->bookid);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function delete()
    {
        if ($this->bookid && $_SESSION["userid"]) {

            $stmt = $this->conn->prepare("
                DELETE FROM " . $this->bookTable . " 
                WHERE bookid = ?");

            $this->bookid = htmlspecialchars(strip_tags($this->bookid));

            $stmt->bind_param("i", $this->bookid);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function getBookDetails()
    {
        if ($this->bookid && $_SESSION["userid"]) {

            $sqlQuery = "SELECT book.bookid, book.picture, book.name, book.status, book.isbn, book.no_of_copy, book.updated_on, author.authorid, category.categoryid, rack.rackid, publisher.publisherid 
            FROM " . $this->bookTable . " book          
            LEFT JOIN " . $this->authorTable . " author ON author.authorid = book.authorid
            LEFT JOIN " . $this->categoryTable . " category ON category.categoryid = book.categoryid
            LEFT JOIN " . $this->rackTable . " rack ON rack.rackid = book.rackid
            LEFT JOIN " . $this->publisherTable . " publisher ON publisher.publisherid = book.publisherid 
            WHERE bookid = ? ";

            $stmt = $this->conn->prepare($sqlQuery);
            $stmt->bind_param("i", $this->bookid);
            $stmt->execute();
            $result = $stmt->get_result();
            $records = array();
            while ($book = $result->fetch_assoc()) {
                $rows = array();
                $rows['bookid'] = $book['bookid'];
                $rows['name'] = $book['name'];
                $rows['status'] = $book['status'];
                $rows['isbn'] = $book['isbn'];
                $rows['no_of_copy'] = $book['no_of_copy'];
                $rows['categoryid'] = $book['categoryid'];
                $rows['rackid'] = $book['rackid'];
                $rows['publisherid'] = $book['publisherid'];
                $rows['authorid'] = $book['authorid'];
                $records[] = $rows;
            }
            $output = array(
                "data"  =>  $records
            );
            echo json_encode($output);
        }
    }

    function getAuthorList()
    {
        $stmt = $this->conn->prepare("
        SELECT authorid, name 
        FROM " . $this->authorTable);
        $stmt->execute();
        $result = $stmt->get_result();
        return $result;
    }

    function getCategoryList()
    {
        $stmt = $this->conn->prepare("
        SELECT categoryid, name 
        FROM " . $this->categoryTable);
        $stmt->execute();
        $result = $stmt->get_result();
        return $result;
    }

    function getPublisherList()
    {
        $stmt = $this->conn->prepare("
        SELECT publisherid, name 
        FROM " . $this->publisherTable);
        $stmt->execute();
        $result = $stmt->get_result();
        return $result;
    }

    function getRackList()
    {
        $stmt = $this->conn->prepare("
        SELECT rackid, name 
        FROM " . $this->rackTable);
        $stmt->execute();
        $result = $stmt->get_result();
        return $result;
    }

    function getBookList()
    {
        $stmt = $this->conn->prepare("
        SELECT book.bookid, book.name, issue_book.status
        FROM " . $this->bookTable . " book
        LEFT JOIN " . $this->issuedBookTable . " issue_book ON issue_book.bookid = book.bookid");
        $stmt->execute();
        $result = $stmt->get_result();
        return $result;
    }

    function getTotalBooks()
    {
        $stmt = $this->conn->prepare("
        SELECT *
        FROM " . $this->bookTable);
        $stmt->execute();
        $result = $stmt->get_result();
        return $result->num_rows;
    }


    function getTotalIssuedBooks()
    {
        $stmt = $this->conn->prepare("
        SELECT * 
        FROM " . $this->issuedBookTable . " 
        WHERE status = 'Issued'");
        $stmt->execute();
        $result = $stmt->get_result();
        return $result->num_rows;
    }


    function getTotalReturnedBooks()
    {
        $stmt = $this->conn->prepare("
        SELECT * 
        FROM " . $this->issuedBookTable . " 
        WHERE status = 'Returned'");
        $stmt->execute();
        $result = $stmt->get_result();
        return $result->num_rows;
    }
}
?>

<?php
include_once 'config/Config.php';
include_once 'class/User.php';
include_once 'class/Books.php';

$conn = new Config();
$db = $conn->getConnection();

$user = new User($db);

if (!$user->loggedIn()) {
    header("Location: index.php");
}
$book = new Books($db);
include('templates/header.php');
?>


<div class="container-fluid">
    <div class="row">
        <?php include('templates/left_menus.php'); ?>
        <div class="col-md-10 col-lg-10">
            <h2>Manage Books</h2>
            <div class="panel-heading">
                <div class="row">
                    <div class="col-md-10">
                        <h3 class="panel-title"></h3>
                    </div>
                    <div class="col-md-2" align="right">
                        <button type="button" id="addBook" class="btn btn-info btn-sm" title="Add book"><span class="fa fa-plus"> Add Book</span></button>
                    </div>
                </div>
            </div>
            <table id="bookListing" class="table table-striped table-bordered">
                <thead>
                    <tr>
                        <td style="width: 5%;">#</td>
                        <th style="width: 10%;">Book</th>
                        <th style="width: 10%;">ISBN</th>
                        <th style="width: 10%;">Author</th>
                        <th style="width: 10%;">Publisher</th>
                        <th style="width: 10%;">Category</th>
                        <th style="width: 8%;">Rack</th>
                        <th style="width: 10%;">No of copy</th>
                        <th style="width: 5%;">Status</th>
                        <th style="width: 10%;">Updated On</th>
                        <th style="width: 12%;">Action</th>
                    </tr>
                </thead>
            </table>
        </div>
    </div>
</div>
<?php
include('popup/add-book.php');
include('templates/footer.php');
?>

<?php
include_once 'config/Config.php';
include_once 'class/Books.php';

$conn = new Config();
$db = $conn->getConnection();

$book = new Books($db);

if(!empty($_POST['action']) && $_POST['action'] == 'listBook') {
    $book->listBook();
}

if(!empty($_POST['action']) && $_POST['action'] == 'getBookDetails') {
    $book->bookid = $_POST["bookid"];
    $book->getBookDetails();
}

if(!empty($_POST['action']) && $_POST['action'] == 'addBook') {
    $book->name = $_POST["name"];
    $book->isbn = $_POST["isbn"];
    $book->no_of_copy = $_POST["no_of_copy"];
    $book->author = $_POST["author"];
    $book->publisher = $_POST["publisher"];
    $book->category = $_POST["category"];
    $book->rack = $_POST["rack"];
    $book->status = $_POST["status"];   
    $book->insert();
}

if(!empty($_POST['action']) && $_POST['action'] == 'updateBook') {
    $book->bookid = $_POST["bookid"];
    $book->name = $_POST["name"];
    $book->isbn = $_POST["isbn"];
    $book->no_of_copy = $_POST["no_of_copy"];
    $book->author = $_POST["author"];
    $book->publisher = $_POST["publisher"];
    $book->category = $_POST["category"];
    $book->rack = $_POST["rack"];
    $book->status = $_POST["status"];
    $book->update();
}

if(!empty($_POST['action']) && $_POST['action'] == 'deleteBook') {
    $book->bookid = $_POST["bookid"];
    $book->delete();
}
?>

jQuery(document).ready(function () {

    var bookRecords = jQuery('#bookListing').DataTable({
        "lengthChange": false,
        "processing": true,
        "serverSide": true,
        "bFilter": false,
        'serverMethod': 'post',
        "order": [],
        "ajax": {
            url: "books_action.php",
            type: "POST",
            data: { action: 'listBook' },
            dataType: "json"
        },
        "columnDefs": [
            {
                "targets": [0, 9, 10],
                "orderable": false,
            },
        ],
        "pageLength": 10
    });

    jQuery('#addBook').click(function () {
        jQuery('#bookModal').modal({
            backdrop: 'static',
            keyboard: false
        });
        jQuery("#bookModal").on("shown.bs.modal", function () {
            jQuery('#bookForm')[0].reset();
            jQuery('.modal-title').html("<i class='fa fa-plus'></i> Add Book");
            jQuery('#action').val('addBook');
            jQuery('#save').val('Save');
        });
    });

    jQuery("#bookListing").on('click', '.update', function () {
        var bookid = jQuery(this).attr("id");
        var action = 'getBookDetails';
        jQuery.ajax({
            url: 'books_action.php',
            method: "POST",
            data: { bookid: bookid, action: action },
            dataType: "json",
            success: function (respData) {
                jQuery("#bookModal").on("shown.bs.modal", function () {
                    jQuery('#bookForm')[0].reset();
                    respData.data.forEach(function (item) {
                        jQuery('#bookid').val(item['bookid']);
                        jQuery('#name').val(item['name']);
                        jQuery('#isbn').val(item['isbn']);
                        jQuery('#no_of_copy').val(item['no_of_copy']);
                        jQuery('#category').val(item['categoryid']);
                        jQuery('#rack').val(item['rackid']);
                        jQuery('#publisher').val(item['publisherid']);
                        jQuery('#author').val(item['authorid']);
                        jQuery('#status').val(item['status']);
                    });
                    jQuery('.modal-title').html("<i class='fa fa-plus'></i> Edit Book");
                    jQuery('#action').val('updateBook');
                    jQuery('#save').val('Save');
                }).modal({
                    backdrop: 'static',
                    keyboard: false
                });
            }
        });
    });

    jQuery("#bookModal").on('submit', '#bookForm', function (event) {
        event.preventDefault();
        jQuery('#save').attr('disabled', 'disabled');
        var formData = jQuery(this).serialize();
        jQuery.ajax({
            url: "books_action.php",
            method: "POST",
            data: formData,
            success: function (data) {
                jQuery('#bookForm')[0].reset();
                jQuery('#bookModal').modal('hide');
                jQuery('#save').attr('disabled', false);
                bookRecords.ajax.reload();
            }
        })
    });

    jQuery("#bookListing").on('click', '.delete', function () {
        var bookid = jQuery(this).attr("id");
        var action = "deleteBook";
        if (confirm("Are you sure you want to delete this record?")) {
            jQuery.ajax({
                url: "books_action.php",
                method: "POST",
                data: { bookid: bookid, action: action },
                success: function (data) {
                    bookRecords.ajax.reload();
                }
            })
        } else {
            return false;
        }
    });

});

<?php

/**
 * Description of IssueBooks Class
 *
 * @author Team TechArise
 *
 * @email info@techarise.com
 */

class IssueBooks
{

    private $issuedBookTable = 'issued_book';
    private $bookTable = 'book';
    private $userTable = 'user';
    private $conn;

    public function __construct($db)
    {
        $this->conn = $db;
    }

    public function listIssuedBook()
    {

        $sqlQuery = "SELECT issue_book.issuebookid, issue_book.issue_date_time, issue_book.expected_return_date, issue_book.return_date_time, issue_book.status, book.name As book_name, book.isbn, user.first_name, user.last_name 
            FROM " . $this->issuedBookTable . " issue_book          
            LEFT JOIN " . $this->bookTable . " book ON book.bookid = issue_book.bookid
            LEFT JOIN " . $this->userTable . " user ON user.id = issue_book.userid ";

        if (!empty($_POST["search"]["value"])) {
            $sqlQuery .= ' WHERE (issue_book.issuebookid LIKE "%' . $_POST["search"]["value"] . '%" ';
            $sqlQuery .= ' OR issue_book.issue_date_time LIKE "%' . $_POST["search"]["value"] . '%" ';
            $sqlQuery .= ' OR issue_book.status LIKE "%' . $_POST["search"]["value"] . '%" ';
        }

        if (!empty($_POST["order"])) {
            $sqlQuery .= 'ORDER BY ' . $_POST['order']['0']['column'] . ' ' . $_POST['order']['0']['dir'] . ' ';
        } else {
            $sqlQuery .= 'ORDER BY issue_book.issuebookid DESC ';
        }

        if ($_POST["length"] != -1) {
            $sqlQuery .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
        }

        $stmt = $this->conn->prepare($sqlQuery);
        $stmt->execute();
        $result = $stmt->get_result();

        $stmtTotal = $this->conn->prepare($sqlQuery);
        $stmtTotal->execute();
        $allResult = $stmtTotal->get_result();
        $allRecords = $allResult->num_rows;

        $displayRecords = $result->num_rows;
        $records = array();
        $count = 1;
        while ($issueBook = $result->fetch_assoc()) {
            $rows = array();
            $rows[] = $count;
            $rows[] = ucfirst($issueBook['book_name']);
            $rows[] = ucfirst($issueBook['isbn']);
            $rows[] = ucfirst($issueBook['first_name']) . " " . ucfirst($issueBook['last_name']);
            $rows[] = ucfirst($issueBook['issue_date_time']);
            $rows[] = ucfirst($issueBook['expected_return_date']);
            $rows[] = ucfirst($issueBook['return_date_time']);
            $rows[] = $issueBook['status'];
            $rows[] = '<button type="button" name="update" id="' . $issueBook["issuebookid"] . '" class="btn btn-primary btn-sm update"><span class="fa fa-edit" title="Edit"> Edit</span></button>';
            $rows[] = '<button type="button" name="delete" id="' . $issueBook["issuebookid"] . '" class="btn btn-danger btn-sm delete" ><span class="fa fa-trash-o" title="Delete"> Delete</span></button>';
            $records[] = $rows;
            $count++;
        }

        $output = array(
            "draw"  =>  intval($_POST["draw"]),
            "iTotalRecords" =>  $displayRecords,
            "iTotalDisplayRecords"  =>  $allRecords,
            "data"  =>  $records
        );

        echo json_encode($output);
    }

    public function insert()
    {

        if ($this->book && $_SESSION["userid"]) {

            $stmt = $this->conn->prepare("
                INSERT INTO " . $this->issuedBookTable . "(`bookid`, `userid`, `expected_return_date`, `return_date_time`, `status`)
                VALUES(?, ?, ?, ?, ?)");

            $this->book = htmlspecialchars(strip_tags($this->book));
            $this->users = htmlspecialchars(strip_tags($this->users));
            $this->expected_return_date = htmlspecialchars(strip_tags($this->expected_return_date));
            $this->return_date = htmlspecialchars(strip_tags($this->return_date));
            $this->status = htmlspecialchars(strip_tags($this->status));

            $stmt->bind_param("iisss", $this->book, $this->users, $this->expected_return_date, $this->return_date, $this->status);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function update()
    {

        if ($this->issuebookid && $this->book && $_SESSION["userid"]) {

            $stmt = $this->conn->prepare("
                UPDATE " . $this->issuedBookTable . " 
                SET bookid = ?, userid = ?, expected_return_date = ?, return_date_time = ?, status = ?
                WHERE issuebookid = ?");

            $this->book = htmlspecialchars(strip_tags($this->book));
            $this->users = htmlspecialchars(strip_tags($this->users));
            $this->expected_return_date = htmlspecialchars(strip_tags($this->expected_return_date));
            $this->return_date = htmlspecialchars(strip_tags($this->return_date));
            $this->status = htmlspecialchars(strip_tags($this->status));

            $stmt->bind_param("iisssi", $this->book, $this->users, $this->expected_return_date, $this->return_date, $this->status, $this->issuebookid);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function delete()
    {
        if ($this->issuebookid && $_SESSION["userid"]) {

            $stmt = $this->conn->prepare("
                DELETE FROM " . $this->issuedBookTable . " 
                WHERE issuebookid = ?");

            $this->issuebookid = htmlspecialchars(strip_tags($this->issuebookid));

            $stmt->bind_param("i", $this->issuebookid);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function getIssueBookDetails()
    {
        if ($this->issuebookid && $_SESSION["userid"]) {

            $sqlQuery = "SELECT issue_book.issuebookid, issue_book.issue_date_time, issue_book.expected_return_date, issue_book.return_date_time, issue_book.status, issue_book.bookid, issue_book.userid, book.name AS book_name
            FROM " . $this->issuedBookTable . " issue_book          
            LEFT JOIN " . $this->bookTable . " book ON book.bookid = issue_book.bookid
            LEFT JOIN " . $this->userTable . " user ON user.id = issue_book.userid
            WHERE issue_book.issuebookid = ?";

            $stmt = $this->conn->prepare($sqlQuery);
            $stmt->bind_param("i", $this->issuebookid);
            $stmt->execute();
            $result = $stmt->get_result();
            $records = array();
            while ($issueBook = $result->fetch_assoc()) {
                $rows = array();
                $rows['issuebookid'] = $issueBook['issuebookid'];
                $rows['bookid'] = $issueBook['bookid'];
                $rows['book_name'] = $issueBook['book_name'];
                $rows['status'] = $issueBook['status'];
                $rows['userid'] = $issueBook['userid'];
                $rows['expected_return_date'] = date('Y-m-d\TH:i:s', strtotime($issueBook['expected_return_date']));
                $rows['return_date_time'] = date('Y-m-d\TH:i:s', strtotime($issueBook['return_date_time']));
                $records[] = $rows;
            }
            $output = array(
                "data"  =>  $records
            );
            echo json_encode($output);
        }
    }
}
?>

<?php
include_once 'config/Config.php';
include_once 'class/User.php';
include_once 'class/Books.php';

$conn = new Config();
$db = $conn->getConnection();

$user = new User($db);

if (!$user->loggedIn()) {
    header("Location: index.php");
}
$book = new Books($db);
include('templates/header.php');
?>

<div class="container-fluid">
    <div class="row">
        <?php include('templates/left_menus.php'); ?>
        <div class="col-md-10 col-lg-10">
            <h2>Manage Issue Books</h2>
            <div class="panel-heading">
                <div class="row">
                    <div class="col-md-10">
                        <h3 class="panel-title"></h3>
                    </div>
                    <div class="col-md-2" align="right">
                        <button type="button" id="issueBook" class="btn btn-info btn-sm" title="Issue Book"><span class="fa fa-plus"> Issue Book</span></button>
                    </div>
                </div>
            </div>
            <table id="issuedBookListing" class="table table-striped table-bordered">
                <thead>
                    <tr>
                        <th>Id</th>
                        <th>Book</th>
                        <th>ISBN</th>
                        <th>User</th>
                        <th>Issue Date</th>
                        <th>Expected Return</th>
                        <th>Return Date</th>
                        <th>Status</th>
                        <th></th>
                        <th></th>
                    </tr>
                </thead>
            </table>
        </div>
    </div>  
</div>
<?php
include('popup/add-issue-books.php');
include('templates/footer.php');
?>

<?php
include_once 'config/Config.php';
include_once 'class/IssueBooks.php';

$conn = new Config();
$db = $conn->getConnection();

$issueBook = new IssueBooks($db);

if(!empty($_POST['action']) && $_POST['action'] == 'listIssuedBook') {
    $issueBook->listIssuedBook();
}

if(!empty($_POST['action']) && $_POST['action'] == 'getIssueBookDetails') {
    $issueBook->issuebookid = $_POST["issuebookid"];
    $issueBook->getIssueBookDetails();
}

if(!empty($_POST['action']) && $_POST['action'] == 'issueBook') {
    $issueBook->book = $_POST["book"];
    $issueBook->users = $_POST["users"];
    $issueBook->expected_return_date = $_POST["expected_return_date"];
    $issueBook->return_date = $_POST["return_date"];
    $issueBook->status = $_POST["status"];  
    $issueBook->insert();
}

if(!empty($_POST['action']) && $_POST['action'] == 'updateIssueBook') {
    $issueBook->issuebookid = $_POST["issuebookid"];
    $issueBook->book = $_POST["book"];
    $issueBook->users = $_POST["users"];
    $issueBook->expected_return_date = $_POST["expected_return_date"];
    $issueBook->return_date = $_POST["return_date"];
    $issueBook->status = $_POST["status"];  
    $issueBook->update();
}

if(!empty($_POST['action']) && $_POST['action'] == 'deleteIssueBook') {
    $issueBook->issuebookid = $_POST["issuebookid"];
    $issueBook->delete();
}
?>

jQuery(document).ready(function () {

    var issuedBookRecords = jQuery('#issuedBookListing').DataTable({
        "lengthChange": false,
        "processing": true,
        "serverSide": true,
        "bFilter": false,
        'serverMethod': 'post',
        "order": [],
        "ajax": {
            url: "issue_books_action.php",
            type: "POST",
            data: { action: 'listIssuedBook' },
            dataType: "json"
        },
        "columnDefs": [
            {
                "targets": [0, 8, 9],
                "orderable": false,
            },
        ],
        "pageLength": 10
    });

    jQuery('#issueBook').click(function () {
        jQuery('#issuedBookModal').modal({
            backdrop: 'static',
            keyboard: false
        });
        jQuery("#issuedBookModal").on("shown.bs.modal", function () {
            jQuery('#issuedBookForm')[0].reset();
            jQuery('.modal-title').html("<i class='fa fa-plus'></i> Issue Book");
            jQuery('#action').val('issueBook');
            jQuery('#save').val('Save');
        });
    });

    jQuery("#issuedBookListing").on('click', '.update', function () {
        var issuebookid = jQuery(this).attr("id");
        var action = 'getIssueBookDetails';
        jQuery.ajax({
            url: 'issue_books_action.php',
            method: "POST",
            data: { issuebookid: issuebookid, action: action },
            dataType: "json",
            success: function (respData) {
                jQuery("#issuedBookModal").on("shown.bs.modal", function () {
                    jQuery('#issuedBookForm')[0].reset();
                    respData.data.forEach(function (item) {
                        jQuery('#issuebookid').val(item['issuebookid']);
                        jQuery('#book').val(item['bookid']);
                        jQuery('#users').val(item['userid']);
                        jQuery('#expected_return_date').val(item['expected_return_date']);
                        jQuery('#return_date').val(item['return_date_time']);
                        jQuery('#status').val(item['status']);
                    });
                    jQuery('.modal-title').html("<i class='fa fa-plus'></i> Edit issued Book");
                    jQuery('#action').val('updateIssueBook');
                    jQuery('#save').val('Save');
                }).modal({
                    backdrop: 'static',
                    keyboard: false
                });
            }
        });
    });

    jQuery("#issuedBookModal").on('submit', '#issuedBookForm', function (event) {
        event.preventDefault();
        jQuery('#save').attr('disabled', 'disabled');
        var formData = jQuery(this).serialize();
        jQuery.ajax({
            url: "issue_books_action.php",
            method: "POST",
            data: formData,
            success: function (data) {
                jQuery('#issuedBookForm')[0].reset();
                jQuery('#issuedBookModal').modal('hide');
                jQuery('#save').attr('disabled', false);
                issuedBookRecords.ajax.reload();
            }
        })
    });

    jQuery("#issuedBookListing").on('click', '.delete', function () {
        var issuebookid = jQuery(this).attr("id");
        var action = "deleteIssueBook";
        if (confirm("Are you sure you want to delete this record?")) {
            jQuery.ajax({
                url: "issue_books_action.php",
                method: "POST",
                data: { issuebookid: issuebookid, action: action },
                success: function (data) {
                    issuedBookRecords.ajax.reload();
                }
            })
        } else {
            return false;
        }
    });

});

<?php

/**
 * Description of Rack Class
 *
 * @author Team TechArise
 *
 * @email info@techarise.com
 */

class Rack
{

    private $rackTable = 'rack';
    private $conn;

    public function __construct($db)
    {
        $this->conn = $db;
    }

    public function listRack()
    {

        $sqlQuery = "SELECT rackid, name, status
            FROM " . $this->rackTable . " ";

        if (!empty($_POST["search"]["value"])) {
            $sqlQuery .= ' WHERE (rackid LIKE "%' . $_POST["search"]["value"] . '%" ';
            $sqlQuery .= ' OR name LIKE "%' . $_POST["search"]["value"] . '%" ';
            $sqlQuery .= ' OR status LIKE "%' . $_POST["search"]["value"] . '%" ';
        }

        if (!empty($_POST["order"])) {
            $sqlQuery .= 'ORDER BY ' . $_POST['order']['0']['column'] . ' ' . $_POST['order']['0']['dir'] . ' ';
        } else {
            $sqlQuery .= 'ORDER BY rackid DESC ';
        }

        if ($_POST["length"] != -1) {
            $sqlQuery .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
        }

        $stmt = $this->conn->prepare($sqlQuery);
        $stmt->execute();
        $result = $stmt->get_result();

        $stmtTotal = $this->conn->prepare($sqlQuery);
        $stmtTotal->execute();
        $allResult = $stmtTotal->get_result();
        $allRecords = $allResult->num_rows;

        $displayRecords = $result->num_rows;
        $records = array();
        $count = 1;
        while ($rack = $result->fetch_assoc()) {
            $rows = array();
            $rows[] = $count;
            $rows[] = ucfirst($rack['name']);
            $rows[] = $rack['status'];
            $rows[] = '<button type="button" name="update" id="' . $rack["rackid"] . '" class="btn btn-primary btn-sm update"><span class="fa fa-edit" title="Edit"> Edit</span></button>';
            $rows[] = '<button type="button" name="delete" id="' . $rack["rackid"] . '" class="btn btn-danger btn-sm delete" ><span class="fa fa-trash-o" title="Delete"> Delete</span></button>';
            $records[] = $rows;
            $count++;
        }

        $output = array(
            "draw"  =>  intval($_POST["draw"]),
            "iTotalRecords" =>  $displayRecords,
            "iTotalDisplayRecords"  =>  $allRecords,
            "data"  =>  $records
        );

        echo json_encode($output);
    }

    public function insert()
    {

        if ($this->name && $_SESSION["userid"]) {

            $stmt = $this->conn->prepare("
                INSERT INTO " . $this->rackTable . "(`name`, `status`)
                VALUES(?, ?)");

            $this->name = htmlspecialchars(strip_tags($this->name));
            $this->status = htmlspecialchars(strip_tags($this->status));

            $stmt->bind_param("ss", $this->name, $this->status);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function update()
    {

        if ($this->name && $_SESSION["userid"]) {

            $stmt = $this->conn->prepare("
                UPDATE " . $this->rackTable . " 
                SET name = ?, status = ?
                WHERE rackid = ?");

            $this->name = htmlspecialchars(strip_tags($this->name));
            $this->status = htmlspecialchars(strip_tags($this->status));
            $this->rackid = htmlspecialchars(strip_tags($this->rackid));

            $stmt->bind_param("ssi", $this->name, $this->status, $this->rackid);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function delete()
    {
        if ($this->rackid && $_SESSION["userid"]) {

            $stmt = $this->conn->prepare("
                DELETE FROM " . $this->rackTable . " 
                WHERE rackid = ?");

            $this->rackid = htmlspecialchars(strip_tags($this->rackid));

            $stmt->bind_param("i", $this->rackid);

            if ($stmt->execute()) {
                return true;
            }
        }
    }

    public function getRackDetails()
    {
        if ($this->rackid && $_SESSION["userid"]) {

            $sqlQuery = "
                SELECT rackid, name, status
                FROM " . $this->rackTable . "           
                WHERE rackid = ? ";

            $stmt = $this->conn->prepare($sqlQuery);
            $stmt->bind_param("i", $this->rackid);
            $stmt->execute();
            $result = $stmt->get_result();
            $records = array();
            while ($rack = $result->fetch_assoc()) {
                $rows = array();
                $rows['rackid'] = $rack['rackid'];
                $rows['name'] = $rack['name'];
                $rows['status'] = $rack['status'];
                $records[] = $rows;
            }
            $output = array(
                "data"  =>  $records
            );
            echo json_encode($output);
        }
    }
}
?>

<?php
include_once 'config/Config.php';
include_once 'class/User.php';

$conn = new Config();
$db = $conn->getConnection();

$user = new User($db);

if (!$user->loggedIn()) {
    header("Location: index.php");
}
include('templates/header.php');
?>

<div class="container-fluid">
    <div class="row">
        <?php include('templates/left_menus.php'); ?>
        <div class="col-md-10 col-lg-10">
            <h2>Rack Location List</h2>
            <div class="panel-heading">
                <div class="row">
                    <div class="col-md-10">
                        <h3 class="panel-title"></h3>
                    </div>
                    <div class="col-md-2" align="right">
                        <button type="button" id="addRack" class="btn btn-info btn-sm" title="Add Rack"><span class="fa fa-plus"> Add</span></button>
                    </div>
                </div>
            </div>
            <table id="rackListing" class="table table-striped table-bordered">
                <thead>
                    <tr>
                        <th>Sn.</th>
                        <th>Name</th>
                        <th>Status</th>
                        <th></th>
                        <th></th>
                    </tr>
                </thead>
            </table>
        </div>
    </div>
</div>
<?php
include('popup/add-rack.php');
include('templates/footer.php');
?>

<?php
include_once 'config/Config.php';
include_once 'class/Rack.php';

$conn = new Config();
$db = $conn->getConnection();

$rack = new Rack($db);

if(!empty($_POST['action']) && $_POST['action'] == 'listRack') {
    $rack->listRack();
}

if(!empty($_POST['action']) && $_POST['action'] == 'getRackDetails') {
    $rack->rackid = $_POST["rackid"];
    $rack->getRackDetails();
}

if(!empty($_POST['action']) && $_POST['action'] == 'addRack') {
    $rack->name = $_POST["name"];
    $rack->status = $_POST["status"];   
    $rack->insert();
}

if(!empty($_POST['action']) && $_POST['action'] == 'updateRack') {
    $rack->rackid = $_POST["rackid"];
    $rack->name = $_POST["name"];
    $rack->status = $_POST["status"];
    $rack->update();
}

if(!empty($_POST['action']) && $_POST['action'] == 'deleteRack') {
    $rack->rackid = $_POST["rackid"];
    $rack->delete();
}
?>

jQuery(document).ready(function () {

    var rackRecords = jQuery('#rackListing').DataTable({
        "lengthChange": false,
        "processing": true,
        "serverSide": true,
        "bFilter": false,
        'serverMethod': 'post',
        "order": [],
        "ajax": {
            url: "rack_action.php",
            type: "POST",
            data: { action: 'listRack' },
            dataType: "json"
        },
        "columnDefs": [
            {
                "targets": [0, 3, 4],
                "orderable": false,
            },
        ],
        "pageLength": 10
    });

    jQuery('#addRack').click(function () {
        jQuery('#rackModal').modal({
            backdrop: 'static',
            keyboard: false
        });
        jQuery("#rackModal").on("shown.bs.modal", function () {
            jQuery('#rackForm')[0].reset();
            jQuery('.modal-title').html("<i class='fa fa-plus'></i> Add Rack");
            jQuery('#action').val('addRack');
            jQuery('#save').val('Save');
        });
    });

    jQuery("#rackListing").on('click', '.update', function () {
        var rackid = jQuery(this).attr("id");
        var action = 'getRackDetails';
        jQuery.ajax({
            url: 'rack_action.php',
            method: "POST",
            data: { rackid: rackid, action: action },
            dataType: "json",
            success: function (respData) {
                jQuery("#rackModal").on("shown.bs.modal", function () {
                    jQuery('#rackForm')[0].reset();
                    respData.data.forEach(function (item) {
                        jQuery('#rackid').val(item['rackid']);
                        jQuery('#name').val(item['name']);
                        jQuery('#status').val(item['status']);
                    });
                    jQuery('.modal-title').html("<i class='fa fa-plus'></i> Edit Rack");
                    jQuery('#action').val('updateRack');
                    jQuery('#save').val('Save');
                }).modal({
                    backdrop: 'static',
                    keyboard: false
                });
            }
        });
    });

    jQuery("#rackModal").on('submit', '#rackForm', function (event) {
        event.preventDefault();
        jQuery('#save').attr('disabled', 'disabled');
        var formData = jQuery(this).serialize();
        jQuery.ajax({
            url: "rack_action.php",
            method: "POST",
            data: formData,
            success: function (data) {
                jQuery('#rackForm')[0].reset();
                jQuery('#rackModal').modal('hide');
                jQuery('#save').attr('disabled', false);
                rackRecords.ajax.reload();
            }
        })
    });

    jQuery("#rackListing").on('click', '.delete', function () {
        var rackid = jQuery(this).attr("id");
        var action = "deleteRack";
        if (confirm("Are you sure you want to delete this record?")) {
            jQuery.ajax({
                url: "rack_action.php",
                method: "POST",
                data: { rackid: rackid, action: action },
                success: function (data) {
                    rackRecords.ajax.reload();
                }
            })
        } else {
            return false;
        }
    });

});

<!doctype html>
<html lang="en">

<head>
  <link rel="canonical" href="https://techarise.com/" />
  <meta name="author" content="TechArise">
  <meta name="description" content="Learn Web Development Tutorials & Web Developer Resources, PHP, MySQL, jQuery, CSS, XHTML, jQuery UI, CSS3, HTML5, HTML, web design, webdesign, with TechArise tutorials. View live demo">
  <meta name="keywords" content="TechArise, tutorial TechArise, tutorials, freebies, resources, web development, webdev, demo, PHP, MySQL, jQuery, CSS, XHTML, jQuery UI, CSS3, HTML5, HTML, web design, webdesign, php script, dynamic web content" />
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <link rel="icon" type="image/ico" href="https://techarise.com/wp-content/themes/v1/favicon.ico">
  <!-- Bootstrap CSS -->
  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css">
  <link href="http://maxcdn.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css" rel="stylesheet">
  <link rel="stylesheet" href="https://cdn.datatables.net/responsive/2.2.9/css/responsive.bootstrap4.min.css" />
  <link rel="stylesheet" href="https://cdn.datatables.net/1.11.3/css/dataTables.bootstrap4.min.css" />
  <!--- Custom css --->
  <link rel="stylesheet" href="css/style.css" />
  <title>Library Management System | Tech Arise</title>
</head>

<body>
  <?php include('menus.php'); ?>

<header style="margin-bottom:65px;">
    <!-- Fixed navbar -->
    <nav class="navbar navbar-expand-md navbar-dark fixed-top bg-dark" style="background: #273E4A!important;">
        <a class="navbar-brand" href="https://techarise.com"><strong>Tech Arise</strong></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 mr-auto">
                <li class="nav-item active">
                    <a class="nav-link" href="https://techarise.com">Home <span class="sr-only">(current)</span></a>
                </li>
            </ul>
            <?php if (!empty($_SESSION) && $_SESSION["userid"]) { ?>
            <span class="nav-item dropdown">
                <a style="color:#fff;" class="nav-link" href="logout.php" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                    <i class="fa fa-user"></i> <?php echo ucfirst($_SESSION["name"]); ?>
                </a>
            </span>
            <?php } ?>
        </div>
    </nav>
</header>

<footer class="footer">
<div class="container">&nbsp;</div>
</footer>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
<script src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.11.3/js/dataTables.bootstrap4.min.js"></script>
<script src="https://cdn.datatables.net/responsive/2.2.9/js/dataTables.responsive.min.js"></script>
<script src="https://cdn.datatables.net/responsive/2.2.9/js/responsive.bootstrap4.min.js"></script>
<script src="js/books.js"></script>
<script src="js/category.js"></script>
<script src="js/author.js"></script>
<script src="js/publisher.js"></script>
<script src="js/rack.js"></script>
<script src="js/issue_books.js"></script>
<script src="js/user.js"></script>
</body>

</html>

The post Library Management System in PHP and MySQL first appeared on Tech Arise.

• nodejs-express-mysql-restfull-api
  • application
    • config
      • db.config.js
    • models
      • news.model.js
    • controllers
      • news.controller.js
    • routes
      • routes.js
  • node_modules
  • .env
  • index.js
  • package.json
  • package-lock.json
  • README.md

• GET — is used for reading and retrieving data.
• POST — is used for inserting data.
• PUT/PATCH — is used for updating data.
• DELETE — is used for deleting data.

CREATE TABLE `news` (
    `id` int(11) NOT NULL,
    `title` text NOT NULL,
    `description` text NOT NULL,
    `status` int(1) NOT NULL,
    `publish_date` varchar(12) DEFAULT NULL,
    `created_date` varchar(12) DEFAULT NULL,
    `modified_date` varchar(12) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

  INSERT INTO `news` (`id`, `title`, `description`, `status`, `publish_date`, `created_date`, `modified_date`) VALUES
(1, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '1634369809', '1634369809', '1634369809');


  ALTER TABLE `news`
    ADD PRIMARY KEY (`id`);

  ALTER TABLE `news`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  COMMIT;

const express = require("express");
    const dotenv = require('dotenv');
    const app = express();
    // dotenv config
    dotenv.config();
    // ContentTypeParser: parse requests of content-type - application/json
    app.use(express.json());

    // ContentTypeParser: parse requests of content-type - application/x-www-form-urlencoded
    app.use(express.urlencoded({ extended: true }));

    // create route
    app.get("/", (req, res) => {
      res.json({ message: "TechArise - NodeJS RESTfull APIs with Express and MySQL" });
    });

    require("./application/routes/routes.js")(app);

    // set port, listen 
    const PORT = Number(process.env.PORT || 3000);


    app.listen(PORT, () => {
      console.log(`Server is running on PORT ${PORT}.`);
    });

# DB Configurations
  HOST=localhost
  DB_USER=root
  DB_PASS=
  DB_DATABASE=newsapi_DB

  # local runtime configs
  PORT=9090
  SECRET_JWT=supersecret

const mysql = require("mysql");
const dotenv = require('dotenv');
dotenv.config();

// create MySQL Connection
var connection = mysql.createPool({
  host: process.env.HOST,
  user: process.env.DB_USER,
  password: process.env.DB_PASS,
  database: process.env.DB_DATABASE
});

module.exports = connection;

• The News class handles the CRUD process
• constructor — called an object
• Add News Record in database.
• Update News Record in databae.
• News all Records from database.
• get News single Record from database.
• delete News Record from database.

const sql = require("../config/db.config.js");
   
    // constructor
    class News {
      constructor(news) {
        this.title = news.title;
        this.description = news.description;
        this.status = news.status;
        this.publish_date = news.publish_date;
        this.created_date = news.created_date;
        this.modified_date = news.modified_date;
      }
      // create new news
      static create(newNews, result) {
        sql.query("INSERT INTO news SET ?", newNews, (err, res) => {
          if (err) {
            console.log("error: ", err);
            result(err, null);
            return;
          }

          console.log("created news: ", { id: res.insertId, ...newNews });
          result(null, { id: res.insertId, ...newNews });
        });
      }
      // get single news
      static findById(newsId, result) {
        sql.query(`SELECT * FROM news WHERE id = ${newsId}`, (err, res) => {
          if (err) {
            console.log("error: ", err);
            result(err, null);
            return;
          }

          if (res.length) {
            console.log("found news: ", res[0]);
            result(null, res[0]);
            return;
          }

          // not found news with the id
          result({ kind: "not_found" }, null);
        });
      }
      // get all news
      static getAll(result) {
        sql.query("SELECT * FROM news", (err, res) => {
          if (err) {
            console.log("error: ", err);
            result(null, err);
            return;
          }

          console.log("news: ", res);
          result(null, res);
        });
      }
      // update news
      static updateById(id, news, result) {
        sql.query(
          "UPDATE news SET title = ?, description = ?, status = ?, publish_date = ?, created_date = ?, modified_date = ? WHERE id = ?",
          [news.title, news.description, news.status, publish_date.address, news.created_date, news.modified_date, id],
          (err, res) => {
            if (err) {
              console.log("error: ", err);
              result(null, err);
              return;
            }

            if (res.affectedRows == 0) {
              // not found news with the id
              result({ kind: "not_found" }, null);
              return;
            }

            console.log("updated news: ", { id: id, ...news });
            result(null, { id: id, ...news });
          }
        );
      }
      // delete news
      static remove(id, result) {
        sql.query("DELETE FROM news WHERE id = ?", id, (err, res) => {
          if (err) {
            console.log("error: ", err);
            result(null, err);
            return;
          }

          if (res.affectedRows == 0) {
            // not found news with the id
            result({ kind: "not_found" }, null);
            return;
          }

          console.log("deleted news with id: ", id);
          result(null, res);
        });
      }
      // delete all news
      static removeAll(result) {
        sql.query("DELETE FROM news", (err, res) => {
          if (err) {
            console.log("error: ", err);
            result(null, err);
            return;
          }

          console.log(`deleted ${res.affectedRows} news`);
          result(null, res);
        });
      }
    }
    module.exports = News;

// include news model
    const News = require("../models/news.model.js");

    // Add and Save a new News method
    exports.create = (req, res) => {
      // Validate request
      if (!req.body) {
        res.status(400).send({
          message: "Error: Content can not be empty!"
        });
      }

      // Create a News
      const news = new News({
        title: req.body.title,
        description: req.body.description,
        status: req.body.status,
        publish_date: req.body.publish_date,
        created_date: req.body.created_date,
        modified_date: req.body.modified_date
      });

      // Save News in the database
      News.create(news, (err, data) => {
        if (err)
          res.status(500).send({
            message:
              err.message || "Error while creating news."
          });
        else res.send(data);
      });
    };

    // get all News from the database.
    exports.findAll = (req, res) => {
      News.getAll((err, data) => {
        if (err)
          res.status(500).send({
            message:
              err.message || "Error while retrieving news."
          });
        else res.send(data);
      });
    };

    // Find a single News with a newsId
    exports.findOne = (req, res) => {
      News.findById(req.params.newsId, (err, data) => {
        if (err) {
          if (err.kind === "not_found") {
            res.status(404).send({
              message: `News record not found ID: ${req.params.newsId}.`
            });
          } else {
            res.status(500).send({
              message: "Error retrieving News ID " + req.params.newsId
            });
          }
        } else res.send(data);
      });
    };

    // Update a News records 
    exports.update = (req, res) => {
      // Validate Request
      if (!req.body) {
        res.status(400).send({
          message: "Error: Content can not be empty!"
        });
      }

      console.log(req.body);

      News.updateById(
        req.params.newsId,
        new News(req.body),
        (err, data) => {
          if (err) {
            if (err.kind === "not_found") {
              res.status(404).send({
                message: `News record not found ID: ${req.params.newsId}.`
              });
            } else {
              res.status(500).send({
                message: "Error: updating News ID: " + req.params.newsId
              });
            }
          } else res.send(data);
        }
      );
    };

    // Delete a News with the specified newsId in the request
    exports.delete = (req, res) => {
      News.remove(req.params.newsId, (err, data) => {
        if (err) {
          if (err.kind === "not_found") {
            res.status(404).send({
              message: `News record not found ID: ${req.params.newsId}.`
            });
          } else {
            res.status(500).send({
              message: "Could not delete News ID: " + req.params.newsId
            });
          }
        } else res.send({ message: `News was deleted successfully!` });
      });
    };

    // Delete all News from the database.
    exports.deleteAll = (req, res) => {
      News.removeAll((err, data) => {
        if (err)
          res.status(500).send({
            message:
              err.message || "Error occurred while removing all news."
          });
        else res.send({ message: `Delete all News successfully!` });
      });
    };

module.exports = app => {
  const news = require("../controllers/news.controller.js");

  // Add a new news in database
  app.post("/news/create", news.create);

  // Fetch all News for database
  app.get("/news", news.findAll);

  // Fetch data a single News form database
  app.get("/news/:newsId", news.findOne);

  // Update a News records
  app.put("/news/update/:newsId", news.update);

  // Delete a News records
  app.delete("/news/delete/:newsId", news.delete);

  // Delete All News records
  app.delete("/news/delete", news.deleteAll);
};

// POST Method
  http://localhost:9090/news/create

  // Body JSON
  {
    "title": "Lorem Ipsum is simply dummy text of the printing and typesetting industry.",
    "description": "Lorem Ipsum is simply dummy text of the printing and typesetting industry.",
    "status" : 1,
    "publish_date": "1634369809",
    "created_date": "1634369809",
    "modified_date": "1634369809"
  }

// GET Method
  http://localhost:9090/news/1
  
  // Response JSON
  {
    "title": "Lorem Ipsum is simply dummy text of the printing and typesetting industry.",
    "description": "Lorem Ipsum is simply dummy text of the printing and typesetting industry.",
    "status" : 1,
    "publish_date": "1634369809",
    "created_date": "1634369809",
    "modified_date": "1634369809"
  }

// GET Method
  http://localhost:9090/news
  
  // Response JSON
  [
    {
      "title": "Lorem Ipsum is simply dummy text of the printing and typesetting industry.",
      "description": "Lorem Ipsum is simply dummy text of the printing and typesetting industry.",
      "status" : 1,
      "publish_date": "1634369809",
      "created_date": "1634369809",
      "modified_date": "1634369809"
    }
  ]

// PUT Method
  http://localhost:9090/news/update/1
  
  // Body JSON
  {
    "title": "update_Lorem Ipsum is simply dummy text of the printing and typesetting industry.",
    "description": "update_Lorem Ipsum is simply dummy text of the printing and typesetting industry.",
    "status" : 1,
    "publish_date": "1634369801",
    "created_date": "1634369801",
    "modified_date": "1634369801"
  }

// DELETE Method
  http://localhost:9090/news/delete/1
  // Message
  {
    "message": "News was deleted successfully!"
  }

// DELETE Method
  http://localhost:9090/news/delete
  // Message
  {
    "message": "Delete all News successfully!"
  }

The post NodeJS RESTfull APIs with Express and MySQL first appeared on Tech Arise.

• Create a new DateTime object with PHP.
• Convert the DateTime object to the timezone of New_York using the DateTimeZone object.
• Specify the date and time format.

// Set the timezone to "America/New_York"
$date = new DateTime("now", new DateTimeZone('America/New_York') );

// Get the current date and time in the specified timezone
$dateTime = $date->format('Y-m-d H:i:s');

echo $dateTime;

The post How to get current date, given a timezone in PHP first appeared on Tech Arise.

• laravel-registration-login
  • app
    • Console
    • Exceptions
    • Http
      • Controllers
        • Auth
          • AuthController.php
    • Models
      • User.php
    • Providers
  • resources
  • config
  • database
  • public
    • assets
      • css
        • style.css
      • images
      • js
        • app.js
    • .htaccess
    • index.php
  • resources
    • views
      • dashboard.blade.php
      • layout.blade.php
      • auth
        • login.blade.php
        • registration.blade.php
  • routes
    • api.php
    • channels.php
    • console.php
    • web.php
  • storage
  • tests
  • vendor
  • .env
  • server.php

• Step 1 – Firstly, Install Laravel Application
• Step 2 – Configure Database
• Step 3 – Create Controller and Methods.
• Step 4 – Create Routes
• Step 5 – Create Blade Views
• Step 6 – Finally, Run Laravel Application

composer create-project --prefer-dist laravel/laravel laravel-registration-login

DB_CONNECTION=mysql
    DB_HOST=127.0.0.1
    DB_PORT=3306
    DB_DATABASE=demo_DB
    DB_USERNAME=root
    DB_PASSWORD=

php artisan migrate

<?php

/**
 * Description of Users Controller
 *
 * @author Team TechArise
 *
 * @email info@techarise.com
 */

namespace App\Http\Controllers\Auth;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Session;
use App\Models\User;
use Hash;

class AuthController extends Controller
{
    // code login method
    public function index()
    {
        return view('auth.login');
    }
    // code registration method
    public function registration()
    {
        return view('auth.registration');
    }

    // code action login method
    public function actionLogin(Request $request)
    {
        $request->validate([
            'email' => 'required',
            'password' => 'required',
        ]);

        $credentials = $request->only('email', 'password');
        if (Auth::attempt($credentials)) {
            return redirect()->intended('dashboard')
                ->withSuccess('You have Successfully loggedin');
        }
        return redirect("login")->withSuccess('Please enter valid credentials');
    }

    // code action registration method
    public function actionRegistration(Request $request)
    {
        $request->validate([
            'name' => 'required',
            'email' => 'required|email|unique:users',
            'password' => 'required|min:6',
        ]);

        $data = $request->all();
        $check = $this->create($data);
        return redirect("dashboard")->withSuccess('You have Successfully logged-in');
    }

    // code dashboard method
    public function dashboard()
    {
        if (Auth::check()) {
            return view('dashboard');
        }
        return redirect("login")->withSuccess('You do not have access');
    }

    // code create method
    public function create(array $data)
    {
        return User::create([
            'name' => $data['name'],
            'email' => $data['email'],
            'password' => Hash::make($data['password'])
        ]);
    }

    // code logout method
    public function logout()
    {
        Session::flush();
        Auth::logout();
        return Redirect('login');
    }
}


?>

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\Auth\AuthController;
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
// custom create routes 
Route::get('/', [AuthController::class, 'index'])->name('login');
Route::get('login', [AuthController::class, 'index'])->name('login');
Route::post('action-login', [AuthController::class, 'actionLogin'])->name('login.action');
Route::get('registration', [AuthController::class, 'registration'])->name('register');
Route::post('action-registration', [AuthController::class, 'actionRegistration'])->name('register.action');
Route::get('dashboard', [AuthController::class, 'dashboard']);
Route::get('logout', [AuthController::class, 'logout'])->name('logout');

?>

<!doctype html>
<html lang="en">

<head>
    <link rel="canonical" href="https://techarise.com/" />
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link rel="icon" type="image/ico" href="https://techarise.com/wp-content/themes/v1/favicon.ico">
    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
    <!--- Custom css --->
    <link rel="stylesheet" type="text/css" href="{{ url('/assets/css/sticky-footer-navbar.css') }}" />
    <link rel="stylesheet" type="text/css" href="{{ url('/assets/css/style.css') }}" />

    <title>Laravel 9 Login and Registration | Tech Arise</title>
</head>

<body>
    <header>
        <nav class="navbar navbar-expand-md navbar-dark fixed-top bg-dark">
            <div class="container-fluid">
                <a class="navbar-brand" href="https://techarise.com">TechArise</a>
                <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-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 me-auto mb-2 mb-md-0">
                        <li class="nav-item">
                            <a class="nav-link active" aria-current="page" href="https://techarise.com">Home</a>
                        </li>
                        @guest
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('login') }}">Login</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('register') }}">Register</a>
                        </li>
                        @else
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('logout') }}">Logout</a>
                        </li>
                        @endguest
                    </ul>
                </div>
            </div>
        </nav>
    </header>

    @yield('content')

    <footer class="footer">
        <div class="container">&nbsp;</div>
    </footer>

    <script src="https://code.jquery.com/jquery-3.6.0.js" integrity="sha256-H+K7U5CnXl1h5ywQfKtSj8PCmoN9aaq30gDh27Xc0jk=" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>

</body>

</html>

@extends('layout')

@section('content')

<main class="flex-shrink-0">
    <div class="container mt-5">
        <div class="row justify-content-center">
            <div class="col-md-8">
                <h2 class="mt-5 text-center">Laravel 9 Login and Registration</h2>
                <div class="card">
                    <div class="card-header">Login</div>
                    <div class="card-body">
                        <form action="{{ route('login.action') }}" method="POST">
                            @csrf
                            <div class="form-group row">
                                <label for="email_address" class="col-md-4 col-form-label text-md-right">E-Mail Address</label>
                                <div class="col-md-6">
                                    <input type="text" id="email_address" class="form-control" name="email" required autofocus>
                                    @if ($errors->has('email'))
                                    <span class="text-danger">{{ $errors->first('email') }}</span>
                                    @endif
                                </div>
                            </div>
                            <div class="form-group row">
                                <label for="password" class="col-md-4 col-form-label text-md-right">Password</label>
                                <div class="col-md-6">
                                    <input type="password" id="password" class="form-control" name="password" required>
                                    @if ($errors->has('password'))
                                    <span class="text-danger">{{ $errors->first('password') }}</span>
                                    @endif
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-md-6 offset-md-4">
                                    <div class="checkbox">
                                        <label>
                                            <input type="checkbox" name="remember"> Remember Me
                                        </label>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-6 offset-md-4">
                                <button type="submit" class="btn btn-primary">
                                    Login
                                </button>
                                <a href="{{ route('register') }}" class="text-primary" style="float: right;">Register</a>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</main>

@endsection

@extends('layout')

@section('content')

<main class="flex-shrink-0">
    <div class="container mt-5">
        <div class="row justify-content-center">
            <div class="col-md-8">
                <h2 class="mt-5 text-center">Laravel 9 Login and Registration</h2>
                <div class="card">
                    <div class="card-header">Register</div>
                    <div class="card-body">
                        <form action="{{ route('register.action') }}" method="POST">
                            @csrf
                            <div class="form-group row">
                                <label for="name" class="col-md-4 col-form-label text-md-right">Name</label>
                                <div class="col-md-6">
                                    <input type="text" id="name" class="form-control" name="name" required autofocus>
                                    @if ($errors->has('name'))
                                    <span class="text-danger">{{ $errors->first('name') }}</span>
                                    @endif
                                </div>
                            </div>
                            <div class="form-group row">
                                <label for="email_address" class="col-md-4 col-form-label text-md-right">E-Mail Address</label>
                                <div class="col-md-6">
                                    <input type="text" id="email_address" class="form-control" name="email" required autofocus>
                                    @if ($errors->has('email'))
                                    <span class="text-danger">{{ $errors->first('email') }}</span>
                                    @endif
                                </div>
                            </div>
                            <div class="form-group row">
                                <label for="password" class="col-md-4 col-form-label text-md-right">Password</label>
                                <div class="col-md-6">
                                    <input type="password" id="password" class="form-control" name="password" required>
                                    @if ($errors->has('password'))
                                    <span class="text-danger">{{ $errors->first('password') }}</span>
                                    @endif
                                </div>
                            </div>
                            <div class="col-md-6 offset-md-4">
                                <button type="submit" class="btn btn-primary">
                                    Register
                                </button>
                                <a href="{{ route('login') }}" class="text-primary" style="float: right;">Login</a>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</main>

@endsection

@extends('layout')

@section('content')

<main class="flex-shrink-0">
    <div class="container mt-5">
        <div class="row justify-content-center">
            <div class="col-md-8">
                <h2 class="mt-5 text-center">Laravel 9 Login and Registration</h2>
                <div class="card">
                    <div class="card-header">{{ __('Dashboard') }}</div>
                    <div class="card-body">
                        @if (session('success'))
                        <div class="alert alert-success" role="alert">
                            {{ session('success') }}
                        </div>
                        @endif
                        You are Logged In
                    </div>
                </div>
            </div>
        </div>
    </div>
</main>

@endsection

php artisan serve
    If want to run the project different port to use the below command
    php artisan serve --port=9090

http://localhost:8000/login

The post Laravel 9 Registration and Login using MySQL first appeared on Tech Arise.

• html-pdf-javascript
  • css
  • js
    • jsPDF.js
  • templates
    • header.php
    • footer.php
  • index.php
  • menus.php.php

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css">
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.3.1/jspdf.umd.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/1.2.1/html2canvas.min.js"></script>
    <script src="js/jsPDF.js"></script>

<?php
include('templates/header.php');
?>
<main role="main" class="container mcontainer">
	<div class="row home-sections">
		<h2 class="mt-5">Convert HTML Content to PDF using JavaScript</h2>
	</div>

	<div class="row">
		<div class="col-md-12">
			<form name="foo" method="post" class="input-form" enctype="multipart/form-data">
				<div style="margin-bottom: 25px" class="input-group">
					<div class="custom-file">
						<input type="file" name="fileUpload" class="custom-file-input" id="file-upl" required accept=".html,.htm">
						<label class="custom-file-label" for="file-upl">Choose file...</label>
					</div>
				</div>
				<div class="content-preview">
					<div id="previewHtmlContent"></div>
				</div>
				<div style="float: right;">
					<button type="button" class="btn btn-info btn-sm" id="previewHtml">Preview</button>
					<span id="error-message" class="error"></span>
					<button type="button" class="btn btn-success hidden btn-sm" id="convertHTMLToPDF">Create PDF</button>
				</div>
			</form>
		</div>
	</div>
</main>
<?php include('templates/footer.php'); ?>

jQuery(document).ready(function() {
    // preview file
    jQuery(document).on('click', 'button#previewHtml', function() {
        previewHTMLFile();
    });
    // convert pdf file
    jQuery(document).on('click', 'button#convertHTMLToPDF', function() {
        saveHTMLToPDF();
    });
});

// upload pdf file and preview method
function previewHTMLFile() {
    var fileContents = '';
    jQuery("#error-message").html("");
    var uplfilePath = jQuery('input#file-upl').get(0).files[0];

    if (jQuery(uplfilePath).length != 0) {
        var filereader = new FileReader();
        filereader.onload = function(e) {
            fileContents = e.target.result;
            jQuery(".content-preview").show();
            jQuery("#previewHtmlContent").html(fileContents);
            jQuery("#previewHtml").addClass('hidden');
            jQuery("#convertHTMLToPDF").removeClass('hidden');
        }
        filereader.readAsText(uplfilePath);
    } else {
        jQuery("#error-message").html("Please choose file.").show();
    }
}

// generate pdf file
function saveHTMLToPDF() {
    const { jsPDF } = window.jspdf;
    var doc = new jsPDF('l', 'mm', [1200, 1210]);
    var pdfJS = document.querySelector('#previewHtmlContent');
    doc.html(pdfJS, {
        callback: function(doc) {
            // Save the PDF
            doc.save("sample-document.pdf");
        },
        x: 10,
        y: 10
    });
}

// preview file
    jQuery(document).on('click', 'button#previewHtml', function() {
        previewHTMLFile();
    });

// upload html file and preview
    function previewHTMLFile() {
        var fileContents = '';
        jQuery("#error-message").html("");
        var uplfilePath = jQuery('input#file-upl').get(0).files[0];

        if (jQuery(uplfilePath).length != 0) {
            var filereader = new FileReader();
            filereader.onload = function(e) {
                fileContents = e.target.result;
                jQuery(".content-preview").show();
                jQuery("#previewHtmlContent").html(fileContents);
                jQuery("#previewHtml").addClass('hidden');
                jQuery("#convertHTMLToPDF").removeClass('hidden');
            }
            filereader.readAsText(uplfilePath);
        } else {
            jQuery("#error-message").html("Please choose file.").show();
        }
    }

// convert pdf file
    jQuery(document).on('click', 'button#convertHTMLToPDF', function() {
        saveHTMLToPDF();
    });

// generate pdf file and save
function saveHTMLToPDF() {
    const { jsPDF } = window.jspdf;
    var doc = new jsPDF('l', 'mm', [1200, 1210]);
    var pdfJS = document.querySelector('#previewHtmlContent');
    doc.html(pdfJS, {
        callback: function(doc) {
            // Save the PDF
            doc.save("sample-document.pdf");
        },
        x: 10,
        y: 10
    });
}

<!doctype html>
<html lang="en">
  <head>
    <meta name="google-site-verification" content="jlByZLO42gqjZgfAEj29-VYfJC2hEwUj1KSeQpiGJcI" />
		<link rel="canonical" href="https://techarise.com/" />
		<meta name="author" content="TechArise">
		<meta name="description" content="Learn Web Development Tutorials & Web Developer Resources, PHP, MySQL, jQuery, CSS, XHTML, jQuery UI, CSS3, HTML5, HTML, web design, webdesign, with TechArise tutorials. View live demo">
		<meta name="keywords" content="TechArise, tutorial TechArise, tutorials, freebies, resources, web development, webdev, demo, PHP, MySQL, jQuery, CSS, XHTML, jQuery UI, CSS3, HTML5, HTML, web design, webdesign, php script, dynamic web content" />
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link rel="icon" type="image/ico" href="https://techarise.com/wp-content/themes/v1/favicon.ico">
    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css">
    <link href="http://maxcdn.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css" rel="stylesheet">
		<link rel="stylesheet" href="css/style.css" />
		<title> Convert HTML Content to PDF using JavaScript | Tech Arise</title> 

  </head>
  <body>
<?php include('menus.php'); ?>

<header>
  <!-- Fixed navbar -->
  <nav class="navbar navbar-expand-md navbar-dark fixed-top bg-dark" style="background: #273E4A!important;">
    <a class="navbar-brand" href="https://techarise.com"><strong>Tech Arise</strong></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 mr-auto">
        <li class="nav-item active">
          <a class="nav-link" href="https://techarise.com">Home <span class="sr-only">(current)</span></a>
        </li>
      </ul>
      <span class="nav-item dropdown">
        <a style="color:#fff;" class="nav-link" href="index.php" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
          <i class="fa fa-user" style="width:20px;"></i> Demo
        </a>
      </span>
    </div>
  </nav>
</header>

<footer class="footer">
  <div class="container">&nbsp;</div>
</footer>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.3.1/jspdf.umd.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/1.2.1/html2canvas.min.js"></script>
<script src="js/jsPDF.js"></script>
</body>

</html>

The post Convert HTML Content to PDF using JavaScript first appeared on Tech Arise.

• pagination-php-mysql
  • class
    • DBConnection.php
    • Employee.php
  • templates
    • header.php
    • footer.php
  • index.php

//Table structure for table `employee`
   CREATE TABLE `employee` (
    `id` int(11) NOT NULL,
    `name` varchar(255) NOT NULL,
    `email` varchar(255) DEFAULT NULL,
    `gender` varchar(11) NOT NULL,
    `address` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

  ALTER TABLE `employee`
    ADD PRIMARY KEY (`id`);

  ALTER TABLE `employee`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

//Dumping data for table `employee`

INSERT INTO `employee` (`id`, `name`, `email`, `gender`, `address`) VALUES
(1, 'Adam', 'adam@techarisel.com', 'Male', 'New York'),
(2, 'Admin', 'admin@techarisel.com', 'Male', 'Boston'),
(3, 'User', 'user@techarisel.com', 'Male', 'California'),
(4, 'Author', 'author@techarisel.com', 'Male', 'Washington '),
(5, 'Sam', 'sam@techarisel.com', 'Male', 'Delhi'),
(6, 'James', 'james@techarisel.com', 'Male', 'Chennai'),
(7, 'Jakey', 'jakey@techarisel.com', 'Male', 'Mumbai'),
(8, 'Harry', 'harry@techarisel.com', 'Male', 'Kolkata'),
(9, 'John', 'john@techarisel.com', 'Male', 'Lucknow'),
(10, 'Lily', 'lily@techarisel.com', 'Female', 'Landon'),
(11, 'Smith', 'smith@techarisel.com', 'Male', 'New York'),
(12, 'Jacab', 'jacab@techarisel.com', 'Male', 'California'),
(13, 'Joseph', 'joseph@techarisel.com', 'Male', 'Washington '),
(14, 'Jolly', 'jolly@techarisel.com', 'Male', 'Delhi');

<?php
/**
 * @package DBConnection
 *
 * @author TechArise Team
 *
 * @email  info@techarise.com
 *   
 */

// Database Connection
class DBConnection {
    private $_dbHostname = "localhost";
    private $_dbName = "techarise_DB";
    private $_dbUsername = "root";
    private $_dbPassword = "";
    private $_con;

    public function __construct() {
      try {
          $this->_con = new PDO("mysql:host=$this->_dbHostname;dbname=$this->_dbName", $this->_dbUsername, $this->_dbPassword);    
          $this->_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
      } catch(PDOException $e) {
      echo "Connection failed: " . $e->getMessage();
    }

    }
    // return Connection
    public function returnConnection() {
        return $this->_con;
    }
}

?>

• The class handles the Employee process.
• __construct() – Loads the required class.
• getAllEmployee() – list all recoreds from database
• countEmployee() – count emp records from database

<?php
/**
 * @package Employee class
 *
 * @author TechArise Team
 *
 * @email  info@techarise.com
 *   
 */

// include connection class
include("DBConnection.php");
// Employee
class Employee 
{
    protected $db;
    private $_page;
    private $_rowPerPage;
    private $_start;

    public function setPage($page) {
        $this->_page = $page;
    }

    public function setRowPerPage($rowPerPage) {
        $this->_rowPerPage = $rowPerPage;
    }
    public function setStart($start) {
        $this->_start = $start;
    }
    public function setStatus($status) {
        $this->_status = $status;
    }
    
    // __construct
    public function __construct() {
        $this->db = new DBConnection();
        $this->db = $this->db->returnConnection();
    }

    // getAll Employee
    public function getAllEmployee() {
      try {
        $sql = "SELECT * FROM employee ";
            $limit=" limit " . $this->_start . "," . $this->_rowPerPage;
            $query = $sql.$limit;
        $stmt = $this->db->prepare($query);
        
        $stmt->execute();
        $result = $stmt->fetchAll(\PDO::FETCH_ASSOC);
            return $result;
    } catch (Exception $err) {
        die("Oh noes! There's an error in the query! " . $err);
    }
    }
    // count Employee
    public function countEmployee() {
      try {
        $sql = "SELECT * FROM employee";
        $stmt = $this->db->prepare($sql);
        $stmt->execute();
        $count = $stmt->rowCount();
            return $count;
    } catch (Exception $err) {
        die("Oh noes! There's an error in the query! " . $err);
    }
    }

}

?>

<?php
include_once 'class/Employee.php';
// Number of entries to show in a page.
define("ROW_PER_PAGE", 5);
$page = 1;
$start = 0;
// Look for a GET variable page if not found default is 1.
if (!empty($_GET["page"])) {
  $page = $_GET["page"];
  $start = ($page - 1) * ROW_PER_PAGE;
}
$emp = new Employee();
$emp->setRowPerPage(ROW_PER_PAGE);
$emp->setStart($start);
$emp->setPage($page);
$empInfo = $emp->getAllEmployee();
$rowCount = $emp->countEmployee();
include('templates/header.php');
$per_page_html = '';
?>
<section class="showcase">
  <div class="container">
    <div class="pb-2 mt-4 mb-2 border-bottom">
      <h2 class="text-center">Simple Pagination Using PHP and MySQL</h2>
    </div>
    <div class="page-content page-container" id="page-content">
      <div class="padding">
        <div class="row container d-flex justify-content-center">
          <div class="col-lg-12">
            <div class="card px-3">
              <div class="card-body">
                <div class="list-wrapper">
                  <table class="table table-striped">
                    <thead>
                      <tr>
                        <th style="width: 20%;">Name</th>
                        <th style="width: 30%;">Email</th>
                        <th style="width: 20%;">Gender</th>
                        <th style="width: 30%;">Address</th>
                      </tr>
                    </thead>
                    <tbody>
                      <?php
                      // Showing the Records
                      foreach ($empInfo as $key => $element) { ?>
                        <tr>
                          <td><?php echo $element['name']; ?></td>
                          <td><?php echo $element['email']; ?></td>
                          <td><?php echo $element['gender']; ?></td>
                          <td><?php echo $element['address']; ?></td>
                        </tr>
                      <?php } ?>
                    </tbody>
                  </table>
                  <?php
                  //Showing the Page Navigation
                  if (!empty($rowCount)) {
                    $per_page_html .= '<ul class="pagination float-right">';
                    $page_count = ceil($rowCount / ROW_PER_PAGE);
                    if ($page_count > 1) {
                      for ($i = 1; $i <= $page_count; $i++) {
                        if ($i == $page) {
                          $per_page_html .= '<li class="page-item active"><a class="page-link" href="?page=' . $i . '">' . $i . '</a></li>';
                        } else {
                          $per_page_html .= '<li class="page-item"><a class="page-link" href="?page=' . $i . '">' . $i . '</a></li>';
                        }
                      }
                    }
                    $per_page_html .= "</ul>";
                  }
                  echo $per_page_html;
                  ?>

                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</section>
<?php include('templates/footer.php'); ?>
?>

<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="description" content="">
  <meta name="author" content="">

  <title>Simple Pagination Using PHP and MySQL | Tech Arise</title>
  <!-- Bootstrap core CSS -->
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.3.1/css/bootstrap.min.css" />
  <!-- Custom fonts for this template -->
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.7.2/css/all.min.css" />
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/simple-line-icons/2.4.1/css/simple-line-icons.css" />
  <link href="https://fonts.googleapis.com/css?family=Lato:300,400,700,300italic,400italic,700italic" rel="stylesheet" type="text/css">
  <!-- Custom styles for this template -->
  <link href="css/style.css" rel="stylesheet">
</head>

<body>
  <!-- Navigation -->
  <nav class="navbar navbar-expand-lg navbar-dark bg-dark static-top header-bg-dark" style="background: #FFFFFF;">
    <div class="container">
      <a class="navbar-brand font-weight-bold" href="https://techarise.com">
        <h1>Tech Arise</h1>
      </a>
      <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">
        <span class="navbar-toggler-icon"></span>
      </button>
      <div class="collapse navbar-collapse" id="navbarResponsive">
        <ul class="navbar-nav ml-auto">
          <li class="nav-item active">
            <a class="nav-link" href="https://techarise.com">Home
              <span class="sr-only">(current)</span>
            </a>
          </li>
          <li class="nav-item">
            <a class="nav-link" href="https://techarise.com/php-free-script-demos/">Live Demo</a>
          </li>
        </ul>
      </div>
    </div>
  </nav>

<!-- Footer -->
<footer class="footer bg-light footer-bg-dark">
  <div class="container">
    <div class="row">
      <div class="col-lg-6 h-100 text-center text-lg-left my-auto">
        <ul class="list-inline mb-2">
          <li class="list-inline-item">
            <a href="#">About</a>
          </li>
          <li class="list-inline-item">&sdot;</li>
          <li class="list-inline-item">
            <a href="#">Contact</a>
          </li>
          <li class="list-inline-item">&sdot;</li>
          <li class="list-inline-item">
            <a href="#">Terms of Use</a>
          </li>
          <li class="list-inline-item">&sdot;</li>
          <li class="list-inline-item">
            <a href="#">Privacy Policy</a>
          </li>
        </ul>
        <p class="text-muted small mb-4 mb-lg-0">Copyright &copy; 2011 - <?php print date('Y', time()); ?> <a href="https://techarise.com/">TECHARISE.COM</a> All rights reserved.</p>
      </div>
      <div class="col-lg-6 h-100 text-center text-lg-right my-auto">
        <ul class="list-inline mb-0">
          <li class="list-inline-item mr-3">
            <a href="#">
              <i class="fab fa-facebook fa-2x fa-fw"></i>
            </a>
          </li>
          <li class="list-inline-item mr-3">
            <a href="#">
              <i class="fab fa-twitter-square fa-2x fa-fw"></i>
            </a>
          </li>
          <li class="list-inline-item">
            <a href="#">
              <i class="fab fa-instagram fa-2x fa-fw"></i>
            </a>
          </li>
        </ul>
      </div>
    </div>
  </div>
</footer>
<!-- Bootstrap core JavaScript -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.3.1/js/bootstrap.bundle.min.js"></script>
</body>

</html>

The post Create Simple Pagination Using PHP and MySQL first appeared on Tech Arise.

function printPage(selector, title) {
        var disp_setting="toolbar=yes,location=no,";
        disp_setting+="directories=yes,menubar=yes,";
        disp_setting+="scrollbars=yes,width=1024, height=700, left=100, top=25";
        var content_vlue = document.getElementById(selector).innerHTML;
        var print=window.open("","", disp_setting);
        print.document.open();
        print.document.write('<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"');
        print.document.write('"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">');
        print.document.write('<html>');
        print.document.write('<head><title>'+title+'</title>');
        print.document.write('<link rel="stylesheet" type="text/css" href="print_stylesheet.css" />');
        print.document.write('</head><body class="A4"><center>');
        print.document.write(content_vlue);
        print.document.write('</center></body></html>');
        setTimeout(function(){
            print.print();
            print.close();
        },500);
        
        print.focus();
    }

printPage('element_id', 'page_title')

<button type="button" name="print_btn" class="btn btn-primary" value="How to Print Page Area using JavaScript" onclick="printPage('print-page', 'Print Page Area using JavaScript')">Print Page</button>

<section class="sheet padding-5mm A4" id="print-page" style="display:none;">
        Lorem Ipsum is simply dummy text of the printing and typesetting industry
    </section>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <title>How to Print Page Area using JavaScript - TechArise</title>
    <script type="text/javascript">
        function printPage(selector, title) {
            var disp_setting="toolbar=yes,location=no,";
            disp_setting+="directories=yes,menubar=yes,";
            disp_setting+="scrollbars=yes,width=1024, height=700, left=100, top=25";
            var content_vlue = document.getElementById(selector).innerHTML;
            var print=window.open("","", disp_setting);
            print.document.open();
            print.document.write('<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"');
            print.document.write('"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">');
            print.document.write('<html>');
            print.document.write('<head><title>'+title+'</title>');
            print.document.write('<link rel="stylesheet" type="text/css" href="print_stylesheet.css" />');
            print.document.write('</head><body class="A4"><center>');
            print.document.write(content_vlue);
            print.document.write('</center></body></html>');
            setTimeout(function(){
                print.print();
                print.close();
            },500);
            
            print.focus();
        }
    </script>

</head>

<body>
	<button type="button" name="print_btn" class="btn btn-primary" value="How to Print Page Area using JavaScript" onclick="printPage('print-page', 'Print Page Area using JavaScript')">Print Page</button>
    <section class="sheet padding-5mm A4" id="print-page" style="display:none;">
        <article>
            <table width="98%" class="w-100">
                <thead>
                    <tr>
                        <td class="text-center p-0 m-0" colspan="2">
                            <h2 class="m-0 text-bold">How to Print Page Area using JavaScript</h2>
                        </td>
                    </tr>
                </thead>
                <tbody>
                    <td class=" p-0" colspan="2">
                        <br />
                    <table class="tableBorderAll">
                    <tr>
                        <td class="text-bold" style="width: 33%;text-transform: uppercase;text-align: center;">Name</td>
                        <td class="text-bold p-0 pr-15" style="width: 33%;">Team TechArise</td>
            			<td class="text-bold" style="width: 34%;">Avatar</td>
                    </tr>
                    <tr>
                        <td class="text-bold" style="text-transform: uppercase;">Email</td>
                        <td class="text-bold p-0 pr-15">info@techarise.com</td>
                        <td rowspan="7" class="text-bold">
                            <img src="User-Icon-File.png" style="width:100%;padding:5px;">
                    </tr>
                    <tr>
                        <td class="text-bold" style="text-transform: uppercase;">Mobile</td>
                        <td class="text-bold p-0 pr-15">9000000001</td>
                    </tr>
                    <tr>
                        <td class="text-bold" style="text-transform: uppercase;">Address</td>
                        <td class="text-bold p-0 pr-15">B 45/90, San Francisco</td>
                    </tr>
                    <tr>
                        <td class="text-bold" style="text-transform: uppercase;">Country</td>
                        <td class="text-bold p-0 pr-15">United States</td>
                    </tr>
                    <tr>
                        <td class="text-bold" style="text-transform: uppercase;">Salary</td>
                        <td class="text-bold p-0 pr-15">$12000</td>
                    </tr>
                    <tr>
                        <td class="text-bold" style="text-transform: uppercase;">Department</td>
                        <td class="text-bold p-0 pr-15">Information technology (IT)</td>
                    </tr>
                    
                    </table>
                    <br>
                    </td>
                </tbody>
            </table>
        </article>
    </section>
</body>

</html>

The post How to Print Page Area using JavaScript first appeared on Tech Arise.

#write-program.py

import json
  
data = {
    "usermame" : "admin",
    "name": "Tech Arise"
    "email" : "admin@techarise.com",
    "password" : "admin",
}
  
userObject = json.dumps(data, indent = 4)
  
with open("user.json", "w") as outFile:
    outFile.write(userObject)

#read-program.py

import json

with open('user.json', 'r') as openFile:
  
    userObject = json.load(openFile)
  
print(userObject)
print(type(userObject))

{'username': 'admin', 'name': 'Tech Arise', 'email': 'admin@techarise.com', 'password': 'admin'}
    <class 'dict'>

The post Read and Write JSON to File in Python first appeared on Tech Arise.

• restful-api-using-python-mysql
  • app.py
  • config.py
  • main.py

• GET — is used for reading and retrieving data.
• POST — is used for inserting data.
• PUT/PATCH — is used for updating data.
• DELETE — is used for deleting data.

CREATE TABLE `employee` (
        `id` int(11) NOT NULL,
        `name` varchar(255) NOT NULL,
        `email` varchar(255) NOT NULL,
        `phone` varchar(16) DEFAULT NULL,
        `address` text DEFAULT NULL,
        `salary` float DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    ALTER TABLE `employee`
        ADD PRIMARY KEY (`id`);

    ALTER TABLE `employee`
        MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
        COMMIT;

pip install Flask

pip install -U flask-cors

from flask import Flask
from flask_cors import CORS, cross_origin

app = Flask(__name__)
CORS(app)

pip install flask-mysql

from app import app
from flaskext.mysql import MySQL

mysql = MySQL()
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = ''
app.config['MYSQL_DATABASE_DB'] = 'restapi_DB'
app.config['MYSQL_DATABASE_HOST'] = 'localhost'
mysql.init_app(app)

import pymysql
from app import app
from config import mysql
from flask import jsonify
from flask import flash, request

@app.route('/employee/create', methods=['POST'])
def create_employee():
    try:        
        _json = request.json
        _name = _json['name']
        _email = _json['email']
        _phone = _json['phone']
        _address = _json['address']	
        _salary = _json['salary']	

        if _name and _email and _phone and _address and _salary and request.method == 'POST':
            conn = mysql.connect()
            cursor = conn.cursor(pymysql.cursors.DictCursor)		
            sqlQuery = "INSERT INTO employee(name, email, phone, address, salary) VALUES(%s, %s, %s, %s, %s)"
            bindData = (_name, _email, _phone, _address, _salary)            
            cursor.execute(sqlQuery, bindData)
            conn.commit()
            cursor.close() 
            respone = jsonify('Employee created successfully!')
            respone.status_code = 200
            return respone
        else:
            return showMessage()
    except Exception as err:
        print(err)
    finally:
        
        conn.close()          
    
@app.route('/employee')
def employee():
    try:
        conn = mysql.connect()
        cursor = conn.cursor(pymysql.cursors.DictCursor)
        cursor.execute("SELECT id, name, email, phone, address, salary FROM employee")
        empRows = cursor.fetchall()
        respone = jsonify(empRows)
        respone.status_code = 200
        return respone
    except Exception as err:
        print(err)
    finally:
        cursor.close() 
        conn.close()  

@app.route('/employee/<int:employee_id>')
def employee_details(employee_id):
    try:
        conn = mysql.connect()
        cursor = conn.cursor(pymysql.cursors.DictCursor)
        cursor.execute("SELECT id, name, email, phone, address, salary FROM employee WHERE id =%s", employee_id)
        empRow = cursor.fetchone()
        respone = jsonify(empRow)
        respone.status_code = 200
        return respone
    except Exception as err:
        print(err)
    finally:
        cursor.close() 
        conn.close() 

@app.route('/employee/update', methods=['PUT'])
def update_employee():
    try:
        _json = request.json
        _id = _json['id']
        _name = _json['name']
        _email = _json['email']
        _phone = _json['phone']
        _address = _json['address']
        _salary = _json['salary']
        if _name and _email and _phone and _address and _id and request.method == 'PUT':			
            sqlQuery = "UPDATE employee SET name=%s, email=%s, phone=%s, address=%s, salary=%s WHERE id=%s"
            bindData = (_name, _email, _phone, _address, _salary, _id,)
            conn = mysql.connect()
            cursor = conn.cursor()
            cursor.execute(sqlQuery, bindData)
            conn.commit()
            respone = jsonify('Employee updated successfully!')
            respone.status_code = 200
            return respone
        else:
            return showMessage()
    except Exception as err:
        print(err)
    finally:
        cursor.close() 
        conn.close() 

@app.route('/employee/delete/<int:employee_id>', methods=['DELETE'])
def delete_employee(employee_id):
    try:
        conn = mysql.connect()
        cursor = conn.cursor()
        cursor.execute("DELETE FROM employee WHERE id =%s", (employee_id,))
        conn.commit()
        respone = jsonify('Employee deleted successfully!')
        respone.status_code = 200
        return respone
    except Exception as err:
        print(err)
    finally:
        cursor.close() 
        conn.close()
        
@app.errorhandler(404)
def showMessage(error=None):
    message = {
        'status': 404,
        'message': 'Record not found: ' + request.url,
    }
    respone = jsonify(message)
    respone.status_code = 404
    return respone
        
if __name__ == "__main__":
    app.run()

http://127.0.0.1:5000/employee/create

http://127.0.0.1:5000/employee

http://127.0.0.1:5000/employee/1

http://127.0.0.1:5000/employee/update

http://127.0.0.1:5000/employee/delete/1

The post Create RESTful API using Python and MySQL first appeared on Tech Arise.

pip install pymongo

from pymongo import MongoClient

mongoClient = MongoClient() 
db = mongoClient.october_mug_talk
db.segment.drop()

import csv

csvfile = open('current.csv', 'r')
reader = csv.DictReader( csvfile )

for each in reader:
    row={}
    for field in header:
        row[field]=each[field]

db.segment.insert(row)

import csv
import json
import pandas as pd
import sys, getopt, pprint
from pymongo import MongoClient
#Conversion CSV to JSON 
csvfile = open('current.csv', 'r')
reader = csv.DictReader( csvfile )
mongo_client=MongoClient() 
db=mongo_client.october_mug_talk
db.segment.drop()
header= [ "First Name", "Last Name", "Email", "Mobile", "Address", "Date"]

for each in reader:
    row={}
    for field in header:
        row[field]=each[field]

    db.segment.insert(row)

The post Import CSV file data into MongoDB using Python first appeared on Tech Arise.