1#@!#!123s

: / home / realadss / jaipurpartyplanner.in / admin /
Filename : faq.php
back
<?php include('include/header.php');

?>


  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
      <div class="container-full">
        <!-- Content Header (Page header) -->     
        <div class="content-header">
            <div class="d-flex align-items-center">
                <div class="me-auto">
                    <h4 class="page-title">Add FAQ</h4>
                    
                    <!--<div class="d-inline-block align-items-center">-->
                    <!--    <nav>-->
                    <!--        <ol class="breadcrumb">-->
                    <!--            <li class="breadcrumb-item"><a href="#"><i class="mdi mdi-home-outline"></i></a></li>-->
                    <!--            <li class="breadcrumb-item" aria-current="page">Pages</li>-->
                    <!--            <li class="breadcrumb-item active" aria-current="page">Add Category</li>-->
                    <!--        </ol>-->
                    <!--    </nav>-->
                    <!--</div>-->
                </div>
                
            </div>
        </div>


<?php  
        $per_page_record = 10;  // Number of entries to show in a page.   
        // Look for a GET variable page if not found default is 1.        
        if (isset($_GET["page"])) {    
            $page  = $_GET["page"];    
        }    
        else {    
          $page=1;    
        }    
    
        $start_from = ($page-1) * $per_page_record;     
    
        $query = "SELECT * FROM faq LIMIT $start_from, $per_page_record";     
        $catData = mysqli_query ($conn, $query);    
    ?>  

        <!-- Main content -->
        <section class="content">
        <div class="box">
                <div class="box-header with-border d-flex justify-content-between" >
                  <h4 class="box-title" style="margin-left: 20px;margin-top: 10px;">FAQ List</h4>
                  <button type="button" class="waves-effect waves-light btn btn-rounded btn-success mb-5 ed-btn text-right"><a href="faq-form.php">Add New FAQ</a></button>
                </div>
                <!-- /.box-header -->
                <div class="box-body">
                  
                <!--table start-->
          
            <div class="box">
                <div class="box-body no-padding">
                    <div class="table-responsive">
                        <input type="hidden" id="deleteId">
                      <table class="table table-hover">
                        <tbody id="showdata">
                            
                         <tr>
                          <th>Id</th>
                          <th>Question </th>
                          <th>Answer</th>
                          <th>Date</th>
                          <th colspan="2" class="text-center">Action</th>
                        </tr>
                        <?php 
                        while ($row=mysqli_fetch_array($catData)) { ?> 
                        
                        <tr >
                          <td><?php echo $row['id']; ?></td>
                          <td><?php echo $row['question']; ?></td> 
                          <td><?php echo $row['answer']; ?></td> 
                          <td><span class="text-muted"><i class="fa fa-clock-o"></i> <?php echo $row['createdate']; ?></span> </td> 
                          <td><button type="button" class="waves-effect waves-light btn btn-rounded btn-success mb-5 ed-btn"><?php echo "<a href='faq-edit.php?eid=".$row['id']."'>Edit</a>";?></button></td>
                          <td><button type="button" class="waves-effect waves-light btn btn-rounded btn-danger mb-5 ed-btn"><a onclick="openDeleteModal(<?php echo $row['id']; ?>)" href="javascript:void(0);" data-bs-toggle="modal" data-bs-target="#delete-item">Delete</a></button></td>
                        </tr>
                        <?php }?>
                      </tbody></table>
                    </div>
                </div>
              </div>
            </div>
                
    <div class="pagination">    
      <?php  
        $query = "SELECT COUNT(*) FROM faq";     
        $catData = mysqli_query($conn, $query);     
        $row = mysqli_fetch_row($catData);     
        $total_records = $row[0];     
          
    echo "</br>";     
        // Number of pages required.   
        $total_pages = ceil($total_records / $per_page_record);     
        $pagLink = "";       
      
        if($page>=2){   
            echo "<a href='faq?page=".($page-1)."'>  Prev </a>";   
        }       
                   
        for ($i=1; $i<=$total_pages; $i++) {   
          if ($i == $page) {   
              $pagLink .= "<a class = 'active' href='faq?page="  
                                                .$i."'>".$i." </a>";   
          }               
          else  {   
              $pagLink .= "<a href='faq?page=".$i."'>   
                                                ".$i." </a>";     
          }   
        };     
        echo $pagLink;   
  
        if($page<$total_pages){   
            echo "<a href='faq?page=".($page+1)."'>  Next </a>";   
        }   
  
      ?>    
      </div>  
              </div>
        </section>
        <!-- /.content -->
      
        <!-- Delete -->
        <div class="modal fade" id="delete-item" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
            <div class="modal-dialog modal-dialog-centered ">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title" id="exampleModalLabel">Delete Faq</h5>
                        <button type="button" class="btn-close close-modal" data-bs-dismiss="modal" aria-label="Close">
                            <i class="fe fe-x"></i>
                        </button>
                    </div>
                    <div>
                        <div class="modal-body py-0">
                            <div class="del-modal">
                                <p>Are you sure want to Delete?</p>
                            </div>
                        </div>
                        <div class="modal-footer pt-0">
                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                            <button type="submit" onclick="confirmDelete()" class="btn btn-primary">Yes</button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!-- /Delete -->
        <script>
            function openDeleteModal(id) {
                document.getElementById('deleteId').value = id;
            }
      
            function confirmDelete() {
                // Get the stored ID
                var id = document.getElementById('deleteId').value;
                window.location.href = 'faqdelete.php?did=' + id;
            }
        </script>
      
    
      
      </div>
  </div>
  <!-- /.content-wrapper -->
  
  


<?php include('include/footer.php') ?>