1ajax-get.php

<?php 
    include('database.php');
    error_reporting(0);
    $status = $_POST['status'];

// $formData = []; 
    $formData = array(
    'title' => array(),
    'image' => array(),
    'gif' => array(),
    'editor' => array(),
    'youtube' => array(),
    'slider' => array(),
    'ppt' => array()
);
$counter = 1;
    if($status == 'get-chapter-field') {
        $entry = [];
        // print_r($_POST);exit();
        if($_POST['chapDetailId'] == 'title') {
            // $entry['title'] = $_POST['title'];
             $entry['title'] = $_POST['title'];
        $entry['titleId'] = 'titleId_' . $counter;
?>
           <div class="col-md-12 form-group p-l-5 p-r-5" id="titleSec<?php echo $counter; ?>">
            <label class="text-capitalize">Title</label>
            <input type="text" name="title" id="<?php echo $entry['titleId']; ?>" class="form-control" placeholder="Title">
        </div>
<?php
        } else if($_POST['chapDetailId'] == 'image') {
            
            $imageCounter = count($formData['image']) + 1;
            $entry['image'] = $_POST['image'];
            $imageId = 'imageId_' . $imageCounter;
            $blahId = 'blah_' . $imageCounter;

?>
            <div class="col-md-4 form-group p-l-5 p-r-5" id="<?php echo $imageId; ?>">
                <label class="text-capitalize">Image</label>
                <div class="preview_height" style="border: 1px solid #e9e9ed;border-radius: 5px;">
                    <?php if($row['image'] == ''): ?>
                        <img src="assets/images/camera.png" id="<?php echo $blahId; ?>" class="imgpreviewC">
                    <?php else: ?>
                        <img id="<?php echo $blahId; ?>" src="<?php echo $row['image']; ?>" alt="" class="imgpreviewC" />
                    <?php endif; ?>
                    <input type="file" class="form-control" name="image[]" id="<?php echo $imageId; ?>" onchange="readURL(this, '<?php echo $blahId; ?>');" accept=".jpeg, .png, .jpg">
                </div>
            </div>
<?php
        } else if($_POST['chapDetailId'] == 'gif') {
            $entry['gif'] = $_POST['gif'];

?>
            <div class="col-md-4 form-group p-l-5 p-r-5" id="imageSec">
                <label class="text-capitalize">Gif</label>
                <div class="preview_height_1 imgBg" id="preview_height_1">
                    <img alt="" id="blah1" class="img-responsive" src="assets/newimages/upload-image-icon.png" />
                    <input type="file" id="fileInput1" name="image" class="file-upload-default">
                </div>
            </div>
<?php
        } else if($_POST['chapDetailId'] == 'editor') {

$entry['editor'] = $_POST['editor'];
            $editorId = 'editor_' . $counter;
            // Increment the counter
            $counter++;
        ?>
            <div class="col-md-12 form-group p-l-5 p-r-5" id="descSec<?php echo $counter; ?>">
                <label class="text-capitalize">Description</label>
                <textarea class="form-control ckeditor" name="description[]" id="<?php echo $editorId; ?>"></textarea>
            </div>
<?php
        } else if($_POST['chapDetailId'] == 'youtube') {
            $entry['youtube'] = $_POST['youtube'];

?>
            <div class="col-md-12 form-group p-l-5 p-r-5" id="youtubeSec">
                <label class="text-capitalize">Youtube Link</label>
                <input type="text" name="iframe" id="iframe" class="form-control" placeholder="Enter https://www.youtube.com/watch?v=...">
            </div>
<?php
        } else if($_POST['chapDetailId'] == 'slider') {
            $entry['slider'] = $_POST['slider'];

?>
            <div class="col-md-4 form-group p-l-5 p-r-5" id="imageSec">
                <label class="text-capitalize">Image</label>
                <div class="preview_height_1 imgBg" id="preview_height_1">
                    <img alt="" id="blah1" class="img-responsive" src="assets/newimages/upload-image-icon.png" />
                    <input type="file" id="fileInput2" name="image" class="file-upload-default">
                </div>
            </div>
            <div class="col-md-1">
                <button type="button" onclick="addMore(1);" class="btn btn-sm btn-primary btnAddMore"><i class="fa fa-plus"></i></button>
            </div>
            <?php 
                $i = 0;
                for($i=0; $i < 10; $i++) {
            ?>
                    <div class="col-md-4 form-group p-l-5 p-r-5" id="sliderImg<?php echo $i; ?>" style="display: none;">
                        <label class="text-capitalize">Image</label>
                        <div class="preview_height_1 imgBg" id="preview_height_1">
                            <img alt="" id="blah1" class="img-responsive" src="assets/newimages/upload-image-icon.png" />
                            <input type="file" id="fileInput<?php echo $i; ?>" name="image" class="file-upload-default">
                        </div>
                    </div>
                    <div class="col-md-1" id="addMoreBtn<?php echo $i; ?>" style="display: none;">
                        <button type="button" onclick="addMore(<?php echo $i; ?> + 1);" class="btn btn-sm btn-primary btnAddMore"><i class="fa fa-plus"></i></button>
                    </div>
                    <div class="col-md-1" id="removeMoreBtn<?php echo $i; ?>" style="display: none;">
                        <button type="button" onclick="remove(<?php echo $i; ?>);" class="btn btn-sm btn-danger btnAddMore"><i class="fa fa-trash"></i></button>
                    </div>
            <?php
                }
            ?>
<?php
        } else if($_POST['chapDetailId'] == 'ppt') {
            $entry['ppt'] = $_POST['ppt'];

?>
            <div class="col-md-12 form-group p-l-5 p-r-5" id="youtubeSec">
                <label class="text-capitalize">PPT Link</label>
                <input type="text" name="ppt" id="ppt" class="form-control" placeholder="Enter Link">
            </div>
<?php
        }
         if (isset($entry)) {
        // Add the entry array to $formData
        $formData[$_POST['chapDetailId']][] = $entry;
    }
   
?>
        <script src='https://cdn.ckeditor.com/4.7.1/standard/ckeditor.js'></script>
        <script type="text/javascript">
        $(document).ready(function() {
            $(".ckeditor").each(function() {
                var editorId = $(this).attr('id');
                CKEDITOR.replace(editorId, {
                    on: {
                        contentDom: function(evt) {
                            // Allow custom context menu only with table elements.
                            evt.editor.editable().on('contextmenu', function(contextEvent) {
                                var path = evt.editor.elementPath();
                                if (!path.contains('table')) {
                                    contextEvent.cancel();
                                }
                            }, null, null, 5);
                        }
                    }
                });
            });
        });

function readURL(input, imgId) {
                var preview = $('#' + imgId);
                if (input.files && input.files[0]) {
                    var reader = new FileReader();

reader.onload = function (e) {
                        preview.attr('src', e.target.result);
                    }

reader.readAsDataURL(input.files[0]);
                }
            }

$("#image").change(function() {
                readURL(this, 'blah'); // Assuming 'image' is the ID of the file input and 'blah' is the ID of the first image
            }); 
        </script>

<?php
    echo json_encode($formData);
    exit();
    }

