<?php
require_once("../includes/dbsmain.inc.php");
$gallery_id=$_REQUEST['gallery_id'];
$DelImageId=$_REQUEST['DelID'];
 if(!empty($DelImageId)){ 
   $imageToDel=db_scalar("select gallery_image_name from tbl_gallery where 1 and gallery_id='$DelImageId'"); 
   @unlink('../gallery_images/'.$imageToDel);
   $sqldel="delete from tbl_gallery where 1 and gallery_id='$DelImageId'";
   db_query($sqldel);
   set_session_msg("Header flash Updated Successfully !");
   header("Location: manage_gallery.php");
   exit;
 }

if(is_post_back()) {
if (isset($_POST['submit'])) {
    for ($i = 0; $i < count($_FILES['file']['name']); $i++) {
	     $imgName=$_FILES['file']['name'][$i];
         if (move_uploaded_file($_FILES['file']['tmp_name'][$i],"../gallery_images/$imgName")) {
			
			    $sql = "insert into tbl_gallery set 
		                   gallery_status='Active',
						   gallery_image_name='$imgName',
						   gallery_add_date=now()";
						   db_query($sql);				
            } 
			       
        }
		set_session_msg("Image uploaded successfully !");
		header("Location: manage_gallery.php");
		exit;
    }
 }
?>
<link href="styles.css" rel="stylesheet" type="text/css">
<link href="imgstyle.css" rel="stylesheet" type="text/css">
<script src="jquery.min.js"></script>
<script src="scriptami.js"></script>
<?php include("top.inc.php");?>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td id="pageHead"><div id="txtPageHead"> Add/Edit Gallery Image</div></td>
              </tr>
            </table>
            <div><strong class="msg" style="margin-left:500px; margin-bottom:5px;">
              <?=display_sess_msg()?>
              </strong></div>
			  <div style="width:100%;">
			<?php			
			  $sql_fetch = db_query("select * from tbl_gallery where 1");
			  $cntDATA=mysqli_num_rows($sql_fetch);
			   if($cntDATA > 0){	
			    while($DATA = mysqli_fetch_array($sql_fetch)) {
		        @extract($DATA); 
             ?>
			 <div style="width:120px; height:140px; margin-top:10px;border:1px outset #fff; float:left; margin-left:8px;">
             <p align="center"><img src="../gallery_images/<?=$DATA['gallery_image_name']?>" width="90" height="90" /><br>
                <span style="font-weight:bold;"><?=$DATA['gallery_image_title']?></span></p>
				<p align="center"><a href="manage_gallery.php?DelID=<?=$DATA['gallery_id']?>"><img src="images/no.gif"></a></p>
          </div>
		  
			 <? }} ?>
			 <div class="cb"></div>
			 </div>
			  
			
            <table width="55%"  border="0" align="center" cellpadding="0" cellspacing="0" class="tableForm" style="border:1px outset #fff; margin-top:5px; margin-bottom:10px;">
              <tr>
                <td class="tdLabel" style="padding:8px;"><div id="maindiv">
                    <div id="formdiv">
                      <form enctype="multipart/form-data" action="" method="post">
                        <div id="filediv">
                          <input name="file[]" type="file" id="file" multiple /><span style="font-size:11px; color:#E60000; font-weight:bold; margin-left:5px;"><b style="color:#000000;">Image Size ></b> width :  200px, height : 200px</span>
                        </div>
                        <br/>
                        <input type="button" id="add_more" class="upload" value="Add More Files"/>
                        <input type="submit" value="Upload File" name="submit" id="upload" class="upload"/>
                      </form>
                      <br/>
                    </div>
                  </div></td>
              </tr>
            </table>
            <?php include("bottom.inc.php");?>