  <?php 
     require('top.php');
if (isset($_GET['type']) && $_GET['type']!='') {
   $type=mysqli_real_escape_string($con,$_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 product set status='$status' where id='$id'";
    mysqli_query($con,$update_status_sql);
   }

   if($type=='delete'){
                     $id=mysqli_real_escape_string($con,$_GET['id']);
                     $delete_sql="delete from product where id='$id'";
                     mysqli_query($con,$delete_sql);

   }
}

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

   <div class="content pb-0">
<div class="animated fadeIn">
 
  <div class="clearfix"></div>
                <!-- Orders -->
                <div class="orders">
                    <div class="row">
                        <div class="col-xl-12">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="box-title">Product </h4>
                                    <h4 class="box-link"><a href="manage_products.php">Add Product</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>Name</th>
                                                    <th>Image</th>
                                                    <th></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 echo $row['name']  ?></td>
                                                    <td><img src="../admin/images/<?php echo $row['image']  ?>"/></td>
                                                    </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_products.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> <!-- /.table-stats -->
                                </div>
                            </div> <!-- /.card --> 
                        </div> <!-- /.col-lg-12 -->
                    </div></div>
 <?php 
     require('footer.php');
     
  ?>
                     