if ($status == 'search-standard') {
        // exit;
        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

$query = "SELECT * FROM `tbl_standard` WHERE deleteStatus = 0";
                    // echo $query;
        if (!empty($search)) {
            $query .= " AND `name` LIKE '%".$search."%'";
        }

$query1 = $query;
        $query .= " ORDER BY `standardId` ASC LIMIT ".$offset.", ".$dataLimit;

$result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count > 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '<tr id="rowId'.$row['standardId'].'">
                    <td>'.$i.'</td>
                    <td>'.$row['indexNo'].'</td>
                    <td><img src="'.$row['image'].'" alt="table-user" class="mr-2 custmImg"></td>
                    <td>'.$row['name'].'</td>
                    <td>
                        <a href="standard.php?id='.base64_encode($row['standardId']).'" onclick="updateData('.$row['standardId'].')" class="btn btn-sm btn-warning"><i class="fas fa-pen"></i></a>
                        <a href="javascript:void(0)" onclick="deleteData('.$row['standardId'].')" class="btn btn-sm btn-danger mlbtn-5"><i class="feather-trash-2"></i></a>
                        '.$activeBtn.'
                     </td>
                </tr>';
            }
        } else {
            echo '<tr>
                <td colspan="6">
                    <center>
                        No Data Found
                    </center>
                </td>
            </tr>';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of <span id="totalEntries">'.$count1.'</span> entries';
    }

