  <?php 
     require('top.php');
     $type='';
if (isset($_GET['type']) && $_GET['type']!='') {
   $type=($_GET['type']);
   if($type=='status'){
    $operation=mysqli_real_escape_string($con,$_GET['operation']);
    $id=mysqli_real_escape_string($con,$_GET['id']);
    if($operation=='active'){
        $status='1';
    }else{
        $status='0';
    }
    $update_status_sql="update categories set status='$status' where id='$id'";
    mysqli_query($con,$update_status_sql);
   }
   if($type=='delete'){
                     $id=$_GET['id'];
                     $delete_sql="delete from categories where categories.id='$id'";
                     mysqli_query($con,$delete_sql);
 }
}

$sql="select * from categories order by id asc";
$res=mysqli_query($con,$sql);
  ?>

   <div class="content pb-0">
<div class="animated fadeIn">

                <!-- Orders -->
                <div class="orders">
                    <div class="row">
                        <div class="col-xl-12">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="box-title">Categories </h4>
                                    <h4 class="box-link"><a href="manage_categories.php">Add Categories</a> </h4>
                                </div>
                                <div class="card-body--">
                                    <div class="table-stats order-table ov-h">
                                        <table class="table ">
                                            <thead>
                                                <tr>
                                                    <th class="serial">#</th>
                                                    <th>ID</th>
                                                    <th>Categories</th>
                                                    <th>Status</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                               <?php
                                                $i=1;
                                                while ($row=mysqli_fetch_assoc($res)){    
                                               ?>
                                                <tr>
                                                    <td class="serial"><?php echo $i ?></td>
                                                    <td><?php echo $row['id']  ?></td>
                                                    <td><?php echo $row['categories']  ?></td>
                                                    <td><?php 
                                                    if ( $row['status']==1) {
                                                        echo "<span class='badge badge-complete'> <a href='?type=status&operation=deactive&id=".$row['id']."'> Active </a></span> &nbsp;";
                                                        
                                                     } 
                                                     else {
                                                         echo "<span class='badge badge-pending'><a href='?type=status&operation=active&id=".$row['id']."'> Deactive </a></span>&nbsp;";
                                                     }
                                                      echo "<span class='badge badge-edit'><a href='manage_categories.php'&id=".$row['id']."'> Edit </a></span>&nbsp;";
                                                       echo "<span class='badge badge-delete'><a href='?type=delete&id=".$row['id']."'> Delete</a></span>&nbsp;"; 
                                                      ?></td>
                                                </tr>
                                               <?php }  ?>
                                            </tbody>
                                        </table>
                                    </div> 
                                </div>
                            </div>
                        </div> </div>
                      </div>
 <?php 
     require('footer.php');
     
  ?>
                     