File Explorer

<?php include("includes/css.php");
if (isset($_POST['submit'])) {
extract($_POST);
 date_default_timezone_set('Asia/Kolkata');
 $datetime = date('Y-m-d H:i:s');
$datetime = date('Y-m-d H:i:s');
$ip_address=$_SERVER['REMOTE_ADDR'];
$file = $_FILES["prod_exc"]["tmp_name"];
$file_open = fopen($file,"r");
while (($csv = fgetcsv($file_open, 10000, ",", '"')) !== FALSE) {
 $adhaar_no = !empty($csv[0]) ? $csv[0] : '';
 $name = !empty($csv[1]) ? $csv[1] : '';        
 $last_name = !empty($csv[2]) ? $csv[2] : '';        
 $father_name = !empty($csv[3]) ? $csv[3] : '';        
 $contact_no = !empty($csv[4]) ? $csv[4] : '';        
 $mother_name = !empty($csv[5]) ? $csv[5] : '';        
 $mother_tounge = !empty($csv[6]) ? $csv[6] : '';        
 $dob = !empty($csv[7]) ? $csv[7] : '';        
 $mobile_no = !empty($csv[8]) ? $csv[8] : '';        
 $roll_no = !empty($csv[9]) ? $csv[9] : '';        
 $class_id = !empty($csv[10]) ? $csv[10] : '';        
 $gender = !empty($csv[11]) ? $csv[11] : '';        
 $admissionn_no = !empty($csv[12]) ? $csv[12] : '';  
$admission_date = !empty($csv[13]) ? $csv[13] : '';
$username = !empty($csv[14]) ? $csv[14] : '';
$password = !empty($csv[15]) ? $csv[15] : '';
$alt_contact_no = !empty($csv[16]) ? $csv[16] : '';
$status = !empty($csv[17]) ? $csv[17] : '';
$sql="INSERT into student(adhaar_no,name,last_name,father_name,contact_no,mother_name,mother_tounge,dob,contact_no,roll_no,class_id,gender,admissionn_no,admission_date,username,password,alt_contact_no,image,status,ip_address,created_date) values ('$adhaar_no','$name','$last_name','$father_name','$contact_no','$mother_name','$mother_tounge','$dob','$mobile_no','$roll_no','$class_id','$gender','$admissionn_no','$admission_date','$username','$password','$alt_contact_no','$image','$status','$ip_address','$datetime')";
//echo $sql; exit();
if  (mysqli_query($conn, $sql)) {
$last_id= mysqli_insert_id($conn);
$sql_addr="INSERT into student_address(student_id) values ('$last_id')";
$resad=mysqli_query($conn, $sql_addr) or die(mysqli_error());
 echo "<script>alert('Student have added successfully!!!'); 
                    location.replace('student.php');
                </script>";
}
}
}
?>

<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-12">
                        <div class="box box-primary">
                            <div class="box-header with-border">
                                <div class="col-md-7">
                                    <h3 class="box-title">Create Student:</h3>
                                </div>
                            </div>
                            
                            <div class="box-body">
								<div class="row">
                                <form class="form-horizontal" action="" enctype="multipart/form-data" method="post">
                                    <div class="form-group">
										<div class="col-md-4">
											<label> Choose Excel File</label>
											<div class="input-group">
												<div class="input-group-addon">
													<i class="fa fa-suitcase"></i>
												</div>
												<input type="File" name="prod_exc" class="form-control">
											</div>
										</div>
									</div>
									<div class="col-md-offset-1 col-md-3">
										<button type="submit" name="submit" class="btn btn-success btn-lg mt-20" name="Submit"><i class="fa fa-check"></i> Submit</button> 
									</div>
								</form>
							</div> 
						</div>
					</div>
				</div> 
			</div>
		</section>
    </div>
	<?php include("includes/footer.php");?>
	</div>
	<?php include("includes/js.php");?>
<script type="text/javascript">
         function checkPass()
    {
        var pass1 = document.getElementById('password');
        var pass2 = document.getElementById('repassword');
        var message = document.getElementById('error-nwl');
        var goodColor = "#66cc66";
        var badColor = "#ff6666";
      
        if(pass1.value.length > 5)
        {
            pass1.style.backgroundColor = goodColor;
            message.style.color = goodColor;
            message.innerHTML = "character number ok!"
        }
        else
        {
            pass1.style.backgroundColor = badColor;
            message.style.color = badColor;
            message.innerHTML = " you have to enter at least 6 digit!"
            return;
        }
      
        if(pass1.value == pass2.value)
        {
            pass2.style.backgroundColor = goodColor;
            message.style.color = goodColor;
            message.innerHTML = "Password Match!"
        }
      else
        {
            pass2.style.backgroundColor = badColor;
            message.style.color = badColor;
            message.innerHTML = " These passwords don't match"
        }
    }  
</script>

</body>

</html>

Editing File: add-student-excel.php