/home/hdwebsolution/public_html/ns-interior/admin-pages/product-image.php
<?php include('site-header.php'); ?>
<!-- end of LOGO CONTAINER -->
<!-- - - - - - - - - - - - - -->
<!-- start of SIDEBAR -->
<!-- - - - - - - - - - - - - -->
<?php include('left-nevigation.php'); ?>
<!-- - - - - - - - - - - - - -->
<!-- end of SIDEBAR -->
<!-- - - - - - - - - - - - - -->
<main id="playground">
<!-- - - - - - - - - - - - - -->
<!-- start of TOP NAVIGATION -->
<!-- - - - - - - - - - - - - -->
<?php include('site-top-header.php'); ?>
<!-- - - - - - - - - - - - - -->
<!-- end of TOP NAVIGATION -->
<!-- - - - - - - - - - - - - -->
<!-- PAGE TITLE -->
<?php
$product_id =$_GET['pro_id'];
$image_name=$_FILES['gal_image']['name'];
$image_names= time()."_".$image_name;
?>
<?php
if(isset($_REQUEST['Insert']))
{
$sqlinsrt="insert into tbl_product_image set pro_id=$product_id, gal_image='$image_names'";
if(mysqli_query($link,$sqlinsrt))
{
move_uploaded_file($_FILES['gal_image']['tmp_name'],"../product-image/".$image_names);
$msg = "<p style='color:green;'>Save Product Image Successfully!!!</p>";
}
}
?>
<?php
if(isset($_REQUEST['Updt']))
{
if($_FILES['gal_image']['name']=="")
{
$sqlu="select * from tbl_product_image where gal_id='$_REQUEST[img_id]'";
$datau= mysqli_query($link,$sqlu);
$resultu = mysqli_fetch_array($datau);
$image_names=$resultu['gal_image'];
}
$del_image = $_REQUEST['del_image'];
$sqlinsrt="update tbl_product_image set
gal_image='$image_names'
where gal_id='$_REQUEST[img_id]'";
if(mysqli_query($link,$sqlinsrt))
{
$msg = "<p style='color:green;'>Update Product Image Successfully!!!</p>";
if(move_uploaded_file($_FILES['gal_image']['tmp_name'],"../product-image/".$image_names))
{
unlink("../product-image/$del_image");
}
}
}
?>
<?php
if($_REQUEST['del_logo_id']!="")
{
$del_logo_id=$_REQUEST['del_logo_id'];
$del_image = $_REQUEST['del_image'];
$sql="delete from tbl_product_image where gal_id='$del_logo_id'";
if($data= mysqli_query($link,$sql))
{
$msg = "<p style='color:green;'>Delete Product Image Successfully!!!</p>";
unlink("../product-image/$del_image");
}
}
?>
<?php
$sql="SELECT * FROM `tbl_product_image` WHERE pro_id=$product_id";
$data= mysqli_query($link,$sql);
$count=mysqli_num_rows($data);
?>
<section id="page-title" class="row">
<div class="col-md-8">
<h1>product Image</h1>
<p class="lead">Update your product Image</strong>.</p>
<p style="font-weight: bold;font-size:18px;">Image for Product Page (Size :1000 X 1000 pixels)</p>
<?=$msg;?>
<a href="show-product.php" class="btn btn-primary ">Back</a>
</div>
<div class="col-md-4">
</div>
</section>
<!-- / PAGE TITLE -->
<div class="container-fluid">
<div class="row">
<?php while($result=mysqli_fetch_array($data)){ ?>
<form enctype="multipart/form-data" method="post">
<div class="col-md-4">
<section class="panel tasks-widget"> <img src="../product-image/<?php echo $result['gal_image']; ?>" class="img-responsive" style="height:280px; width:100%;"> </section>
<div class="text-center"><input type="file" name="gal_image"></div>
<input type="hidden" name="del_image" value="<?php echo $result['gal_image']; ?>">
<input type="hidden" name="img_id" value="<?php echo $result['gal_id'] ?>">
<div class="text-center"><button class="btn btn-primary" name="Updt" style="width:100%;">Update</button> </div>
</form>
<form method="post">
<input type="hidden" name="del_image" value="<?php echo $result['gal_image']; ?>">
<input type="hidden" name="del_logo_id" value="<?php echo $result['gal_id'] ?>">
<div class="text-center"><button class="btn btn-primary" name="del" style="width:100%;">Delete</button> </div>
</form>
</div>
<?php } ?>
</div>
<!-- / row -->
</div>
<?php if($count>=20){
echo "";
}else{
?>
<div class="container-fluid" style="margin-top:80px;">
<div class="row">
<div class="col-md-4">
</div>
<form method="post" enctype="multipart/form-data">
<div class="col-md-4">
<div class="text-center"><input type="file" name="gal_image" class="btn btn-primary"> </div>
<div class="text-center"><button type="submit" name="Insert" class="btn btn-primary" style="width:100%;">Add Image </button></div>
</div>
</form>
<div class="col-md-4">
</div>
</div>
<!-- / row -->
</div>
<?php } ?>
<!-- / container-fluid -->
<?php include('site-footer.php'); ?>