File Explorer

<?php include("includes/css.php");
if (isset($_POST['submit'])) {
    extract($_POST);
date_default_timezone_get('Asia/Kolkata');
$date=date("Y-m-d H:i:s");
	$sql="INSERT into online_class_link(class_id,link,created_date) values ('$class_id','$link','$date')";
	$res=mysqli_query($conn,$sql) or die(mysqli_error());
	if($res){
          echo "<script>window.location.href='online_class_link.php'</script>";
        }
}

if(isset($_POST['update']))
{
	//var_dump($_POST);exit();
extract($_POST);
$id=$_POST["b_id"];
$sql1 ="UPDATE  online_class_link SET class_id='$class_id',link='$link' WHERE id='$id'"; 
$res=mysqli_query($conn,$sql1) or die(mysqli_error());
if($res){
}
}

<body class="hold-transition skin-blue sidebar-mini">
	<div class="wrapper">
		<?php include("includes/header.php");?>
		<?php include("includes/sidebar.php");?>
		
		<div class="content-wrapper">
			
			
			<section class="content">
				<div class="row"> 
					<div class="col-md-6">
						<div class="box box-primary">
							<div class="box-header with-border">
								<h3 class="box-title">Banner: </h3>
							</div>
							
							<div class="box-body table-responsive">
								<table class="table table-bordered example2">
									<thead>
										<tr>
											<th>S. No</th>
											<th>Class</th> 
											<th>Link</th> 
											<th>Edit</th>
											<th>Delete</th>
										</tr>
									</thead>
									<tbody> 
										<?php  $sql2="SELECT online_class_link.*,class.class_name from online_class_link join class on online_class_link.class_id=class.id";
		                                   $exe2=mysqli_query($conn,$sql2);
		                                   $j=1;
		                                   while($res= mysqli_fetch_array($exe2))
		                                   {  ?>
										<tr>
											<td><?php echo $j; $j++; ?></td> 
											<td><?php echo $res['class_name']; ?></td>
											<td><?php echo $res['link']; ?></td>
											 <td><input type="button" name="edit" value="Edit" id="<?php echo $res["id"]; ?>" class="btn btn-md btn-success edit_data" /></td> 
											<td><a href="javascript:delete_banner_by_ID('<?php echo $res['id'] ?>');" class="ask"><i class="fa fa-trash-o"></i></a></td>
										</tr> 
									  <?php } ?>
									
									</tbody> 
								</table>
							</div>
							
						</div>
					</div>
					<div class="col-md-6">
						<div class="box box-primary">
							<div class="box-header">
								<h3 class="box-title">Add Online Class Link</h3>
							</div>
							<div class="box-body">
								<form method="post" action="" enctype="multipart/form-data">
									<div class="form-group">
										<label>Class :</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<select class="form-control" name="class_id">
		                                                <option>Select Class</option>
		                                                	 <?php
		                                            $sql2="SELECT * from class";
		                                            $exe2=mysqli_query($conn,$sql2);
		                                            while ($res2=mysqli_fetch_array($exe2))
		                                            { ?>
		                                            <option value="<?php echo $res2['id']; ?>"><?php echo $res2['class_name'];?></option>
		                                            <?php
		                                            }
		                                            ?> 
		                                            </select>
										</div>
									</div> 	
									<div class="form-group">
										<label>Link:</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div> 
											<input type="text" name="link" class="form-control" placeholder="Link">
										</div>
									</div>
									<div class="form-group">
										<div class="input-group">
											<input type="submit" name="submit" class="btn btn-success btn-md" value="Submit">
										</div>
									</div>
								</form>
							</div>
							
						</div>
					</div>
				</div>
				<div id="editbanner" class="modal fade" role="dialog">
					<div class="modal-dialog">
						<div class="modal-content">
							<div class="modal-header">
								<button type="button" class="close" data-dismiss="modal">&times;</button>
								<h4 class="modal-title">Edit Online Class</h4>
							</div>
							<div class="modal-body">
								<form method="post" action="" enctype="multipart/form-data">
									<div class="form-group">
										<label>Class:</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<select class="form-control" name="class_id" id="class_id">
		                                                <option>Select Class</option>
		                                                	 <?php
		                                            $sql2="SELECT * from class";
		                                            $exe2=mysqli_query($conn,$sql2);
		                                            while ($res2=mysqli_fetch_array($exe2))
		                                            { ?>
		                                            <option value="<?php echo $res2['id']; ?>"><?php echo $res2['class_name'];?></option>
		                                            <?php
		                                            }
		                                            ?> 
		                                            </select>
										</div>
									</div>
									 <div class="form-group">
										<label>Link :</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="text" name="link" id="link" class="form-control" placeholder="">
										</div>
									</div>
									 <input type="hidden" name="b_id" id="b_id" />
									
									<div class="form-group">
										<div class="input-group">
											<input type="submit" name="update" id="insert" class="btn btn-success btn-md" value="Update">
										</div>
									</div>
								</form>
							</div>
							<div class="modal-footer">
								<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
							</div>
						</div>
					</div>
				</div>
			</section>
		</div>
		<?php include("includes/footer.php");?>
	</div>
	<?php include("includes/js.php");?>
	<script type="text/javascript">
$(document).ready(function(){  
  $(document).on('click', '.edit_data', function(){  
       var b_id = $(this).attr("id");  
       $.ajax({  
            url:"edit_online_link.php",  
            method:"POST",  
            data:{b_id:b_id},  
            dataType:"json",  
            success:function(data){  
                 $('#class_id').val(data.class_id); 
                 $('#link').val(data.link); 
                 $('#b_id').val(data.id);  
                 $('#insert').val("Update");  
                 $('#editbanner').modal('show');  
            }  
       });  
  });  
});  
function delete_banner_by_ID(id)
{
if (confirm('Do You Want to Deleting This \nContinue anyway?')) {
    window.location.href = 'delete_onclass.php?id=' + id;
}
}
</script>

</body>

</html>

Editing File: online_class_link.php