Post
by starram » Thu Apr 10, 2008 1:52 am
<?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="";
}
?>