insertarPlan.php

<?php
include 'conexion.php';
set_time_limit(300);
if(isset($_POST["Import"])){
 
 
		echo $filename=$_FILES["file"]["tmp_name"];
 
 
		 if($_FILES["file"]["size"] > 0)
		 {
 
		  	$file = fopen($filename, "r");
	         while (($emapData = fgetcsv($file, 10000, ";")) !== FALSE)
	         {
 
	          //It wiil insert a row to our subject table from our csv file`
	           $sql = "INSERT into plandeestudio (`ano`, `periodo`, `nombreSede`, `planDeEstudio`,escuela, `codJornada`, `nivel`, `seccion`, `codAsignatura`, `nombreAsignatura`, `rutDocente`, `Instructor`) 
	            	values('$emapData[0]','$emapData[1]','$emapData[2]','$emapData[3]','$emapData[4]','$emapData[5]','$emapData[6]','$emapData[7]','$emapData[8]','$emapData[9]','$emapData[10]','$emapData[11]')";
	         //we are using mysql_query function. it returns a resource on true else False on error
	          $result = mysqli_query( $con, $sql );
				if(! $result )
				{
					echo "<script type=\"text/javascript\">
							alert(\"Invalid File:Please Upload CSV File.\");
							window.location = \"IngresoPlanDeEstudio.php\"
						</script>";
 
				}
 
	         }
	         fclose($file);
	         //throws a message if data successfully imported to mysql database from excel file
	         echo "<script type=\"text/javascript\">
						alert(\"CSV File has been successfully Imported.\");
						window.location = \"IngresoPlanDeEstudio.php\"
					</script>";
 
 
 
			 //close of connection
			mysqli_close($con); 
 
 
 
		 }
	}	 
?>