Server : ApacheSystem : 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_93b53270/admin/manage_product/ |
Upload File : |
<?php
include("../function.php");
if($_SESSION['admin_id']==""){
header('location:../login.php');
}
$login_tbl=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM admin WHERE admin_id='".$_SESSION['admin_id']."'"));
include('../include/sidebar.php');
?>
<?php
if(!empty($_GET['copyid'])){
$id=$_GET['copyid'];
$product=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM product_tbl WHERE id=".$_GET['copyid']));
$service_id=$product['service_id'];
$cat_id=$product['cat_id'];
$brand_id=$product['brand_id'];
// $model_id=$product['model_id'];
$model_year_id=$product['model_year_id'];
$title=$product['title'];
$title=str_replace("'", "\'", $title);
$short_description=$product['short_description'];
$short_description=str_replace("'", "\'", $short_description);
$about=$product['about'];
$about=str_replace("'", "\'", $about);
$price=$product['price'];
$InstQry=mysqli_query($conn,"INSERT `product_tbl` SET
`service_id`='$service_id',
`cat_id`='$cat_id',
`brand_id`='$brand_id',
-- `model_id`='$model_id',
`model_year_id`='$model_year_id',
`title`='$title',
`short_description`='$short_description',
`about`='$about',
`price`='$price',
`status`='0'")or die(mysqli_error($conn));
$ido=mysqli_insert_id($conn);
$slug1=$slug.$ido;
$d=sprintf("%04d",$ido);
$product_id="Product".$d;
mysqli_query($conn,"UPDATE `product_tbl` SET `slug`='$slug1', `product_id`='$product_id' WHERE id='$ido'");
if($InstQry){
echo '<script>alert("Record Inserted Successfully");</script>';
echo "<script>window.location='show.php?page=pro';</script>";
}
}
?>
<!-- [ 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 text-light fw-bold btn-sm btn-round has-ripple"><i class="feather icon-check-square"></i> Manage Product List </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 Product List</h5>
<div>
<a href="add.php?page=pro" class="text-white btn btn-info btn-sm btn-round has-ripple">
<i class="feather icon-plus"></i>Add</a>
<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 records?');">
<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'>
</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'].' <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'].' <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'].' <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>Product Details</th>
<th>Images</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$Query=mysqli_query($conn,"SELECT * FROM product_tbl WHERE cat_id!=0 AND `our_type`=0 ORDER BY id DESC");
$n=1;
while($row=mysqli_fetch_array($Query)){
$product_id=$row['id'];
$brand_id=$row['brand_id'];
$cat_id=$row['cat_id'];
// $model_id=$row['model_id'];
$model_year_id=$row['model_year_id'];
$cat_id=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM product_product_sevice_tbl WHERE id=$cat_id"));
// $model_fet=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM model_tbl WHERE id='$model_id'"));
// $brand=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM brand_tbl WHERE id=$brand_id"));
// $model_year_fet=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM model_date_tbl WHERE id=$model_year_id"));
?>
<tr>
<td><input type='checkbox' name='delete[]' value='<?=$row['id'];?>'></td>
<td><?=$n; $n++;?></td>
<td>
Name: <b><?=$row['title']?></b><br>
Category: <b><?=$cat_id['title']?></b><br>
Price: <b><?=$row['price']?> AED</b><br>
</td>
<td>
<img src="<?=$base_url?>images/Upload/product/<?=$row['image1']?>" width="100px" height="100px"/>
</td>
<td>
<?php
if(($row['status']=='1')){
echo'<a href="show.php?page=pro&&status_id='.$row['id'].'" class="btn btn-success btn-sm"><i class="feather icon-eye"></i></a>';
}
else{
echo'<a href="show.php?page=pro&&status_id='.$row['id'].'" class="btn btn-danger btn-sm"><i class="feather icon-eye-off"></i></a>';
}
?>
<a href="edit.php?page=pro&&id=<?=$row['id']?>" class="btn btn-info btn-sm"><i class="feather icon-edit"></i></a>
<a href="show.php?page=pro&&delete_id=<?=$row['id']?>" class="btn btn-danger btn-sm" onclick="return confirm('Are you sure to delete the records?');"><i class="feather icon-trash-2"></i></a>
<a href="show.php?page=pro©id=<?=$row['id']?>" class="btn btn-sm bg-secondary text-white fs-13px btn-xs me-4" onclick="return confirm('Are you sure to copy the record?');"><i class="far fa-copy "></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 `product_tbl` WHERE id ='$id'"));
if($stsQry['status']==0){
$updtQry=mysqli_query($conn,"UPDATE `product_tbl` SET `status`='1' WHERE id='$id'")or die(mysqli_error($conn));
if($updtQry){
echo "<script>window.location='show.php?page=pro';</script>";
$_SESSION['message']="Status Activated Successfully";
}
}
elseif($stsQry['status']==1){
$updtQry=mysqli_query($conn,"UPDATE `product_tbl` SET `status`='0' WHERE id='$id'")or die(mysqli_error($conn));
if($updtQry){
echo "<script>window.location='show.php?page=pro';</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 `product_tbl` WHERE id='".$_GET['delete_id']."'"));
$dlt_path="../../images/Upload/product/".$dlt['image1'];
unlink($dlt_path);
// $result = mysqli_query($conn, "SELECT * FROM `product_img_tbl` WHERE product_id='$id'");
// while ($dlt1 = mysqli_fetch_array($result)) {
// $dlt_path1 = "../../images/Upload/product/" . $dlt1['image_atb'];
// unlink($dlt_path1);
// }
// $deleteUser = "DELETE FROM product_img_tbl WHERE product_id='$id'";
// mysqli_query($conn, $deleteUser);
// $dtQuery2=mysqli_query($conn,"DELETE FROM `product_attribute` WHERE product_id='$id'");
// $dtQuery1=mysqli_query($conn,"DELETE FROM `product_faq` WHERE product_id='$id'");
$dtQuery=mysqli_query($conn,"DELETE FROM `product_tbl` WHERE id='$id'");
if($dtQuery){
echo "<script>window.location='show.php?page=pro';</script>";
$_SESSION['delete']="Record Deleted Successfully";
}
}
?>
<?php
if(isset($_POST['but_delete']) && isset($_POST['delete'])){
foreach($_POST['delete'] as $deleteid){
// Delete images associated with the product from product_img_tbl
// $result_img = mysqli_query($conn,"SELECT * FROM `product_img_tbl` WHERE product_id='$deleteid'");
// while($dlt_img = mysqli_fetch_array($result_img)){
// $dlt_path_img = "../../images/Upload/product/".$dlt_img['image_atb'];
// unlink($dlt_path_img);
// }
// Delete the main product image from product_tbl
$dlt1 = mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `product_tbl` WHERE id='$deleteid'"));
$dlt_path_main = "../../images/Upload/product/".$dlt1['image1'];
unlink($dlt_path_main);
// Delete related entries from other tables
// mysqli_query($conn,"DELETE FROM product_attribute WHERE product_id='$deleteid'");
// mysqli_query($conn,"DELETE FROM product_faq WHERE product_id='$deleteid'");
// mysqli_query($conn,"DELETE FROM product_img_tbl WHERE product_id='$deleteid'");
mysqli_query($conn,"DELETE FROM product_tbl WHERE id='$deleteid'");
}
echo "<script>window.location='show.php?page=pro';</script>";
$_SESSION['delete'] = "All Records Deleted Successfully";
}
?>
<?php
if(isset($_POST['but_active'])){
if(isset($_POST['delete'])){
foreach($_POST['delete'] as $deleteid){
$deleteUser = "UPDATE `product_tbl` SET `status`='1' WHERE id=".$deleteid;
mysqli_query($conn,$deleteUser);
echo "<script>window.location='show.php?page=pro';</script>";
$_SESSION['message']="All Status Activated Successfully";
}
}
}
?>
<?php
if(isset($_POST['but_deactive'])){
if(isset($_POST['delete'])){
foreach($_POST['delete'] as $deleteid){
$deleteUser="UPDATE `product_tbl` SET `status`='0' WHERE id=".$deleteid;
mysqli_query($conn,$deleteUser);
}
echo "<script>window.location='show.php?page=pro';</script>";
$_SESSION['error']="All Status Deactivated Successfully";
}
}
?>