1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / jeffautomobileinc.com / dealer /
Filename : categories.php
back
<?php
session_start();
error_reporting(0);
include('../../config/jaconfig.php');
include('include/checklogin.php');
check_login();
$title="Categories";


if(isset($_GET['del']))
		  {
		          mysqli_query($con,"delete from categories where cat_id = '".$_GET['id']."'");
                  $_SESSION['msg']="Category  Deleted !!";
		  }
?>

<?php include('include/header.php');?>
		
<?php include('include/sidebar.php');?>

               
                <div class="container-fluid py-4">

                  <div class="card" style="padding:30px;">
                  <div class=" pb-0">
                     <h6><a href="add-category.php" class="btn btn-o btn-primary">
                       Add Category</a>
                        </h6>
                   </div>
                <h5 class="card-header">Categories</h5>
                
                <div class="table-responsive table-wrapper-top text-nowrap" >
                <p style="padding-left:10vw;color:#cb0c9f;"><?php if($msg) { echo htmlentities($msg);}?> </h5>
                    
                <table class="table table-bordered" id="dataTables-example" >

                  <thead>
                    <tr>
                      <th class="">ID</th>
                      <th class=" ps-2">Name</th>
                      <th class="text-center ">Created On</th>
                      <th class="text-center ">Last Updated</th>
                      <th class="text-secondary opacity-7"></th>
                    </tr>
                  </thead>
                  <tbody>
                  <?php $query=mysqli_query($con,"select * from categories");
                      $cnt=+1;
                      while($row=mysqli_fetch_array($query))
                      {
                      ?>
                    <tr>
                      <td>
                        <div class="d-flex px-2 py-1">
                         
                          <div class="d-flex flex-column justify-content-center">
                            <h6 class="mb-0 text-sm"><?php echo htmlentities($cnt);?></h6>
                          </div>
                        </div>
                      </td>
                      <td>
                        <p class="text-xs font-weight-bold mb-0"><?php echo htmlentities($row['cat_title']);?></p>
                      </td>
                      <td class="align-middle text-center ">
                        <span class="mb-0 text-sm"><?php echo htmlentities($row['creationDate']);?></span>
                      </td>
                      <td class="align-middle text-center">
                        <span class="text-secondary text-xs font-weight-bold"><?php echo htmlentities($row['updationDate']);?></span>
                      </td>
                      <td class="align-middle">
        
                        <a href="edit-category.php?id=<?php echo $row['cat_id'];?>" class="badge badge-sm bg-gradient-secondary" data-toggle="tooltip" data-original-title="Edit Category">
                          Edit
                        </a>
                        <a href="categories.php?id=<?php echo $row['cat_id'];?>&del=delete" 
                        onClick="return confirm('Are you sure you want to delete?')" class="badge badge-sm bg-gradient-danger">
                      Delete</a>
                      </td>
                    </tr>
                    <?php }?>
                   
                   
                  
                  </tbody>
                </table>
              </div>
            </div>
          </div>
        </div>
      </div>




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