File Explorer

<?php include("includes/css.php");
if (isset($_POST['submit'])) {
extract($_POST);
   $tmp_file = $_FILES['subcat_banner']['tmp_name'];
    $ext = pathinfo($_FILES["subcat_banner"]["name"], PATHINFO_EXTENSION);
    $rand = md5(uniqid().rand());
    $subcat_bimg = $rand.".".$ext;
     $sql2="SELECT * from category where id='$category'";
    $exe2=mysqli_query($conn,$sql2);
    $res2=mysqli_fetch_array($exe2);
    $category_page = strtolower(str_replace(" ", "-", $res2["name"]));
    $sub_category_page = strtolower(str_replace(" ", "-", $sub_name));
    if(file_exists('../'.$category_page)){
	    if(!file_exists('../'.$category_page.'/'.$sub_category_page)){
	        if(copy('../about-us.php', '../'.$category_page.'/'.$sub_category_page.'.php')) {
	           move_uploaded_file($tmp_file,"banner/".$subcat_bimg);
	            $sql="INSERT into sub_category(category_id,sub_name,subcat_banner,title,meta_keyword) values ('$category','$sub_name','$subcat_bimg','$title','$meta_key')";
				$res=mysqli_query($conn,$sql) or die(mysqli_error());
	            if ($res) {
	                echo "  <script> 
	                            alert('Your Sub category have added successfully!!!'); 
	                            location.replace('sub-category.php');
	                        </script>";
	            } else {
	                echo "  <script> 
	                            alert('There are some problem please try again!!!'); 
	                            location.replace('sub-category.php');
	                        </script>";
	            }
	        } 
	        else {
	            echo "  <script> 
	                        alert('There are some problem please try again!!!'); 
	                        location.replace('sub-category.php');
	                    </script>";
	        }
	    }
	    else{
	        echo "  <script> 
	                    alert('Sub category aleady exists, please change the and try again!!!'); 
	                    location.replace('sub-category.php');
	                </script>";
	    }
	}
	else{
	    echo "  <script> 
	                alert('Category not exists, please check and try again!!!'); 
	                location.replace('sub-category.php');
	            </script>";
	}
}

if(isset($_POST['update']))
{
	//var_dump($_POST);exit();
extract($_POST);
$id=$_POST["cat_id"];
$sql_qry = "SELECT * from category where id = '$cat_name'";
$row_cat = mysqli_query($conn,$sql_qry) or die(mysqli_error());
$resg_cat = mysqli_fetch_array($row_cat);
$catname = strtolower(str_replace(" ", "-", $resg_cat['name']));
$subcatname = strtolower(str_replace(" ", "-", $subcat_name_old));
	if(file_exists('../'.$catname)){
	    if(strtolower(str_replace(" ", "-", $subcat_name)) == strtolower(str_replace(" ", "-", $subcat_name_old))) {
	        if(file_exists('../'.$catname.'/'.strtolower(str_replace(" ", "-", $subcat_name_old)).'.php')){
				$sql1 ="UPDATE  sub_category  SET category_id='$cat_name', sub_name='$subcat_name', title='$title', meta_keyword='$meta_key' WHERE id='$id'"; 
				$res=mysqli_query($conn,$sql1) or die(mysqli_error());
				if($res){
				$sqlg = "SELECT * from sub_category where id = $id";
				  $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error());
				  $resg = mysqli_fetch_object($resultg);

}
				}
			}
		} else{
			if(file_exists('../'.$catname.'/'.strtolower(str_replace(" ", "-", $subcat_name_old)).'.php')){
               	if(rename("../$catname/".strtolower(str_replace(" ", "-", $subcat_name_old)).".php", "../$catname/".strtolower(str_replace(" ", "-", $subcat_name)).".php")){
               		$sql1 ="UPDATE  sub_category  SET category_id='$cat_name', sub_name='$subcat_name', title='$title', meta_keyword='$meta_key' WHERE id='$id'"; 
					$res=mysqli_query($conn,$sql1) or die(mysqli_error());

if($res){
					$sqlg = "SELECT * from sub_category where id = $id";
					  $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error());
					  $resg = mysqli_fetch_object($resultg);

$sql1 ="UPDATE  sub_category  SET category_id='$cat_name', sub_name='$subcat_name', title='$title', meta_keyword='$meta_key' WHERE id='$id'"; 
					$res=mysqli_query($conn,$sql1) or die(mysqli_error());
					if($res){
					 $sqlg = "SELECT * from sub_category where id = $id";
					  $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error());
					  $resg = mysqli_fetch_object($resultg);

if($_FILES["subcat_bnimg"]["name"] != ""){
						$oname=$_FILES["subcat_bnimg"]["name"];
						$pos = strrpos($oname, ".");
						$extension=substr($oname,$pos+1);
						$tn = $_FILES["subcat_bnimg"]["tmp_name"];
						$path = "banner/".$resg->id.'123'.'.'.$extension;
						$upath = "banner/".$resg->subcat_banner;
						unlink($upath);
						 move_uploaded_file($tn,$path);
						 $image_ban = $resg->id.'123'.'.'.$extension;
						} else {
						  $image_ban = $resg->subcat_banner;
						}
                   $sqlup = "UPDATE sub_category SET subcat_banner='$image_ban' WHERE  id = $resg->id";
						$resultup = mysqli_query($conn,$sqlup) or die(mysqli_error());
					}
				}
            }
		}
	}
}
?>
<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-7">
						<div class="box box-danger">
							<div class="box-header with-border">
								<h3 class="box-title">Sub-Category</h3>
							</div>
							
							<div class="box-body table-responsive">
								<table class="table table-bordered example1">
									<thead>
										<tr>
											<th>S. No</th>
											<th>Category</th>
											<th>Sub-Category</th>
											 <th>Banner</th> 								<th>Edit</th>
											<th>Delete</th>
										</tr>
									</thead>
									<tbody>
									<?php
									$sql="select sub_category.*,category.name from sub_category join category on sub_category.category_id=category.id";
									$result = mysqli_query($conn, $sql);
									 $j=1;
									while($res= mysqli_fetch_array($result))
									{ 
									?>
											<tr>
											<td><?php echo $j; $j++; ?></td>
											<td><?php echo $res['name']; ?></td> 
											<td><?php echo $res['sub_name']; ?></td> 
										 <td><img src="banner/<?= $res['subcat_banner']; ?>" width="40px"></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_subcat_by_ID('<?php echo $res['id'] ?>', '<?php echo $res['name'] ?>', '<?php echo $res['sub_name'] ?>');" class="ask"><i class="fa fa-trash-o"></i></a></td>
										</tr>
										<?php } ?>
									</tbody>
								</table>
							</div>
							
						</div>
					</div>
					<div class="col-md-5">
						<div class="box box-danger">
							<div class="box-header">
								<h3 class="box-title">Add New Sub-Category</h3>
							</div>
							<div class="box-body">
								<form method="post" action="" enctype="multipart/form-data">
									<div class="form-group">
										<label>Category:</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<select name="category" class="form-control">
												<option>Select</option>
												 <?php
								            $sql2="SELECT * from category";
								            $exe2=mysqli_query($conn,$sql2);
								            while ($res2=mysqli_fetch_array($exe2))
								            {
								            ?>
								            <option value="<?php echo $res2['id']; ?>"><?php echo $res2['name'];?></option>
								            <?php
								            }
								            ?>
											</select>
										</div>
									</div>
									<div class="form-group">
										<label>Sub Category:</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="text" name="sub_name" class="form-control" placeholder="Enter Sub-Category Name">
										</div>
									</div>

