1#@!#!123s

: / home / ipuco / www / superadmin /
Filename : list-of-faq.php
back
<?php
ob_start();
session_start();
include('include/connection.php');


$emailid = $_SESSION['emailid'];

$adminid = $_SESSION['id'];

$per = mysqli_query($conn, "select * from admin where id='" . $adminid . "'");
$perq1 = mysqli_fetch_array($per);

if (!(isset($_SESSION['emailid']) && $_SESSION['emailid'] != '')) {

   header("Location: index.php");
}


if (isset($_POST['submit'])) {

   date_default_timezone_set('Asia/Kolkata');


   function string_limit_words($string, $word_limit)
   {
      $words = explode(' ', $string);
      return implode(' ', array_slice($words, 0, $word_limit));
   }

   $faq_heading = addslashes($_POST['faq_heading']);

   $faq_short_desc = addslashes($_POST['faq_short_desc']);


   if (mysqli_query($conn, "insert into tbl_faq values(NULL,'$faq_heading','$faq_short_desc')")) {
?>
      <script type="text/javascript">
         //alert("Data Inserted Successfully");
         window.location = "list-of-faq.php";
      </script>
   <?php
   } else {
   ?>
      <script type="text/javascript">
         alert("Error! Data Not Inserted");
         //window.location="list-of-faq.php";
      </script>
   <?php echo mysql_error();
   }
}



if (isset($_GET['referesh'])) {

   $status1 = $_REQUEST['status1'];

   mysqli_query($conn, "DELETE FROM tbl_faq where faq_id='$status1'") or die(mysql_error());
   header("Location: list-of-faq.php");
}


if (isset($_POST['update'])) {

   date_default_timezone_set('Asia/Kolkata');


   function string_limit_words($string, $word_limit)
   {
      $words = explode(' ', $string);
      return implode(' ', array_slice($words, 0, $word_limit));
   }

   $faq_heading = addslashes($_POST['faq_heading']);


   $faq_short_desc = addslashes($_POST['faq_short_desc']);

   $faq_id = $_POST['faq_id'];

   //echo "update tbl_faq set state_id = '$url123',faq_heading = '$faq_heading',committee_img = '$new_file_name12',url = '$url',faq_short_desc = '$faq_short_desc' where faq_id='$faq_id'";

   //die();

   if (mysqli_query($conn, "update tbl_faq set faq_heading = '$faq_heading',faq_short_desc = '$faq_short_desc' where faq_id='$faq_id'")) {
   ?><script type="text/javascript">
         //alert("Data Inserted Successfully");
         window.location = 'list-of-faq.php';
      </script><?php
            } else {   ?><script type="text/javascript">
         alert("Error! Data Not Updated");
         window.location = 'list-of-faq.php';
      </script><?php echo mysql_error();
            }
         }
               ?>
<!DOCTYPE html>
<html lang="en">

<head>
   <meta charset="utf-8">
   <meta http-equiv="X-UA-Compatible" content="IE=edge">
   <meta name="viewport" content="width=device-width,initial-scale=1,user-scalable=0,minimal-ui">
   <title>Add FAQ</title>
   <meta content="Admin Dashboard" name="description">
   <meta content="Themesbrand" name="author">
   <link rel="shortcut icon" href="assets/images/favicon.ico">
   <link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css">
	<link href="assets/css/metismenu.min.css" rel="stylesheet" type="text/css">
	<link href="assets/css/icons.css" rel="stylesheet" type="text/css">
	<link href="assets/css/style.css" rel="stylesheet" type="text/css">
   <script src="https://cdn.ckeditor.com/4.14.0/standard/ckeditor.js"></script>
   <link rel="stylesheet" href="https://cdn.datatables.net/1.10.23/css/dataTables.bootstrap.min.css">
   <style>
      .dataTables_length,
      .dataTables_paginate,
      .dataTables_info {
         display: block !important;
      }

      .blink_me {
         animation: blinker 1s linear infinite;
      }

      @keyframes blinker {
         50% {
            opacity: 0;
         }
      }
   </style>
</head>