if ($status == 'search-subject') {
        // exit;
        $offset = $_POST['offset'];
        $dataLimit = $_POST['dataLimit'];
        $search = $_POST['search']; 
        $startCount = $offset + 1;

$query = "SELECT a.*,b.name AS standardName FROM tbl_subject a 
        LEFT JOIN tbl_standard b ON b.standardId = a.standardId
        WHERE a.deleteStatus = 0";
                    // echo $query;
        if (!empty($search)) {
            $query .= " AND `name` LIKE '%".$search."%'";
        }

$query1 = $query;
        $query .= " ORDER BY `subjectId` ASC LIMIT ".$offset.", ".$dataLimit;

$result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count > 0) {
            $i = $offset;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '<tr id="rowId'.$row['subjectId'].'">
                    <td>'.$i.'</td>
                    <td>'.$row['indexNo'].'</td>
                    <td><img src="'.$row['image'].'" alt="table-user" class="mr-2 custmImg"></td>
                    <td>'.$row['standardName'].'</td>
                    <td>'.$row['name'].'</td>
                    <td>
                        <a href="subject.php?id='.base64_encode($row['subjectId']).'" onclick="updateData('.$row['subjectId'].')" class="btn btn-sm btn-warning"><i class="fas fa-pen"></i></a>
                        <a href="javascript:void(0)" onclick="deleteData('.$row['subjectId'].')" class="btn btn-sm btn-danger mlbtn-5"><i class="feather-trash-2"></i></a>
                        '.$activeBtn.'
                     </td>
                </tr>';
            }
        } else {
            echo '<tr>
                <td colspan="6">
                    <center>
                        No Data Found
                    </center>
                </td>
            </tr>';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of <span id="totalEntries">'.$count1.'</span> entries';
    }

if($status == 'get-subject-list') {
        // print_r($_POST); exit;
        $standardId = $_POST['standardId'];
        $query = mysqli_query($con,"SELECT * FROM `tbl_subject` WHERE `standardId` = '".$standardId."' ORDER BY `name` ASC");
        $count = mysqli_num_rows($query);
        if($count == 0) {
            $html .='<option value="">No subject found</option>';
        } else {
            $html .='<option value="">select subject</option>';
            while($row = mysqli_fetch_array($query)) {
                $html .='<option value="'.$row['subjectId'].'">'.$row['name'].'</option>'; 
            }
        }
        echo $html;
    }

if($status == 'get-chapter-list-mcq') {
        // print_r($_POST); exit;
        $subjectId = $_POST['subjectId'];
        $query = mysqli_query($con,"SELECT * FROM `tbl_chapter` WHERE `subjectId` = '".$subjectId."' ORDER BY `name` ASC");
        $count = mysqli_num_rows($query);
        if($count == 0) {
            $html .='<option value="">No subject found</option>';
        } else {
            $html .='<option value="">select chapter</option>';
            while($row = mysqli_fetch_array($query)) {
                $html .='<option value="'.$row['chapterId'].'">'.$row['name'].'</option>'; 
            }
        }
        echo $html;
    }

