<?php 
include('header.php');
include('left_sidebar.php');
?>
  <style>
 [type="checkbox"]:not(:checked), [type="checkbox"]:checked {
    position: inherit !important;
    left: 0px !important; 
    opacity:1 !important;
}
 </style>       
        <!-- ============================================================== -->
        <!-- Page wrapper  -->
        <!-- ============================================================== -->
        <div class="page-wrapper">
            <!-- ============================================================== -->
            <!-- Container fluid  -->
            <!-- ============================================================== -->
            <div class="container-fluid">
                <!-- ============================================================== -->
                <!-- Bread crumb and right sidebar toggle -->
                <!-- ============================================================== -->
                <div class="row page-titles">
                    <div class="col-md-5 col-8 align-self-center">
                        <h3 class="text-themecolor">All Products Gallery</h3>
                        
                    </div>
                    <div class="col-md-7 col-4 align-self-center">
                        <div class="d-flex m-t-10 justify-content-end">
                           <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
                            <li class="breadcrumb-item active">All Products Gallery</li>
                        </ol>
                            <div class="">
                                <button class="right-side-toggle waves-effect waves-light btn-success btn btn-circle btn-sm pull-right m-l-10"><i class="ti-settings text-white"></i></button>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- ============================================================== -->
                <!-- End Bread crumb and right sidebar toggle -->
                <!-- ============================================================== -->
                <!-- ============================================================== -->
                <!-- Start Page Content -->
                <!-- ============================================================== -->
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title">All Products Gallery</h4>
                                <div class="table-responsive m-t-10">
                                    <table id="example23" class="display nowrap table table-hover table-striped table-bordered" cellspacing="0" width="100%">
                                    <thead style="background: darkgray;color: white;">
                                            <tr>
                                                <th>S.No.</th>
                                                <th>Title</th>
                                                <th>Image</th>
												<th>Edit</th>
                                                <th>Delete</th>                                                
                                            </tr>
                                        </thead>
                                       
                                        <tbody>
                                        <?php
						  $query = mysqli_query($con,"SELECT * FROM tp_gallery order by id desc");
						  $cn=1;
						  while($CatRow = mysqli_fetch_array($query)){
						  
						  ?>
                                            <tr <?php if($CatRow["status"]=='0'){ ?> class="table-danger" <?php } ?>>
                                                <td><?php echo $cn++;?></td>
                                                <td><?=$CatRow["album"];?></td>
                                                 <td>
                                                 <?php
                          $query2 = mysqli_query($con,"SELECT * FROM tp_gallery_image where pro_id='".$CatRow["id"]."'");
                          while($CatRow2 = mysqli_fetch_array($query2)){
                          ?>

                                               <a href="delete_image.php?id=<?=$CatRow2["id"];?>" class="" onclick="return confirm('Are you Sure?');"><img src="../<?=$CatRow2["image"];?>" height="50"></a>
                                        <?php  } ?>
                                        </td>
                                               <!--  <td><img src="../file_upload/gallery/<?=$CatRow["image"];?>" height="50"></td> -->
                                                <td><a href="add_gallery.php?objID=<?=$CatRow["id"];?>&mode=edit" class="btn btn-primary btn-circle"><i class="ti-settings"></i> </a></td>
                                                <td><a href="delete_gallery.php?id=<?=$CatRow["id"];?>" class="btn btn-danger btn-circle info-tooltip" onclick="return confirm('Are you Sure?');"><i class="ti-trash"></i> </a></td>
                                            </tr>
                                            <?php } ?>
                                            
                                        </tbody>
                                    </table>
									
                                </div>
                            </div>
                        </div>
                        
                        
                    </div>
                </div>
                 <!-- Row -->
                     
               
                
                    
                <!-- ============================================================== -->
                <!-- End PAge Content -->
                <!-- ============================================================== -->
               <?php include('footer.php');?>