/home/hdwebsolution/public_html/ns-interior/admin-pages/add-gallery.php
<?php include('site-header.php'); ?>
<?php include('left-nevigation.php'); ?>
<main id="playground">
<?php include('site-top-header.php'); ?>
<?php
extract($_POST);
$image_name = $_FILES['gal_image']['name'];
$image_names = time()."_".$image_name;
?>
<?php
// Insert
if(isset($_REQUEST['Insert']))
{
$sqlinsrt = "INSERT INTO `tbl_gallery`(`gal_image`) VALUES ('$image_names')";
if(mysqli_query($link,$sqlinsrt))
{
move_uploaded_file($_FILES['gal_image']['tmp_name'],"../gallery-image/".$image_names);
$img = "<p style='color:green;'>Image Upload successfully!</p>";
}
}
// Update
if(isset($_REQUEST['Updt']))
{
if($_FILES['gal_image']['name']!=="")
{
$sqlUp = "UPDATE `tbl_gallery`
SET `gal_image`='$image_names'
WHERE `gal_id`=$img_id";
if(mysqli_query($link,$sqlUp))
{
if(move_uploaded_file($_FILES['gal_image']['tmp_name'],"../gallery-image/".$image_names))
{
unlink("../gallery-image/$del_image");
$img = "<p style='color:green;'>Update successfully!</p>";
}
}
}
}
// Delete
if(!empty($_REQUEST['del_logo_id']))
{
$sql="DELETE FROM `tbl_gallery` WHERE `gal_id`='$del_logo_id'";
if(mysqli_query($link,$sql))
{
unlink("../gallery-image/$del_image");
}
}
// Fetch
$sql = "SELECT * FROM tbl_gallery";
$data = mysqli_query($link, $sql);
$count = mysqli_num_rows($data);
?>
<section id="page-title" class="row">
<div class="col-md-8">
<h1>Gallery Image</h1>
<p class="lead">Update your Gallery Image</p>
<p style="font-weight: bold;font-size:18px;">Recommended Size: (463 x 381) px</p>
<?=$img;?>
</div>
<div class="col-md-4"></div>
</section>
<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="../gallery-image/<?=$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="<?=$result['gal_image'];?>">
<input type="hidden" name="img_id" value="<?=$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="<?=$result['gal_image'];?>">
<input type="hidden" name="del_logo_id" value="<?=$result['gal_id']?>">
<div class="text-center"><button class="btn btn-danger" name="del" style="width:100%;">Delete</button></div>
</form>
</div>
<?php } ?>
</div>
</div>
<?php if($count < 5000){ ?>
<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>
</div>
<?php } ?>
<?php include('site-footer.php'); ?>