1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / public_html / admin /
Filename : category.php
back
<?php 
require 'function.php';
check_login();
require '../config/database.php';

// Cagegory Select Query
$sql_select = "SELECT * FROM category";
$run_query_select = mysqli_query($conn, $sql_select);

mainheader('Category', '3b');
?>

      <!--main content start-->
      <section id="main-content">
          <section class="wrapper" style="min-height: 850px;">

             <!--breadcrumbs start -->
            <div class="row">
                  <div class="col-lg-12 pb-1">
                      <!--breadcrumbs start -->
                      <nav aria-label="breadcrumb">
                          <ol class="breadcrumb">
                              <li class="breadcrumb-item"><a href="start.php"><i class="fa fa-home"></i> Dashboard </a></li>
                              <li class="breadcrumb-item active" aria-current="page">Add Category</li>
                          </ol>
                      </nav>
                  </div>
              </div>
             <!--breadcrumbs end -->

             <div class="row">
                  <div class="col-md-5">
                      <section class="card p-4">
                        <div class="card-header mb-3">
                          <h4 style="display: inline;">New Category</h4>
                        
                        </div>

                        <?php
                            if (isset($_SESSION['add_category_msg'])) : ?>
                              <div class="alert alert-warning alert-dismissible fade show" role="alert">
                                <strong>Hey!</strong> <?= $_SESSION['add_category_msg']; ?>
                                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                  <span aria-hidden="true">&times;</span>
                                </button>
                              </div>
                          <?php unset($_SESSION['add_category_msg']); endif; ?>
                        
                              <form action="code.php" method="POST">
                                
                                <div class="form-group">

                                      <div class="col-md-12">
                                          <input type="text" name="category" class="form-control" placeholder="Type Category Name" required />
                                      </div>
                                  </div>

                                  <input type="hidden" name="status" value="1">
                                  <div class="form-group">
                                      <div class="col-md-9">
                                         <input type="submit" name="add_category" class="btn btn-primary"> 
                                      </div>
                                  </div>

                              </form>
                      </section>

                  </div>


                  <div class="col-md-7">
                      <section class="card p-3">
                          <header class="card-header mb-4">
                            <h4>
                              All Category
                            </h4>  
                          </header>

                          <?php
                            if (isset($_SESSION['edit_feature_msg'])) : ?>
                              <div class="alert alert-warning alert-dismissible fade show" role="alert">
                                <strong>Hey! </strong> <?= $_SESSION['edit_feature_msg']; ?>
                                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                  <span aria-hidden="true">&times;</span>
                                </button>
                              </div>
                          <?php unset($_SESSION['edit_feature_msg']); endif; ?>

                          <table class="table table-striped table-hover">
                              <thead class="table-dark">
                              <tr>
                                  <th>No</th>
                                  <th>Name</th>
                                  <th>Post</th>
                                  <th>Status</th>
                                  <th>Action</th>
                              </tr>
                              </thead>
                              <tbody>
                                <?php
                                  $serial = 1;
                                  while ($row = mysqli_fetch_assoc($run_query_select)) { ?>
                              <tr>
                                  <td><?= $serial; ?></a></td>
                                  <td><?= $row['name'];  ?></td>
                                  <td><?= $row['post']; ?></td>
                                  <td>
                                    <?php if($row['status']==1){ ?>
                                      <span class="badge badge-success label-mini">active</span>
                                    <?php  }else{ ?>
                                      <span class="badge badge-danger label-mini">Inactive</span>
                                    <?php } ?>
                                    
                                  </td>
                                  <td>
                                      
                                      <a href="add_category.php?id=<?= $row['cat_id']; ?>" class="btn btn-primary btn-sm"><i class="fa fa-pencil"></i></a>
                                      <a href="delete.php?category_delete=<?= $row['cat_id']; ?>" class="btn btn-danger btn-sm"><i class="fa fa-trash-o text-white "></i></a>
                                  </td>
                              </tr>
                              <?php $serial++; } ?>
                              </tbody>
                          </table>
                      </section>
                  </div>
              </div>

          </section>
      </section>
      <!--main content end-->

<?php footer(); ?>