<body>
   <!-- Begin page -->
   <div id="wrapper">
      <!-- Top Bar Start -->
      <?php include('include/top-header.php'); ?>
      <!-- Top Bar End -->
      <!-- ========== Left Sidebar Start ========== -->
      <div class="left side-menu">
         <?php include('include/left-menu.php'); ?>
         <!-- Sidebar -left -->
      </div>
      <!-- Left Sidebar End -->
      <!-- ============================================================== -->
      <!-- Start right Content here -->
      <!-- ============================================================== -->
      <div class="content-page">
         <!-- Start content -->
         <div class="content">
            <div class="container-fluid">
               <div class="page-title-box">
                  <div class="row align-items-center">
                     <div class="col-sm-10">
                        <h4 class="page-title">FAQ Management</h4>
                        <ol class="breadcrumb">
                           <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
                           <li class="breadcrumb-item active">FAQ Name</li>
                        </ol>
                     </div>
                     <div class="col-sm-2">
                        <a href="" class="btn btn-primary dropdown-toggle arrow-none waves-effect waves-light" data-toggle="modal" data-target=".bs-example-modal-center"> <i class="mdi mdi-settings mr-2"> </i>Add FAQ</a>
                        <!--add logo form-->
                        <div class="modal fade bs-example-modal-center" tabindex="-1" role="dialog" aria-labelledby="mySmallModalLabel" aria-hidden="true">
                           <div class="modal-dialog modal-dialog-centered">
                              <div class="modal-content">
                                 <div class="modal-header">
                                    <h5 class="modal-title mt-0">Add FAQ</h5>
                                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                                 </div>
                                 <div class="modal-body">
                                    <form action="" method="post" enctype="multipart/form-data" class="form-horizontal">

                                       <div class="form-group"><label>Add FAQ Heading</label>
                                          <input type="text" class="form-control" name="faq_heading">
                                       </div>

                                       <div class="form-group"><label>Short Description</label>
                                          <textarea name="faq_short_desc" id="editor1" class="form-control" placeholder="Short Description"></textarea>
                                       </div>
                                       <div class="form-group"><label></label>
                                          <button type="submit" class="btn btn-success waves-effect waves-light" name="submit">Submit</button>
                                       </div>
                                    </form>
                                 </div>
                              </div>
                              <!-- /.modal-content -->
                           </div>
                           <!-- /.modal-dialog -->
                        </div>
                        <!--add logo form-->
                     </div>
                  </div>
               </div>
               <!-- end row -->
               <div class="row">
                  <div class="col-12">
                     <div class="card">
                        <div class="panel-body">
                           <h4 class="mt-0 header-title"><i class="ti-agenda text-primary mr-2"></i>Logo </h4>
                           <p class="text-muted m-b-30"></p>
                           <p class="text-muted m-b-30"></p>
                           <div class="table-responsive">
                              <table id="example" class="table table-bordered mb-0">
                                 <thead>
                                    <tr>
                                       <th>#</th>
                                       <th>Heading</th>
                                       <th>Short Description</th>
                                       <th>Action</th>
                                    </tr>
                                 </thead>
                                 <tbody>
                                    <?php
                                    $i = 1;
                                    $select = mysqli_query($conn, "SELECT * FROM tbl_faq order by faq_id DESC");
                                    while ($result = mysqli_fetch_array($select)) {
                                    ?>
                                       <tr>
                                          <td scope="row"><?php echo $i; ?></td>
                                          <td><?php echo $result['faq_heading']; ?></td>

                                          <td><?php echo substr($result['faq_short_desc'], 0, 200); ?>... </td>

                                          <td>

                                             <a href="#edit<?php echo $result['faq_id']; ?>" data-toggle="modal"><i class="far fa-edit"></i></a>
                                             <!--Update Code-->
                                             <div class="modal fade" id="edit<?php echo $result['faq_id']; ?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
                                                <div class="modal-dialog">
                                                   <div class="modal-content">
                                                      <div class="modal-header">
                                                         <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                                                      </div>
                                                      <div class="modal-body">
                                                         <?php
                                                         $fetch = mysqli_query($conn, "select * from tbl_faq where faq_id='" . $result['faq_id'] . "'");
                                                         $fetch1 = mysqli_fetch_array($fetch);
                                                         ?>
                                                         <div class="container-fluid">
                                                            <form method="POST" action="" enctype="multipart/form-data">
                                                               <input type="hidden" name="faq_id" value="<?php echo $result['faq_id']; ?>" />
                                                               
                                                               <div class="form-group">
                                                                  <label>Edit FAQ Heading</label>
                                                                  <input type="text" class="form-control" name="faq_heading" value="<?php echo $fetch1['faq_heading']; ?>" />
                                                               </div>

                                                               <div class="form-group"><label>Short Description</label>
                                                                  <textarea name="faq_short_desc" id="editor12" class="form-control"><?php echo $fetch1['faq_short_desc']; ?></textarea>
                                                               </div>
                                                         </div>
                                                      </div>
                                                      <div class="modal-footer">
                                                         <div class="form-group">
                                                            <label></label>
                                                            <button type="submit" class="btn btn-success waves-effect waves-light" name="update">Update</button>
                                                         </div>
                                                      </div>
                                                      </form>
                                                   </div>
                                                </div>
                                             </div>
                                             <!--Update Code-->
                                             &nbsp;&nbsp;&nbsp;
                                             <a href="list-of-faq.php?referesh=delete&&status1=<?php echo $fetch1['faq_id']; ?>" onclick="return confirm('Are you sure you want to delete this Listing ?');">
                                                <i class="far fa-trash-alt"></i>
                                             </a>
                                          </td>
                                       </tr>
                                    <?php
                                       $i++;
                                    }
                                    ?>
                                 </tbody>
                              </table>
                           </div>
                        </div>
                     </div>
                  </div>
                  <!-- end col -->
               </div>
               <!-- end row -->
            </div>
            <!-- container-fluid -->
         </div>
         <!-- content -->
         <?php include_once('include/admin-footer.php'); ?>
      </div>
      <!-- ============================================================== -->
      <!-- End Right content here -->
      <!-- ============================================================== -->
   </div>
   <!-- END wrapper -->
   <!-- jQuery  -->
   <script src="assets/js/jquery.min.js"></script>
   <script src="assets/js/bootstrap.bundle.min.js"></script>
   <script src="assets/js/metisMenu.min.js"></script>
   <script src="assets/js/jquery.slimscroll.js"></script>
   <script src="assets/js/waves.min.js"></script>
   <!-- App js -->
   <script src="assets/js/app.js"></script>
   <script>
      CKEDITOR.replace('editor1');
   </script>
   <script>
      CKEDITOR.replace('editor12');
   </script>
   <script src="https://cdn.datatables.net/1.10.23/js/jquery.dataTables.min.js"></script>
   <script src="https://cdn.datatables.net/1.10.23/js/dataTables.bootstrap.min.js"></script>
   <script>
      $(document).ready(function() {
         $('#example').DataTable();
      });
   </script>
</body>

</html>