DaniWeb Forum Index > Web Development > PHP

parsing csv file

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jan 2005

Posts: 1

Reputation: AllenGarner is an unknown quantity at this point

Solved Threads: 0

AllenGarner AllenGarner is offline

Offline

Newbie Poster

parsing csv file

Jan 7th, 2005

I am trying to Upload a csv file then split it up into an an array and build a query to insert it into a mysql table I have succeeded in getting this to work with one exception when I come across a field seperated by commas and enclosed by double quotes if that field also contains double quotes inside of it it throws off my column count I need to be able to consider something like - ,"sometext"some more text"additional text", as one field or value here is what i have so far

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$row = 1; 
$handle = fopen($uploadFile, "r"); 
 
while ( ($data = fgetcsv($handle, 10000, ",")) != FALSE ) { 
$num = count($data); 
if($row == 1){
$fields = " `id` , ";
for($i=0; $i<$num; $i++){
$fields .= "`" . addslashes(trim($data[$i])) . "` , ";
}
$fields .= "`group` , `user` , "; 
$f = substr($fields, 0, -1);
$f = substr($f, 0, -1);
$row++;
}else{
$values = " '' , "; 
for($i=0; $i<$num; $i++){ 
$values .= "'" . addslashes(trim($data[$i])) . "' , ";
}
$values .= "'personal' , '" . $_SESSION['user'] . "' , ";
 
$v = substr($values, 0, -1);
$v = substr($v, 0, -1); 
$sql = "INSERT INTO `addressbook` ( $f ) VALUES ( $v )";
mysql_query($sql) or die(print "<center><font size='2' face='verdana' color='#5E6B79'><b>Upload complete some entries may not have been loaded successfully!</b><br><br><a href='addressbook.php' class='light'>Back to Address Book</a></font></center></td></tr></table>");
$values = ''; 
$row++;
} 
}
fclose ($handle);
$row = 1; 
$handle = fopen($uploadFile, "r"); 

while ( ($data = fgetcsv($handle, 10000, ",")) != FALSE ) { 
$num = count($data); 
if($row == 1){
$fields = " `id` , ";
for($i=0; $i<$num; $i++){
$fields .= "`" . addslashes(trim($data[$i])) . "` , ";
}
$fields .= "`group` , `user` , "; 
$f = substr($fields, 0, -1);
$f = substr($f, 0, -1);
$row++;
}else{
$values = " '' , "; 
for($i=0; $i<$num; $i++){ 
$values .= "'" . addslashes(trim($data[$i])) . "' , ";
}
$values .= "'personal' , '" . $_SESSION['user'] . "' , ";

$v = substr($values, 0, -1);
$v = substr($v, 0, -1); 
$sql = "INSERT INTO `addressbook` ( $f ) VALUES ( $v )";
mysql_query($sql) or die(print "<center><font size='2' face='verdana' color='#5E6B79'><b>Upload complete some entries may not have been loaded successfully!</b><br><br><a href='addressbook.php' class='light'>Back to Address Book</a></font></center></td></tr></table>");
$values = ''; 
$row++;
} 
}
fclose ($handle);