Upload excel Sheet data in mysql using Php

Upload excel Sheet data in mysql using Php

Note:Must require_once 'excel_reader.php';

I have not added html code only php code ,


Below code for two fields ,No,Name

if(isset($_POST['submit']))
{

$excelFileName = $_FILES['img_upload']['name'];
$uploadDir = '../uploadexcelfiles/';
$rand=rand(0,9999);
$uploadFile = $uploadDir . $excelFileName ;
$filename=$_FILES['img_upload']['name'];
$ext = substr($filename, strpos($filename,'.'), strlen($filename));

if($ext == '.xls' )
{
if (move_uploaded_file($_FILES['img_upload']['tmp_name'], $uploadFile))
{

$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('CP1251');
$data->read($uploadFile);


$flag=false;
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++)
{
$sql = false;
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++)
{
if (isset($data->sheets[0]['cells'][$i][$j]) && $data->sheets[0]['cells'][$i][$j] == 'No')
{
$flag = true;
$i++;
}
if (isset($flag))
{
if (isset($data->sheets[0]['cells'][$i][$j]) && $data->sheets[0]['cells'][$i][$j] != "")
{
if ($j == 1)
{
$No = $data->sheets[0]['cells'][$i][$j];
$No = !empty($No) ? $No : null;
$sql = true;
}
if ($j == 2)
{
$Name = $data->sheets[0]['cells'][$i][$j];
$Name = !empty($Name) ? $Name : null;
$sql = true;
}

}
}//end flag if
}//end j for

if (isset($sql))
{
// Apply sql query

}//end if of SQL
$No = "";
$Name="";

}

}
}

}