if ($status == 'search-chapter') {
        // print_r($_POST); exit;

$query = "SELECT a.*, b.name AS standardName, c.name AS subjectName, b.standardId, c.subjectId FROM tbl_chapter a 
        LEFT JOIN tbl_standard b ON b.standardId = a.standardId
        LEFT JOIN tbl_subject c ON c.subjectId = a.subjectId
        LEFT JOIN tbl_chapter_details d ON d.chapterId = a.subjectId
        WHERE a.deleteStatus = 0 AND b.deleteStatus = 0";
        // if (!empty($search)) {
        //     $query .= " AND a.name LIKE '%".$search."%'";
        // }

$query1 = $query;
        $query .= " ORDER BY a.chapterId ASC";
                    // echo $query; exit;

$result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count > 0) {
            $i = 0;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '<tr id="rowId'.$row['chapterId'].'">
                    <td>'.$i.'</td>
                    <td>'.$row['indexNo'].'</td>
                    <td>'.$row['standardName'].'</td>
                    <td>'.$row['subjectName'].'</td>
                    <td>'.$row['chapterNo'].'</td>
                    <td>'.$row['name'].'</td>
                    <td>
                        <a href="add-chapter.php?id='.base64_encode($row['chapterId']).'&standardId='.base64_encode($row['standardId']).'&subjectId='.base64_encode($row['subjectId']).'" class="btn btn-sm btn-info"><i class="fas fa-plus"></i></a>
                        <a href="view-chapter-details.php?id='.base64_encode($row['chapterId']).'&standardId='.base64_encode($row['standardId']).'&subjectId='.base64_encode($row['subjectId']).'" onclick="updateData('.$row['chapterId'].')" class="btn btn-sm btn-primary"><i class="fas fa-eye"></i></a>
                        <a href="javascript:void(0)" onclick="deleteDataChap('.$row['chapterId'].')" class="btn btn-sm btn-danger mlbtn-5"><i class="feather-trash-2"></i></a>
                        '.$activeBtn.'
                     </td>
                </tr>';
            }
        } else {
            echo '<tr>
                <td colspan="6">
                    <center>
                        No Data Found
                    </center>
                </td>
            </tr>';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of <span id="totalEntries">'.$count1.'</span> entries';
    }

if ($status == 'search-viewqp') {
        // print_r($_POST); exit;

$query = "SELECT a.*, b.name AS standardName, c.name AS subjectName, d.name AS chapterName  FROM tbl_mcq a 
                LEFT JOIN tbl_standard b ON a.standardId = b.standardId
                LEFT JOIN tbl_subject c ON a.subjectId = c.subjectId
                LEFT JOIN tbl_chapter d ON a.chapterId = d.chapterId
                WHERE a.deleteStatus = 0";
        // if (!empty($search)) {
        //     $query .= " AND a.name LIKE '%".$search."%'";
        // }

$query1 = $query;
        $query .= " ORDER BY a.mcqId ASC";
                    // echo $query; exit;

if ($status == 'search-viewlongqp') {
        // print_r($_POST); exit;
        $query = "SELECT a.*, b.name AS standardName, c.name AS subjectName, d.name AS chapterName  FROM tbl_long_question a 
                LEFT JOIN tbl_standard b ON a.standardId = b.standardId
                LEFT JOIN tbl_subject c ON a.subjectId = c.subjectId
                LEFT JOIN tbl_chapter d ON a.chapterId = d.chapterId
                WHERE a.deleteStatus = 0";
        // if (!empty($search)) {
        //     $query .= " AND a.name LIKE '%".$search."%'";
        // }

$query1 = $query;
        $query .= " ORDER BY a.longQuestionId ASC";
                    // echo $query; exit;
        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count > 0) {
            $i = 0;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '<tr id="rowId'.$row['longQuestionId'].'">
                    <td>'.$i.'</td>
                    <td>'.$row['indexNo'].'</td>
                    <td>'.$row['standardName'].'</td>
                    <td>'.$row['subjectName'].'</td>
                    <td>'.$row['chapterName'].'</td>
                    <td>
                        <a href="view-long-question.php?id='.base64_encode($row['longQuestionId']).'" class="btn btn-sm btn-primary"><i class="fas fa-eye"></i></a>
                        '.$activeBtn.'
                     </td>
                </tr>';
            }
        } else {
            echo '<tr>
                <td colspan="6">
                    <center>
                        No Data Found
                    </center>
                </td>
            </tr>';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of <span id="totalEntries">'.$count1.'</span> entries';
    }

