R E D

NAME	SIZE	PERMISSION
add.php	2.38 KB	-rwxr-xr-x
category.php	3.48 KB	-rwxr-xr-x
del.php	2.09 KB	-rwxr-xr-x
fetch.php	3.54 KB	-rwxr-xr-x
update.php	2.44 KB	-rwxr-xr-x

Code Editor : fetch.php

<?php
try {

require_once("../../server/server.php");
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $data = json_decode(file_get_contents("php://input"), true);
        if ($data !== "" && count($data) !== 0) {
            if (isset($data["AuthToken"]) && $data["AuthToken"] !== "") {
                $Auth = $data["AuthToken"];
                $id = $_SESSION["lms-ID"];
                $query = $db->prepare("SELECT AuthToken FROM user where ID = '$id'");
                if ($query->execute()) {
                    $query = $query->fetch(PDO::FETCH_ASSOC);
                    if (password_verify($Auth, $query["AuthToken"])) {;
                        if ($data["arr"] == "false") {
                            $sql = "";
                        } else {
                            $val = $data["arr"]["val"];
                            $sql = "";
                            if ($val !== "") {
                                $sql .= "WHERE name = '$val'";
                            }
                        }
                        $page = $data["page"];
                        $limit = $data["row"];
                        $id = $_SESSION["lms-ID"];
                        $page_start = ($page - 1) * $limit;
                        $select_smtp = $db->prepare("SELECT s.id AS ID, s.name AS name, c.id AS CategoryID,c.name AS CategoryName from subject s left join categories c on s.category_id = c.id " . $sql . " LIMIT $page_start, $limit");
                        $select_row = $db->prepare("SELECT count(ID) FROM subject " . $sql);
                        if ($select_row->execute()) {
                            $totalrow = $select_row->fetchColumn();
                            if ($totalrow == 0) {
                                $totalpage = 0;
                            } else {
                                if ($limit == "All") {
                                    $totalpage = 1;
                                } else {
                                    $totalpage = ceil($totalrow / $limit);
                                }
                            }
                            if ($select_smtp->execute()) {
                                $arr = array();
                                while ($row = $select_smtp->fetch(PDO::FETCH_ASSOC)) {
                                    extract($row);
                                    array_push($arr, $row);
                                }
                                http_response_code(200);
                                echo json_encode(array("status" => true, "message" => "success", "data" => $arr, "row" => $totalpage));
                            }
                        }
                    } else {
                        http_response_code(405);
                        echo json_encode(array("status" => false, "message" => "AuthToken Invalid!!"));
                        exit;
                    }
                } else {
                    http_response_code(405);
                    echo json_encode(array("status" => false, "message" => "Server Error!!"));
                    exit;
                }
            }
        } else {
            http_response_code(405);
            echo json_encode(array("status" => false, "message" => "Data exist!!"));
            exit;
        }
    } else {
        http_response_code(405);
        echo json_encode(array("status" => false, "message" => "Request method Not accept!!"));
        exit;
    }
} catch (Exception $e) {
    http_response_code(405);
    echo json_encode(array("status" => false, "message" => $e->getMessage()));
    exit;
}

${this.title}

Code Editor : fetch.php