How to import the Excel data in mysql database using php script?

[santhanalakshmi]

Hi,
I wrote some coding, to import excel data in mysql database using PHP Script? But my script, its not all inserting the excel data in mysql database. I don't know, what mistake did i made? Please help me out

<?php
$strPath = realpath(basename(getenv($_SERVER['SCRIPT_FILENAME'])));
echo $strPath;
 
 
$excel_app = new COM("Excel.application") or Die ("Did not connect");
$Workbook = $excel_app->Workbooks->Open('C:\san1.xls') or Die('Did not open filename');
$Worksheet = $Workbook->Worksheets(1);
$Worksheet->activate;
 
 
 
$username = "root";
$hostname = "localhost"; 
 
//connection to the database
$dbhandle = mysql_connect($hostname, $username) or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
 
 
//select a database to work with
$selected = mysql_select_db("academics",$dbhandle) or die("Could not select examples");
 
echo "hi";
$i=2;  
while($Worksheet->Cells->Item($i,1) != "")  
{  
  $strSQL = "";  
  $strSQL .= "INSERT INTO tbl";  
  $strSQL .= "(rollno,crseno,marks,grade,att)";  
  $strSQL .= "VALUES";  
  $strSQL .= "('".$Worksheet->Cells->Item($i,1)."','".$Worksheet->Cells->Item($i,2)."' ";  
  #$strSQL .= ",'".$Worksheet->Cells->Item($i,3)."','".$Worksheet->Cells->Item($i,4)."' ";  
  $strSQL .= ",'".$Worksheet->Cells->Item($i,3)."','".$Worksheet->Cells->Item($i,4)."') ";  
  mysql_query($strSQL);  
  $i++;  
}  
 
//*** Close MySQL ***//  
@mysql_close($dbhandle);  
 
//*** Close & Quit ***//  
$excel_app->Application->Quit();  
$excel_app = null;  
$Workbook = null;  
$Worksheet = null; 
 
 
?>
 

Thanks in advance

[ronverdonk]

I'd suggest to use a free class for this, like
http://www.phpclasses.org/package/62...XLS-files.html