<?php
require_once("../includes/dbsmain.inc.php");
$DelImageId=$_REQUEST['DelID'];
 if(!empty($DelImageId)){ 
   $imageToDel=db_scalar("select certificate_image_name from tbl_certificate where 1 and certificate_id='$DelImageId'"); 
   @unlink('../certificate/'.$imageToDel);
   $sqldel="delete from tbl_certificate where 1 and certificate_id='$DelImageId'";
   db_query($sqldel);
   set_session_msg("Certificate Updated Successfully !");
   header("Location: manage_certificate.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],"../certificate/$imgName")) {
			
			    $sql = "insert into tbl_certificate set 
		                   certificate_status='Active',
						   certificate_image_name='$imgName',
						   certificate_add_date=now()";
						   db_query($sql);				
            } 
			       
        }
		set_session_msg("Certificate uploaded successfully !");
		header("Location: manage_certificate.php");
		exit;
    }
 }
if($headerID!='') {
	$result = db_query("select * from tbl_certificate where certificate_id = '$certificate_id'");
	if ($line_raw = mysqli_fetch_array($result)) {
		@extract($line_raw);
	}
}
?>
<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="script.js"></script>
<? include("top.inc.php");?>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td id="pageHead"><div id="txtPageHead"> Add/Edit Certificates</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_certificate 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="../certificate/<?=$DATA['certificate_image_name']?>" width="90" height="90" /></p>
                <p align="center"><a href="manage_certificate.php?DelID=<?=$DATA['certificate_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 />
                        </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");?>