if ($status == 'get-add-chapter') {
        print_r($_POST); exit;
    }

if ($status == 'get-chapter-list-1') {
        $standardId = $_POST['standardId'];
        // print_r($_POST); exit;
?>
        <div id="chapters-container" class="card mt-3">
            <div class="card-body">
                <button type="button" class="close" aria-label="Close" onclick="closeChaptersContainer()">
                    <span aria-hidden="true">&times;</span>
                </button>
                <h4 class="card-title">Chapters</h4>
                <ul class="list-group">
                    <?php  
                        // $standardId = $row['standardId'];
                        $queryChapter = mysqli_query($con, "SELECT a.*, b.*, a.name AS chapterName FROM tbl_subject a 
                            LEFT JOIN tbl_standard b ON a.standardId = b.standardId
                            WHERE a.deleteStatus = 0 AND a.standardId = '".$standardId."' ");
                        $i = 0;
                        while($rowChapter = mysqli_fetch_array($queryChapter)){
                            $i++;
                    ?>
                        <li class="list-group-item">
                            <div class="media">
                                <div class="media-left">
                                    <div class="text-muted">Chapter <?php echo $i; ?>:</div>
                                </div>
                                <div class="media-body">
                                    <a href="#"><?php echo $rowChapter['chapterName']; ?></a>
                                </div>
                            </div>
                        </li>
                    <?php  
                        }
                    ?>
                </ul>
            </div>
        </div>
<?php
    }
    if ($status == 'get-chapter-list') {
        $standardId = $_POST['standardId'];
        $subjectId = $_POST['subjectId'];
       
        $queryChapter = mysqli_query($con, "SELECT a.*, b.name AS chaptName, b.chapterId FROM tbl_teacher a 
            LEFT JOIN tbl_chapter b ON b.subjectId = a.subjectId AND b.standardId = a.standardId
            WHERE a.deleteStatus = 0 AND a.standardId = '".$standardId."' AND a.subjectId = '".$subjectId."' ");
        $i = 0;
        while($rowChapter = mysqli_fetch_array($queryChapter)) {
            $i++;
            echo '<div class="media mb-2">
                    <div class="media-left">
                        <div class="text-muted">Chapter '.$i.':</div>
                    </div>
                    <div class="media-body">
                        <a href="chapater_details.php?id='.$rowChapter['chapterId'].' ">'.$rowChapter['chaptName'].'</a>
                    </div>
                  </div>';
        }
        exit;
    }

if ($status == 'get-chapter-list-question') {
        $standardId = $_POST['standardId'];
        $subjectId = $_POST['subjectId'];
       
        $queryChapter = mysqli_query($con, "SELECT a.*, b.name AS chaptName, b.chapterId FROM tbl_teacher a 
            LEFT JOIN tbl_chapter b ON b.subjectId = a.subjectId AND b.standardId = a.standardId
            WHERE a.deleteStatus = 0 AND a.standardId = '".$standardId."' AND a.subjectId = '".$subjectId."' ");
        $i = 0;
        while($rowChapter = mysqli_fetch_array($queryChapter)) {
            $i++;
            echo '<div class="media mb-2">
                    <div class="media-left">
                        <div class="text-muted">Chapter '.$i.':</div>
                    </div>
                    <div class="media-body">
                        <a href="question_details.php?id='.$rowChapter['chapterId'].' ">'.$rowChapter['chaptName'].'</a>
                    </div>
                  </div>';
        }
        exit;
    }
    if ($status == 'get-chapter-list-mcq-faculty') {
        $standardId = $_POST['standardId'];
        $subjectId = $_POST['subjectId'];

$queryChapter = mysqli_query($con, "SELECT a.*, b.name AS chaptName, b.chapterId FROM tbl_teacher a 
            LEFT JOIN tbl_chapter b ON b.subjectId = a.subjectId AND b.standardId = a.standardId
            WHERE a.deleteStatus = 0 AND a.standardId = '$standardId' AND a.subjectId = '$subjectId'");
        
        $i = 0;
        while ($rowChapter = mysqli_fetch_array($queryChapter)) {
            $i++;
            echo '<div class="media mb-2">
                    <div class="media-left">
                        <div class="text-muted">Chapter ' . $i . ':</div>
                    </div>
                    <div class="media-body">
                        <a href="mcq_details.php?id=' . $rowChapter['chapterId'] . '">' . $rowChapter['chaptName'] . '</a>
                    </div>
                  </div>';
        }
        exit;
    }

if ($status == 'search-teacher') {
        // print_r($_POST); exit;

$query = "SELECT a.*,b.name AS standardName,c.name AS subjectName FROM tbl_teacher a 
        LEFT JOIN tbl_standard b ON a.standardId = b.standardId
        LEFT JOIN tbl_subject c ON a.subjectId = c.subjectId
        WHERE a.deleteStatus = 0";
        if (!empty($search)) {
            $query .= " AND a.name LIKE '%".$search."%'";
        }
        $query1 = $query;
        $query .= " ORDER BY a.teacherId ASC";
                    // echo $query; exit;
        $result = mysqli_query($con, $query);
        $count = mysqli_num_rows($result); // changed $query to $result
        $count1 = mysqli_num_rows(mysqli_query($con, $query1)); // changed $query to $result
        if ($count > 0) {
            $i = 0;
            while ($row = mysqli_fetch_array($result)) { // changed $query to $result
                $i++;
                echo '<tr id="rowId'.$row['teacherId'].'">
                    <td>'.$i.'</td>
                    <td>'.$row['indexNo'].'</td>
                    <td>'.$row['name'].'</td>
                    <td>'.$row['emailId'].'</td>
                    <td>'.base64_decode($row['password']).'</td>
                    <td>'.$row['standardName'].'</td>
                    <td>'.$row['subjectName'].'</td>
                    <td>
                        <a href="teacher.php?id='.base64_encode($row['teacherId']).'" onclick="updateData('.$row['teacherId'].')" class="btn btn-sm btn-warning"><i class="fas fa-pen"></i></a>
                        <a href="javascript:void(0)" onclick="deleteDataChap('.$row['teacherId'].')" class="btn btn-sm btn-danger mlbtn-5"><i class="feather-trash-2"></i></a>
                        '.$activeBtn.'
                     </td>
                </tr>';
            }
        } else {
            echo '<tr>
                <td colspan="6">
                    <center>
                        No Data Found
                    </center>
                </td>
            </tr>';
        }
        echo '|$|';
        echo 'Showing '.$startCount.' to '.$i.' entries of <span id="totalEntries">'.$count1.'</span> entries';
    }

if ($status == 'get-chapter-list-table') {
?>      
        <div class="card-header">
            Chapter Details List
        </div>
        <div class="card-body">
            <table class="table table-bordered table-striped">
                <thead>
                    <tr>
                        <th>sr</th>
                        <th>Chapter No</th>
                        <th>Name</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                    <?php  
                        $standardId = $_POST['standardId'];
                        $subjectId = $_POST['subjectId'];
                       
                        $queryChapter = mysqli_query($con, "SELECT a.*, b.name AS chaptName, b.chapterId, b.chapterNo FROM tbl_teacher a 
                            LEFT JOIN tbl_chapter b ON b.subjectId = a.subjectId AND b.standardId = a.standardId
                            WHERE a.deleteStatus = 0 AND a.standardId = '".$standardId."' 
                            AND a.subjectId = '".$subjectId."' ");
                        $i = 0;
                        while ($rowChapter = mysqli_fetch_array($queryChapter)) {
                            $i++;
                    ?>
                    <tr>
                        <td><?php echo $i; ?></td>
                        <td> Chaptert <?php echo $rowChapter['chapterNo']; ?></td>
                        <td><?php echo $rowChapter['chaptName']; ?></td>
                        <td><a href="chapater_details.php?id=<?php echo $rowChapter['chapterId']; ?>">View</a></td>
                    </tr>
                    <?php  
                        }
                    ?>
                </tbody>
            </table>
        </div>
<?php
    }
    if ($status == 'get-chapter-list-question-table') {
?>
        <div class="card-header">
            Long Question Details List
        </div>
        <div class="card-body">
            <table class="table table-bordered table-striped">
                <thead>
                    <tr>
                        <th>sr</th>
                        <th>Chapter No</th>
                        <th>Name</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                    <?php  
                        $standardId = $_POST['standardId'];
                        $subjectId = $_POST['subjectId'];
                       
                        $queryChapter = mysqli_query($con, "SELECT a.*, b.name AS chaptName, b.chapterId, b.chapterNo FROM tbl_teacher a 
                            LEFT JOIN tbl_chapter b ON b.subjectId = a.subjectId AND b.standardId = a.standardId
                            WHERE a.deleteStatus = 0 AND a.standardId = '".$standardId."' 
                            AND a.subjectId = '".$subjectId."' ");
                        $i = 0;
                        while($rowChapter = mysqli_fetch_array($queryChapter)) {
                            $i++;
                    ?>
                    <tr>
                        <td><?php echo $i; ?></td>
                        <td> Chaptert <?php echo $rowChapter['chapterNo']; ?></td>
                        <td><?php echo $rowChapter['chaptName']; ?></td>
                        <td><a href="question_details.php?id=<?php echo $rowChapter['chapterId']; ?>">View</a></td>
                    </tr>
                    <?php  
                        }
                    ?>
                </tbody>
            </table>
        </div>
<?php
    }
    if ($status == 'get-chapter-list-mcq-faculty-table') {
?>
        <div class="card-header">
            MCQ Details List
        </div>
        <div class="card-body">
            <table class="table table-bordered table-striped">
                <thead>
                    <tr>
                        <th>sr</th>
                        <th>Chapter No</th>
                        <th>Name</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                    <?php  
                        $standardId = $_POST['standardId'];
                        $subjectId = $_POST['subjectId'];

$queryChapter = mysqli_query($con, "SELECT a.*, b.name AS chaptName, b.chapterId, b.chapterNo FROM tbl_teacher a 
                            LEFT JOIN tbl_chapter b ON b.subjectId = a.subjectId AND b.standardId = a.standardId
                            WHERE a.deleteStatus = 0 AND a.standardId = '$standardId' AND a.subjectId = '$subjectId'");
                        
                        $i = 0;
                        while ($rowChapter = mysqli_fetch_array($queryChapter)) {
                            $i++;
                    ?>
                    <tr>
                        <td><?php echo $i; ?></td>
                        <td> Chaptert <?php echo $rowChapter['chapterNo']; ?></td>
                        <td><?php echo $rowChapter['chaptName']; ?></td>
                        <td><a href="mcq_details.php?id=<?php echo $rowChapter['chapterId']; ?>">View</a></td>
                    </tr>
                    <?php  
                        }
                    ?>
                </tbody>
            </table>
        </div>
<?php
        
    }
?>

docroot: /home/u856302147/domains/creativegardendesign.in/public_html

curdir: /home/u856302147/domains/vparking.live/.trash/Config

	.	4096
	..	4096
X	Milestone Details	2225
X	ajax-edit.php	2440
X	ajax-get.php	32240
X	ajax-remove.php	499
X	checkURL.php	553
X	database.php	41064
X	demo.php	1164