FM / admin

/home/aqcert/public_html/admin

Name	Size	Mode	Actions
dash/	-	0755	rm
image/	-	0755	rm
images/	-	0755	rm
tinymce/	-	0755	rm
about-us.php	3216	0644	edit dl rm
allcertificate.php	2761	0644	edit dl rm
certificate-update.php	5845	0644	edit dl rm
certificate.php	6743	0644	edit dl rm
changepassword.php	3772	0644	edit dl rm
clients.php	9259	0644	edit dl rm
config.php	645	0644	edit dl rm
connection.php	236	0644	edit dl rm
contact.php	3542	0644	edit dl rm
delete_slider_image.php	1151	0644	edit dl rm
error_log	3863	0644	edit dl rm
footer.php	3202	0644	edit dl rm
home-slider.php	4901	0644	edit dl rm
how-we-work.php	3222	0644	edit dl rm
index.php	2705	0644	edit dl rm
login.php	6920	0644	edit dl rm
login1.php	3842	0644	edit dl rm
logout.php	255	0644	edit dl rm
main.php	7708	0644	edit dl rm
services-update.php	4801	0644	edit dl rm
services.php	4995	0644	edit dl rm
slider_image_change.php	4661	0644	edit dl rm
update-footer.php	3220	0644	edit dl rm
vision-mission.php	3232	0644	edit dl rm
welcome-update.php	3223	0644	edit dl rm

Edit: /home/aqcert/public_html/admin/certificate.php (6743B)

<?php

include('main.php');
 error_reporting('E_ALL ^ E_NOTICE');
include('connection.php');
 ?>
 <div class="content-page">
                
                <div class="content">
                    <div class="container">

<div class="row">
                            <div class="col-sm-12">
                               
                             
                                <ol class="breadcrumb pull-right">
                                   
                                      <li><a href="index.php">Dashboard</a></li>
                                    <li class="">Certificate</li>
									 <li class="active">Add Certificate</li>
                                </ol>
                            </div>
                        </div>

<h4 class="hed"><i class="fa fa-user"></i> Add Certificate</h4> <hr/></br>
  
       
   <div class=" form">

<form class="form-horizontal m-t-20" action="" method="post" enctype="multipart/form-data" style="color:#000;">
      <div class="col-xs-12">
                        
						
						 <div class="col-xs-3"> Company Name:</div>
                        <div class="col-xs-9"><input type="text" name="company" class="form-control" required=""><br/>   
                        </div>
                    
                    </div>
					    
                 <div class="col-xs-12">
                        <div class="col-xs-3"> Certificate Number:</div>
                        <div class="col-xs-3"><input type="text" name="number" class="form-control" required=""><br/>   
                        </div>
						
						 <div class="col-xs-3"> Issue Date:</div>
                        <div class="col-xs-3"><input type="date" name="issue" class="form-control" required=""><br/>   
                        </div>
                    
                    </div>
                  
				  
				  <div class="col-xs-12">
                        
						
						 <div class="col-xs-3"> End Date:</div>
                        <div class="col-xs-3"><input type="date" name="end" class="form-control"    required="" ><br/>   
                        </div>
                    <div class="col-xs-3"> Certified Standard:</div>
                        <div class="col-xs-3"><input type="text" name="standard" class="form-control" required=""><br/>   
                        </div>
                    </div>
                    
                    <div class="col-xs-12">
                        
						
						 <div class="col-xs-3"> Status:</div>
                        <div class="col-xs-3"><select name="status" class="form-control"    required="" >
                           <option value="Active">Active</option> 
                           <option value="Deactive">Deactive</option> 
                        </select><br/>   
                        </div>
                    
                    </div>
                      
                        <div class="col-xs-12">
                        <div class="col-xs-3">Company Address:</div>
                        <div class="col-xs-9">
                       
                        
                        <input type="text" name="address" class="form-control"    required="" ><br/>  
                        </div>
                        </div>
                                 
       
     <div class="form-group text-center m-t-40">
                        <div class="col-xs-12">
                        
                         <input type="submit" name="insert" value="ADD" class="btn btn-lg btn-success" />     
  
      
      </div>
          </div>
	  </br>
     
</form>
<h4 class="hed"><i class="fa fa-user"></i>  View Certificate</h4> </br>

<table class="table table-bordered">
	<tr>
	<th> SNo. </th>
    	<th> Certificate No. </th>
        <th> Company Name </th>
       
        <th> Issue Date </th>
		<th> End Date </th>
        <th> Edit</th>
        <th> Delete</th>
      </th>
      <?php
	  	$select = "select * from certification";
		if($query = mysqli_query($con, $select))
		{
			$s=1;
			while($row = mysqli_fetch_array($query))
			{
				
		?>
        <tr>
		<td><?php echo $s;?></td>
        	<td><?php echo $row["c_no"];?></td>
            <td><?php echo $row['c_name'];?></td>
			
            <td><?php echo date("d-m-Y",strtotime($row['s_date']));?></td>
			<td><?php echo date("d-m-Y",strtotime($row['e_date']));?></td>
           
           	<td><a href="certificate-update.php?id=<?php echo $row["id"];?>"><button class="btn btn-success"><i class='fa fa-pencil' aria-hidden='true'></i>Edit </button></a></td>
            <td><a href="delete_slider_image.php?cid=<?php echo $row["id"];?>"> <button onClick='return checkMe()' name='id' value='"<?php echo $id;?>"' type='submit' class='btn btn-danger'><i class='fa fa-trash'></i> </button></a></td>
   
        </tr>
        <?php
		++$s;	}
			
		} 
	  ?>
</table> 
                                     </div> 
                                    </div> 
                                </div> 
                            </div>

</div>

<?php
if(isset($_POST['insert'])) 
{
    $cno=$_POST['number'];
//	$c=$_POST['certificate'];
	$company=$_POST['company'];
	$issue=$_POST['issue'];
	$end=$_POST['end'];
	$address=$_POST['address'];
		$status=$_POST['status'];
	$standard=$_POST['standard'];
$select = mysqli_query($con, "select * from certification where c_no='$cno'");
$q2 = mysqli_num_rows($select);
if($q2>0)
{
  echo "<script>alert('Certificate Already Add');</script>";
	  echo "<meta http-equiv='refresh' content='0'>";
}
else{
	$query=mysqli_query($con," INSERT INTO `certification`(`c_name`, `c_no`, `certificate`, `status`, `s_date`, `e_date`, `address`,standard) VALUES ('$company','$cno','','$status','$issue','$end','$address','$standard')");
	   if($query) {
  
	 echo "<script>alert('Certificate Added Succesfully');</script>";
	  echo "<meta http-equiv='refresh' content='0'>"; 
   }
}

}
?>

<?php include('footer.php');
?>

cmd: