/home/hdwebsolution/www/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'); ?>
Path: home/hdwebsolution/www/ns-interior/admin-pages