Server : LiteSpeed System : Linux in-mum-web1112.main-hosting.eu 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 x86_64 User : u451330669 ( 451330669) PHP Version : 8.2.27 Disable Function : NONE Directory :  /home/u451330669/domains/heertourstravels.in/public_html/admin/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
require('top.inc.php');

if(isset($_GET['type']) && $_GET['type']!=''){
  $type=get_safe_value($con,$_GET['type']);
  if($type=='status'){
    $operation=get_safe_value($con,$_GET['operation']);
    $id=get_safe_value($con,$_GET['id']);
    if($operation=='active'){
      $status='1';
    }else{
      $status='0';
    }
    $update_status_sql="update banner set status='$status' where id='$id'";
    mysqli_query($con,$update_status_sql);
  }
  
  if($type=='delete'){
    $id=get_safe_value($con,$_GET['id']);
    $delete_sql="delete from banner where id='$id'";
    mysqli_query($con,$delete_sql);
  }
}

$sql="select * from banner order by banner asc";
$res=mysqli_query($con,$sql);
?>
  <div class="main-panel">
        <div class="content-wrapper">
          <div class="card">
            <div class="card-body">
              <h4 class="card-title">Data table</h4>
                <h4 class="box-link"><a href="manage_banner.php">Add banner</a> </h4>
              <div class="row">
                <div class="col-12">
                  <div class="table-responsive">
                    <table id="order-listing" class="table">
                      <thead>
                        <tr>
                            <th>No #</th>
                         
                            <th>Name</th>
                        
                             <th>Image</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['banner']?></td>
                           <td><img style="width: 100px;" src="<?php echo PRODUCT_IMAGE_SITE_PATH.$row['image']?>"/></td> 
                           
                            
                            <td><?php
                if($row['status']==1){
                  echo "<button class='btn btn-outline-primary'><a href='?type=status&operation=deactive&id=".$row['id']."'>Active</a></span>&nbsp;";
                }else{
                  echo "<button class='btn btn-outline-primary'><a href='?type=status&operation=active&id=".$row['id']."'>Deactive</a></span>&nbsp;";
                }
                echo "<button class='btn btn-outline-primary'><a href='manage_banner.php?id=".$row['id']."'>Edit</a></span>&nbsp;";
                
                echo "<a href='?type=delete&id=".$row['id']."'><button class='btn btn-outline-primary'>Delete</a></span>";
                
                ?>
                              
                            </td>
                        </tr><?php } ?>
                      
                      </tbody>
                    </table>
                  </div>
        </div>
              </div>
            </div>
          </div>
        
    </div>
        <!-- content-wrapper ends -->
      <?php
require('footer.inc.php');
?>