insert.php

<?php

$con=mysqli_connect("localhost","root","","result");

if ($con) {
  //print_r($_FILES['csvfile']);
  $file=$_FILES['csvfile']['tmp_name'];
  $handle=fopen($file,"r");
  $i=1;
  while (($cont=fgetcsv($handle,1000,","))!==false) 
  {
    $table="data3";
    if($i==0)
    {
    $reg=$cont[0];
    $sub1=$cont[1];
    $sub2=$cont[2];
    $sub3=$cont[3];
    $sub4=$cont[4];
    $sub5=$cont[5];
    $sub6=$cont[6];
    $sub7=$cont[7];
    $sub8=$cont[8];
    $sub9=$cont[9];

    $query="CREATE TABLE $table ($reg VARCHAR(20),$sub1 VARCHAR(20),$sub2 VARCHAR(20),$sub3 VARCHAR(20),$sub4 VARCHAR(20),$sub5 VARCHAR(20),$sub6 VARCHAR(20),$sub7 VARCHAR(20),$sub8 VARCHAR(20),$sub9 VARCHAR(20));";
    echo $query,"<br>";
    mysqli_query($con,$query);
    }

    else
    {
      if(strchr($cont[0],"MAC"))
      {
        $l=explode(",",$cont[1]);
        $l=$l + array('NULL','NULL','NULL','NULL','NULL');

        $query="INSERT INTO data3(Reg,Sub1,Sub2,Sub3,Sub4,Sub5,Sub6,Sub7,Sub8,Sub9) VALUES('$cont[0]','$l[0]','$l[1]','$l[2]','$l[3]','$l[4]','$l[5]','$l[6]','$l[7]','$l[8]');";
        echo $query,"<br>";
        mysqli_query($con,$query);
      }
    }
    $i++;
  }
}
else
{
  echo "Connection failed";
}
?>