<div class="form-group">
										<label>Sub Category Banner :<span class="text-red">( Size : 1920px X 652px )</span></label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="file" name="subcat_banner" class="form-control" placeholder="Category">
										</div>
									</div>
									<div class="form-group">
										<label>Title</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="text" name="title" class="form-control" placeholder="Enter T itle">
										</div>
									</div>

<div class="form-group">
										<label>Meta Keyword</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											
											  <textarea name="meta_key" class="form-control" style="height:200px"></textarea>
										</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="add_data_Modal" class="modal fade">  
			      <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">Update Sub Category</h4>  
			                </div>  
			                  <form method="post" id="insert_form" enctype="multipart/form-data">  
			                <div class="modal-body">  
			                   <label> Category</label> 
			                    <select name="cat_name" id="cat_name" class="form-control">
											<option>Select</option>
											 <?php
							            $sql2="SELECT * from category";
							            $exe2=mysqli_query($conn,$sql2);
							            while ($res2=mysqli_fetch_array($exe2))
							            {
							            ?>
							            <option value="<?php echo $res2['id']; ?>"><?php echo $res2['name'];?></option>
							            <?php
							            }
							            ?>
										</select>
			                         <div class="form-group">
			                          <label>Sub Category </label>  
			                          <input type="text" name="subcat_name" id="subcat_name" class="form-control" placeholder=" ">
			                          <input type="hidden" name="subcat_name_old" id="subcat_name_old" class="form-control" placeholder=" ">
			                      </div>
			                      <div class="form-group">
									<label>Sub Category Banner </label>  
                                  <input type="file" name="subcat_bnimg" class="form-control" placeholder=" Photo">
								</div> 	
							
			                    <div class="form-group">
									   <label>Title</label>  
                                  <input type="text" name="title" id="title" class="form-control" placeholder=" Title">
								</div> 	
							
			                    <div class="form-group">
									   <label>Meta Keyword</label>  
                                  <input type="text" name="meta_key" id="meta_key" class="form-control" placeholder=" Meta Keyword">
								</div> 	
			                    <input type="hidden" name="cat_id" id="cat_id" />
			                </div>  
			                <div class="modal-footer">  
			                	 <input type="submit" name="update" id="insert" value="Insert" class="btn btn-success" />
			                     <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>  
			                </div> 
			                </form>  
			           </div>  
			      </div>  
			 </div>  
			
			</section>
		</div>
		<?php include("includes/footer.php")?>
	</div>
	<?php include("includes/js.php")?>
	 
<script>
	$(function() {
		$('.example1').DataTable()
		$('.example2').DataTable({
			'paging': true,
			'lengthChange': false,
			'searching': false,
			'ordering': true,
			'info': true,
			'autoWidth': false
		}); 
	});
</script>
<script language="javascript">

$(document).ready(function(){  
      $(document).on('click', '.edit_data', function(){  
           var cat_id = $(this).attr("id");  
           $.ajax({  
                url:"edit_subcat.php",  
                method:"POST",  
                data:{cat_id:cat_id},  
                dataType:"json",  
                success:function(data){  
                     $('#cat_name').val(data.category_id); 
                     $('#subcat_name').val(data.sub_name); 
                     $('#subcat_name_old').val(data.sub_name); 
                     $('#title').val(data.title); 
                     $('#meta_key').val(data.meta_keyword); 
                     $('#cat_id').val(data.id);  
                     $('#insert').val("Update");  
                     $('#add_data_Modal').modal('show');  
                }  
           });  
      });  
     
 });

function delete_subcat_by_ID(id, name, sub_name)
{
	if (confirm('Do You Want to Deleting This \nContinue anyway?')) {
		window.location.href = 'delete_subcategory.php?id=' + id + '&name=' + name + '&sub_name=' + sub_name;
	}
}
</script>
</body>
</html>

Editing File: sub-category.php