Php snippets which is used to import data from excel file to mysql database

[zeesh...@gmail.com]

<?
set_time_limit(0);
$db_host = "localhost";$db_user = "username";$db_pass =
"password";$db_name = "dbname";
$db_conn = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db_name);
$filename = "mycsv.csv";
$handle = fopen($filename, "r");
$contents = fread($handle, filesize($filename));
$contents1 = explode("\n", $contents);

for( $i=0; $i < count($contents1); $i++ ){
$contents2 = explode(";", $contents1[$i]);
//give proper column name and so on ...
$strQry = "INSERT INTO tbl_personal_data (col1,col2,col3,col4)
VALUES('".($contents2[0])."','".($contents2[1])."','".($contents2[2])."','".($contents2[3])."','".($contents2[4])."');";
echo $i."<br>";mysql_query($strQry,$db_conn);
}
echo "done";
fclose($handle);
?>