R E D

NAME	SIZE	PERMISSION
Controller.php	8.92 KB	-rwxr-xr-x
SaveCouseManage.php	2.58 KB	-rwxr-xr-x
couseFetch.php	3.72 KB	-rwxr-xr-x
couseSelect.php	3.52 KB	-rwxr-xr-x
saveControl.php	13.35 KB	-rwxr-xr-x
save_couse.php	2.01 KB	-rwxr-xr-x

Code Editor : couseFetch.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"])) {
                        $page = $data["page"];
                        $limit = 400;
                        // $limit = $data["row"];
                        $id = $_SESSION["lms-ID"];
                        $page_start = ($page - 1) * $limit;
                        $select_smtp = $db->prepare("SELECT * FROM couse where userID = '$id' LIMIT $page_start, $limit");
                        $select = $db->prepare("SELECT avatar, name FROM user where ID = '$id' AND verify = '200'");
                        $select_row = $db->prepare("SELECT count(ID) FROM couse where userID = '$id'");
                        if ($select_row->execute()) {
                            $totalrow = $select_row->fetchColumn();
                            if ($totalrow == 0) {
                                $totalpage = 0;
                            } else {
                                if ($limit == "All") {
                                    $totalpage = 1;
                                } else {
                                    $totalpage = ceil($totalrow / $limit);
                                }
                            }
                            $arr = array();
                            if ($select_smtp->execute() && $select->execute()) {
                                $user = $select->fetch(PDO::FETCH_ASSOC);
                                while ($row = $select_smtp->fetch(PDO::FETCH_ASSOC)) {
                                    $query2 = $db->query("SELECT * FROM lesson WHERE couseID = '" . $row['ID'] . "' ");
                                    $lessonCount = $query2->rowCount();
                                    $query3 = $db->query("SELECT * FROM `questions` WHERE `couse` = '" . $row['ID'] . "' ");
                                    $questionCount = $query3->rowCount();
                                    array_push($arr, array("user" => $user, "couse" => $row, 'lessonCount' => $lessonCount, 'questionCount' => $questionCount));
                                }
                            }
                            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 : couseFetch.php