Page 1 of 1
code to import excel data into database in php
Posted: Thu Apr 10, 2008 1:31 am
by padma525
hi
i want to import the excel data into a database. pls give me the php code to do that.
thanks

Re: code to import excel data into database in php
Posted: Thu Apr 10, 2008 1:48 am
by Christopher
Export the data from Excel as a delimited text file like CSV. Then use LOAD DATA INFILE to import the data.
Re: code to import excel data into database in php
Posted: Thu Apr 10, 2008 1:52 am
by starram
<?php
include("include/connection.php");
$file_name_arr=explode(".",$_FILES['file']['name']);
$ext=$file_name_arr[(count($file_name_arr)-1)];
if($ext=="csv")
{
$filename=$_FILES['file']['tmp_name'];
$handle = fopen("$filename", "r");
$query="insert into tablename (fields) values ";
//$handle = fopen($file_source, "r");
$query_values = "";
$ctr=1;
$row = 1;
while(($data = fgetcsv($handle, 4096, ",")) !== FALSE)
{
$num = count($data);
//if($row!=0 && $data[0]!="" && $data[1]!="")
if($row!=0 && ($data[0]!="" || $data[1]!="" || $data[2]!=""))
## Check for if we want to allow data read from which line
## Check for name and phone should not be blank
{
if($ctr <= 999)
{
$query_values .= "(";
for($var=0;$var<30;$var++)//change 30 to total number of fields.
{
if(isset($data[$var]))
{
$query_values .= "'".addslashes($data[$var])."',";
}
else
{
$query_values .= "'',";
}
}
$query_values = trim($query_values,",")."),";
}
else
{
$query_values .= "(";
for($var=0;$var<30;$var++)//change 30 to total number of fields.
{
if(isset($data[$var]))
{
$query_values .= "'".addslashes($data[$var])."',";
}
else
{
$query_values .= "'',";
}
}
$query_values = trim($query_values,",")."),";
}
$finalquery=$query.$query_values;
if ($ctr==1000)
{
$ctr=0;
$finalquery=$query.$query_values;
$finalquery=trim($finalquery, ",");
$result=mysql_query($finalquery);
$query_values="";
}
$ctr++;
}
$row++;
}
$finalquery=$query.$query_values;
$finalquery=trim($finalquery, ",");
$result=mysql_query($finalquery);
$query_values="";
}
?>