PHP: fgetcsv - Manual

User Contributed Notes
fgetcsv

Bob Kolk
17-May-2005 11:50


Dave Meiners above example is great, except that you need to need to add one to the final length to account for EOL.  So it'd be:



while ($data = fgetcsv($handle, ($length+1), ","))

marc at henklein dot com
21-Feb-2005 06:57


for excel-csv-sheets like:



test1;test2;test3;test4;"test5

test5b

test5c";test6



(optionally enclosed by " including line-breaks)



.. i wrote a little function to solve this problem.



<?php



function CSV2Array($content, $delim = ';', $encl = '"', $optional = 1)

{

    $reg = '/(('.$encl.')'.($optional?'?(?(2)':'(').

'[^'.$encl.']*'.$encl.'|[^'.

$delim.'\r\n]*))('.$delim.'|\r\n)/smi';



    preg_match_all($reg, $content, $treffer);

    $linecount = 0;



    for ($i = 0; $i<=count($treffer[3]);$i++)

    {

        $liste[$linecount][] = $treffer[1][$i];

        if ($treffer[3][$i] != $delim)

            $linecount++;

    }

    return $liste;

}



// usage for example:

$content = join('',file('test.csv'));

$liste = CSV2Array($content);

print_r($liste);

?>

slyi
19-Feb-2005 12:05


heres a version that take a bugzilla url and spits the results as rss



<?php 

$bugzillaurl="http://www.reactos.com/bugzilla/";

$bugquery= $bugzillaurl . "buglist.cgi?query_format=&bug_severity=blocker&ctype=csv";

header('Content-type: text/xml'); 

echo "<?xml version=\"1.0\" ?>\n";

?>



<rss version="2.0">

  <channel>

    <title>bugzilla csv2rss</title>

    <link><?=$bugzillaurl?></link> 

    <description>bugzilla csv2rss</description>

    <language>en-us</language>



<?php



$row = 0;

$handle = fopen($bugquery, "r");

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

   if($row == '0') { $row = '8';} //skip title stuff

   else{ // display all bugs

   $row++;

   echo "<item>\n";

   echo "<title>" . htmlspecialchars($data[7], ENT_QUOTES) . "</title>\n";

   echo "<description>" . htmlspecialchars($data[7], ENT_QUOTES) . "</description>\n";

   echo "<link>" . $bugzillaurl . "show_bug.cgi?id=" . $data[0] . "</link>\n";

   echo "</item>\n";

   }

}

fclose($handle);

?> 



 </channel>

</rss>

ramdac at ramdac dot org
23-Jan-2005 11:40


Be wary of Example #1 above.



If the file doesn't exist, the application will spit out data to STDOUT and could fill up /tmp space if you're not careful. The output might will look like this:



PHP Warning:  fgetcsv(): supplied argument is not a valid stream resource in...(your filename here)



To get around this, do the following:



<?

row = 1;

if(!$handle = fopen("test.csv", "r"))

{

     print 'could not open file. quitting';

      die;

}

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

   $num = count($data);

   echo "<p> $num fields in line $row: <br /></p>\n";

   $row++;

   for ($c=0; $c < $num; $c++) {

       echo $data[$c] . "<br />\n";

   }

}

fclose($handle);

?>

Daffy
22-Nov-2004 08:25


This is a little sniplet for all users who has problems with Excel csv files. This functions does almost the same like the linux shell program dos2unix.



/* ------------------8<------------------------*/

function dos2unix ($filename) {

        //open original file

        $fp = fopen($filename,'r');

        //open original file

        $fptmp = fopen($filename.'_tmp','w');

        while(!feof($fp)){

                $line = chop(fgets($fp,4096));

                $ret = ereg_replace(chr(13) . chr(10),"\n",$line);

                $ret = ereg_replace(chr(13),"\n",$ret);

                fwrite($fptmp,$ret);

        }



        fclose($fp);

        fclose($fptmp);

        //remove original file

        unlink($filename);

        //move converted file to old filename

        copy($filename.'_tmp', $filename);

        //remove temp file

        unlink($filename.'_tmp');

}

/* ------------------8<------------------------*/

18-Nov-2004 12:47


example 1 above goes into an infinte loop if the file name is bad because fgetcsv return a false result not identical to false but equl to false



to fix this use != instead of !== in the test as shown below it will still work correctly for the case when the file exists.



while (($data = fgetcsv($handle, 1000, ",")) != FALSE) {

mickoz[at]parodius[dot]com
30-Oct-2004 05:54


In "php at dogpoop dot cjb dot net" post, I would change in his function:



function csv_split($line,$delim=',',$removeQuotes=true)



this code:



if ($line[$i+1] == '"') {



to:



if ($i+1 < strlen($line) && $line[$i+1] == '"') {



The reason is that if the quote (") is at the last line of the string, then it will try to reach an undefined space in the string, therefore giving a PHP error.



Of course his function is great if your line is a true compatible csv line, but I leave that to you to judge if you can do this assumption ;-)

aidan at php dot net
01-Jul-2004 08:47


If you're looking to parse CSV files but find fgetcvs insufficient, check out http://pear.php.net/package/File

dave146 at burtonsys dot com
18-Jun-2004 03:29


To convert .dbf files (dBase/xBase/FoxPro/Clipper/etc.) files

to .csv, so that you can read them with fgetcsv, get dbf2csv.zip

from http://www.burtonsys.com/downloads.html



(It seems odd to me that php has fgetcsv but no splitcsv.)



-Dave

jc at goetc dot net
16-Jun-2004 10:51


I've had alot of projects recently dealing with csv files, so I created the following class to read a csv file and return an array of arrays with the column names as keys. The only requirement is that the 1st row contain the column headings. 





I only wrote it today, so I'll probably expand on it in the near future. 





<?php


class CSVparse


  {


  var $mappings = array();





  function parse_file($filename)


    {


    $id = fopen($filename, "r"); //open the file


    $data = fgetcsv($id, filesize($filename)); /*This will get us the */


                                               /*main column names */





    if(!$this->mappings)


       $this->mappings = $data;





    while($data = fgetcsv($id, filesize($filename)))


        {


         if($data[0])


           {


            foreach($data as $key => $value)


               $converted_data[$this->mappings[$key]] = addslashes($value);


            $table[] = $converted_data; /* put each line into */


             }                                 /* its own entry in    */


         }                                     /* the $table array    */


    fclose($id); //close file


    return $table;


    }


  }


?>

dawa at did-it dot com
12-Apr-2004 02:30


The following modification will hide the unnecessary delimiter in the array


that is returned when fgetcsvfromline is called. 





<?php


function fgetcsvfromline ($line, $columnCount, $delimiterChar = ',',


                $enclosureChar = '"') {


        global $regExpSpecialChars;


        $matches = array();


        $delimiterChar = strtr($delimiterChar, $regExpSpecialChars);


        $enclosureChar = strtr($enclosureChar, $regExpSpecialChars);


        $cutpoint = strlen($delimiterChar)+1;


        $regExp = "/^";


        for ($i = 0; $i < $columnCount; $i++) {


                $regExp .= $enclosureChar.'?(.*?)'.$enclosureChar.'?'.$delimiterChar;


        }


        $regExp = substr($regExp,0,-$cutpoint).'/';


        if (preg_match($regExp, $line, $matches)) {


                return $matches;


        }


        return 0;


}


?>





=== If you were getting 


[0] => "Ma"rk","Bergeron","rocks","12345,"times"


[1] => "


[2] => Ma"rk


[3] => " 


..etc 





You will now get 


 [0] => "Ma"rk","Bergeron","rocks","12345,"times"


 [1] => Ma"rk


...etc

bu at orbitel dot bg
18-Mar-2004 10:54


I found a way to parse CSVs with Perl RegExps and it's a lot faster and more efficient than the conventional fgetcsv() way.





The fgetcsv() took more than 2 minutes to parse a 15,000 lined file while my function takes 6 to 7 secs on a Celeron 366 MHz prehistoric machine.





Here's a link to the source of my function. 





fgetcsvfromline() source


http://bu.orbitel.bg/fgetcsvfromline.php





fgetcsvfromline() in action


http://bu.orbitel.bg/csv.php





Please let me know if you use it or if you've found a better solution.

Dave Meiners
04-Feb-2004 10:37


using the example above with a length of 1000 will truncate any csv rows longer than 1000 bytes, the remainder of that line will be represented next time you call $data = fgetcsv(). one solution i have seen to this is to use filesize("test.csv") as the length argument, however sometimes with large csv files you may encounter errors for exceeding the memory limit. to remedy this, i have read the csv file into an array, looping through that array to find the longest line in the csv, and then using that value as my length argument, unset($array) to free up the memory. im open to better solutions.



<?php



    $length = 1000;

    $array = file("test.csv");

    for($i=0;$i<count($array);$i++)

    {

        if ($length < strlen($array[$i]))

        {

            $length = strlen($array[$i]);

        }

    }

    unset($array);



    $handle = fopen("test.csv", "r");

    while ($data = fgetcsv($handle, $length, ",")) 

    {

        // do what you want with your array here.



    }

    fclose($handle);



?>

guntars at datapro dot lv
27-Nov-2003 07:24


For all those people struggling with Macintosh conversions, since PHP 4.3 there is a new runtime setting available:

auto_detect_line_endings boolean 



When turned on, PHP will examine the data read by fgets() and file() to see if it is using Unix, MS-Dos or Macintosh line-ending conventions. 



This enables PHP to interoperate with Macintosh systems, but defaults to Off, as there is a very small performance penalty when detecting the EOL conventions for the first line, and also because people using carriage-returns as item separators under Unix systems would experience non-backwards-compatible behaviour.

mjwilco at yahoo dot com
01-Oct-2003 10:35


Here's one way to convert the data in a csv file to an html table:



<?php



$filename = "book1.csv"; //here's the filename



$id = fopen($filename, "r"); //open the file

while ($data = fgetcsv($id, filesize($filename))) //start a loop

$table[] = $data; //put each line into its own entry in the $table array

fclose($id); //close file



echo "<table>\n";



foreach($table as $row)

{

echo "<tr>";

    foreach($row as $data)

    echo "<td>$data</td>";

echo "</tr>\n";

}



echo "</table>\n";



?>



You may need to change the parameters for fgetcsv() to suit your needs and probably change the table style.

elainy at gmx dot net
01-Oct-2003 07:54


I wrote this little thingy to allow the customer to upload csv-files to his page which will then automatically be converted to a php-include-file with a html-table for inclusion in his homepage.


Its a little buggy since it can't handle rowspan and such, but otherwise it works well.





<?php


function csv2php($filename, $delim=';',$path)


{


    $row = 0;


    $dump = array();


    $once = 0;


    $max_cols = 0;





    // open file - get number of columns - make data Array


    $f = fopen ($filename,"r");


    $size = filesize($filename)+1;


    while ($data = fgetcsv($f,$size,$delim,''))


    {


        for($o=0;$o<sizeof($data);$o++)


        {


             if($once==0)


                 $max_cols++;


        }





        $dump[$row] = $data;


        if($once==0)


            $once=1;


        $row++;


    }


    fclose ($f);





    /////// make text for php-include file


    $printtext="<table border='0' cellspacing='0' cellpadding='0'>\n";





    /////// walk the rows


    for($x=0;$x<sizeof($dump);$x++)


    {


         $printtext.="<tr>\n";


         /////// !!!! Table is built with as many columns as the first row has !!!!!!


         for($y=0,$limiter=0;(($y<sizeof($dump[$x])) || ($limiter<$max_cols));$y++,$limiter++)


         {


              $printtext.="\t<td>";


              if($dump[$x][$y]!='')


                  $printtext.=$dump[$x][$y];


              else


                  $printtext.=" ";


              $printtext.="</td>\n";


         }


         $printtext.="</tr>\n";


    }


    $printtext.="</table>\n";





    $ident = write_dammit($printtext,$path);





    return $ident;


}





function write_dammit($printtext,$path)


{


         $ident=time();


         $filename=$ident;


         $filename .= ".inc.php";


         $filecontents = $printtext;


         $fp = fopen("$path/$filename","w"); // if in windows you have to chace the / to \\


         fwrite($fp,$filecontents);


         fclose($fp);





         return $ident;


}





$ident = csv2php("table.csv",";","C:/your_include_folder/");





require($ident.".inc.php");


?>

chery79 at hushmail dot com
20-Sep-2003 04:18


inserting IP-to-Country Database into mysql



<?

//CREATE TABLE `ip2country` (

// `id` int(25) NOT NULL default '0',

//  `ipFrom` int(15) NOT NULL default '0',

//  `ipTo` int(15) NOT NULL default '0',

//  `country2` char(2) NOT NULL default '',

//  `country3` char(3) NOT NULL default '',

//  `country` varchar(25) NOT NULL default ''

//) TYPE=MyISAM;



$link = mysql_connect("localhost", "username", "password") or die("Could not connect: ".mysql_error());

// username = user account name

// password = password to user acc

$db = mysql_select_db("ip2country") or die(mysql_error());

// ip2country table is define on top

$row = 1;

$handle = fopen ("ip-to-country.csv","r");

// ip-to-country.csv must be in the same directory with this php file

while ($data = fgetcsv ($handle, 1000, ",")) {

    $query = "INSERT INTO ip2country(`id`, `ipFrom`, `ipTo`, `country2`, `country3`, `country`) VALUES('".

        $row."', '".$data[0]."', '".$data[1]."', '".$data[2]."', '".$data[3]."', '".$data[4]."')";

    $result = mysql_query($query) or die("Invalid query: " . mysql_error().__LINE__.__FILE__);

    $row++;

}

fclose ($handle);

?>

phpnet at smallfryhosting dot co dot uk
18-Sep-2003 11:42


Another version [modified michael from mediaconcepts]





<?php


  function arrayFromCSV($file, $hasFieldNames = false, $delimiter = ',', $enclosure='') {


    $result = Array();


    $size = filesize($file) +1;


    $file = fopen($file, 'r');


    #TO DO: There must be a better way of finding out the size of the longest row... until then


    if ($hasFieldNames) $keys = fgetcsv($file, $size, $delimiter, $enclosure);


    while ($row = fgetcsv($file, $size, $delimiter, $enclosure)) {


        $n = count($row); $res=array();


        for($i = 0; $i < $n; $i++) {


            $idx = ($hasFieldNames) ? $keys[$i] : $i;


            $res[$idx] = $row[i];


        }


        $result[] = $res;


    }


    fclose($file);


    return $result;


  }


?>

NOSPAM-michael at mediaconcepts dot nl
15-Sep-2003 09:45


A little contribution to make it more easy to use this function when working with a database. I noticed this function doesn't add logical keys to the array, so I made a small function which creates a 2dimensional array with the corresponding keys added to the rows.





<?php


// this function requires that the first line of your CSV file consists of the keys corresponding to the values of the other lines


function convertCSVtoAssocMArray($file, $delimiter)


{


    $result = Array();


    $size = filesize($file) +1;


    $file = fopen($file, 'r');


    $keys = fgetcsv($file, $size, $delimiter);


    while ($row = fgetcsv($file, $size, $delimiter))


    {


        for($i = 0; $i < count($row); $i++)


        {


            if(array_key_exists($i, $keys))


            {


                $row[$keys[$i]] = $row[$i];


            }


        }


        $result[] = $row;


    }


    fclose($file);


return $result;


}


?>

ng4rrjanbiah at rediffmail dot com
08-Sep-2003 05:02


Important note about the CSV format:

There should *not* be any space in between the fields. For example,

field1, field2, field3 [Wrong!]

field1,field2,field3 [Correct-No space between fields]



If you add space between the fields, MS Excel won't recognize the fields (especially date and multi-line text fields).



HTH,

R. Rajesh Jeba Anbiah

shaun at linuxhost dot cc
15-Aug-2003 02:03


I've seen alot of people talking about ways to convert from mac to unix or from dos to unix.



For DOS to UNIX I use dos2unix in the "tofrodos Ver 1.4" package.

http://www.thefreecountry.com/tofrodos/index.shtml

For Mac to UNIX I have the follwing in my .bashrc

alias mac2unix="perl -pi -e 'tr/\015/\012/'"

Just run dos2unix or mac2unix <filename> and it will convert.  My life has been easier ever since I started installing these utilities.

reptileX at example dot com
12-Aug-2003 02:57


beware of using this function in two different php versions, 



in php 4.3 the 4th parameter can be given altough empty



in php 4.2 you get just a warning but it is not able to read the csv file if you place an enclosure that is empty

brian at brianvoss dot com
25-Jul-2003 05:55


If anyone else is taking on the task of converting from FileMaker Pro to MySQL, you might find this useful:





Here's a collection of simple functions that take a CSV file, re-formats the data and writes to a file with MySQL INSERTs.  





ORIGINAL DATA:





"1", "foo", "2"


"3", "bar", "4"





OUTPUT





INSERT info mysql_table VALUES('', '1', 'foo', '2');


INSERT info mysql_table VALUES('', '3', 'bar', '4');





For simple data it works alright, but I could not find a way to escape the contents before assembling the INSERT statements - kept getting "bad argument for implode()"...





<?php


/*************************************


*                  main              *


*************************************/





 $file = "path/to/your/file.txt";


 $tbl = "your_MySQL_table";





 $CSVarray = get_csv($file);


 $CSVarray = makeINSERTS($CSVarray, "$tbl");


    


 $filetowrite = $_POST["file"]."_sql.txt";


    $fp = fopen($filetowrite, "w");


    while (list($key, $val) = @each($CSVarray)) {


              fwrite($fp, $val);


 }


 fclose($fp);


 chmod($filetowrite, 0777);





 echo "File written Successfully";


    


}





/*************************************


*                  functions         *


*************************************/





// This function courtesy of drudge@phpcoders.net





function get_csv($filename, $delim =","){





    $row = 0;


    $dump = array();


    


    $f = fopen ($filename,"r");


    $size = filesize($filename)+1;


    while ($data = fgetcsv($f, $size, $delim)) {


        $dump[$row] = $data;


        //echo $data[1]."<br>";


        $row++;


    }


    fclose ($f);


    


    return $dump;


}





function makeINSERT($text, $table){





    $insert = array();


    $i = 0;


        


    while (list($key, $val) = @each($text)){





// We'll start off the INSERT with '', for an


//     auto-incremented key.  Remove if not needed.


        


            $insert[$i] = "INSERT into ".$table." VALUES('','";


            $insert[$i] .= implode("','", $val);


            $insert[$i] .= "');\n";


            


            $i++;


        }


        


    return $insert;





}


?>

kurtnorgaz at web dot de
21-Jul-2003 02:00


You should pay attention to the fact that "fgetcsv" does remove leading TAB-chars "chr(9)" while reading the file.



This means if you have a chr(9) as the first char in the file and you use fgetcsv this char is automaticaly deleted.



Example:

file content:

chr(9)first#second#third#fourth



source:

$line = fgetcsv($handle,500,"#");



The array $line looks like:

$line[0] = first

$line[1] = second

$line[2] = third

$line[3] = fourth



and not

$line[0] = chr(9)first

$line[1] = second

$line[2] = third

$line[3] = fourth



All chr(9) after another char is not deleted!



Example:

file content:

Achr(9)first#second#third#fourth



source:

$line = fgetcsv($handle,500,"#");



The array $line looks like:

$line[0] = Achr(9)first

$line[1] = second

$line[2] = third

$line[3] = fourth

php at joestump dot net
14-Jul-2003 09:58


For those of you having problems with Excel's version of CSV file exports (which include the infamous ^M characters in *NIX editors, such as VIM) here is a simple script to remove them and replace them in the normal UNIX newline character (\n). 



<?



$fp = fopen('/dev/stdin','r');

while(!feof($fp)){

    $line = chop(fgets($fp,4096));

    $ret = ereg_replace(chr(13) . chr(10),"\n",$line);

    $ret = ereg_replace(chr(13),"\n",$ret);



    echo $ret."\n";

}



fclose($fp);



?>



Usage: cat file_with_windows_newlines | php -q strip_newlines.php > outfile



(this works for other stuff too, like PHP "coders" who use Notepad and upload to a UNIX environment).

kyle at kghspam at yahoo.com
17-Jun-2003 06:05


Quick and dirty script to take a csv file and turn it into a multidimensional associative array structure using the first line of the csv as the hash key names.



<?

$i = 0;

$handle = fopen ("file.csv","r");

while($data = fgetcsv ($handle, 1000, ",")) {

if ($i == 0) { $key_arr = $data; }

reset($key_arr);

while(list($index,$name) = each($key_arr)) { $temp_arr[$name] = $data[$index]; }

$result_arr[$i] = $temp_arr;

$i++;

}

fclose ($handle);

?>

drudge at php-coders dot net
08-Jun-2003 06:14


Here is a function to read a whole csv file into an array:





<?php


function get_csv($filename, $delim=',')


{


    $row = 0;


    $dump = array();


    


    $f = fopen ($filename,"r");


    $size = filesize($filename)+1;


    while ($data = fgetcsv($f, $size, $delim)) {


        $dump[$row] = $data;


        $row++;


    }


    fclose ($f);


    


    return $dump;


}


?>

kmlinac/nospam/ at oliver dot /nospam/efos dot hr
09-May-2003 04:12


This is the solution to Microsoft Excel csv file - this function add last delimiter in line.



<?php

function delimiter()

{

if (is_file("file.csv"))

    {

$fp = fopen($file.csv,"r");

while (false!=($line = fgets($fp)))

        {

                  $line = "$line;";

                  putf($line);

                    }

fclose($fp);

    }

}



//puts dedlimited line in new file

function putf($line)

    {

$fp = fopen($file,"a");

fputs($fp,$line);

fclose($fp);

    }



/* this readsl line at the time and adds ; as delimiter on line end. Its easy and helpfull*/



delimiter();



?>

mendi dot susanto at dmetrading dot com
21-Mar-2003 03:07


I've tried the code above but doesn't work, so I tried to modify it... this is the code to get the first line of csv fle, puti it into TABLE 1, while the rest line of csv file will be put at TABLE 2





<?php


$openfile = "tes2.csv";


$row = 0;


$handle = fopen ($openfile,"r");


while ($data = fgetcsv ($handle, 1000, ",")) 


{


    if($row == '0')


    {


        $num = count ($data);


        print "<p> $num fields in line $row: <br>\n";


        echo "This belong to TABLE 1 <br>";


        for ($c=0; $c < $num; $c++) 


        {


            print $data[$c] . "<br>\n";


        }


        $row = '32';


    }


    else


    {


        $num = count ($data);


        print "<p> $num fields in line $row: <br>\n";


        $row++;


        echo "This belong to TABLE 2 <br>";


        for ($c=0; $c < $num; $c++) 


        {


            print $data[$c] . "<br>\n";


        }


    }


}


fclose ($handle);


?>

17-Feb-2003 01:23


Here's piece of code I wrote that reads the first line of a CSV file, creates an array based the field's name, and then reads the rest of the contents of the CSV file into the approate arrays.  Great for quick and dirty access to a CSV file.



<?php

// Name of the file to read/

// $openFile is the only varible you will have change to for this to work. 

$openFile = "test.csv";



    $row = 0;

    $handle = fopen ($openFile,"r");

    while ($data = fgetcsv ($handle, 1000, ",")) {

        if($row == 0){

            // set the varible array

            $num = count ($data);

            $csvNames = array();

            for ($c=0; $c < $num; $c++) {

                $csvNames[$c] = $data[$c];

                eval("$" . $data[$c] . " = array();");

            }

            $row = 1;

        }else{

            $num = count ($data);

            $row++;

            for ($c=0; $c < $num; $c++) {

                $buildEval = "$" . $csvNames[$c] . "[" . ($row - 1) . "] = \"" . $data[$c] . "\";";

                eval($buildEval );

            }

        }

    }

    fclose ($handle);



?>

anthony dot thomas at nospam dot com
06-Dec-2002 11:29


fgetcsv stops reading your file?



I had to write a script to validate and import a large amount of data to MySQL and it would stop running. I've noticed, after trawling the internet for a solution, quite a few people have had similar problems.



Solution? Like a dope I had forgotten to put in 

set_time_limit() 

within a loop. Otherwise the script would time out before it finished importing all the data.



Moral of the story? Only suppress errors after your script works with a large amount of test data!

php at dogpoop dot cjb dot net
15-Nov-2002 10:01


This function takes a csv line and splits it into an array, much like fgetcsv does but you can use it on data that isn't coming in from a file, or you can read data from a file some other way (like if your Mac files aren't being read correctly) and use this to split it.  If you have any corrections, comments (good or bad), etc. I would appreciate an email to the above address.





<?php


function csv_split($line,$delim=',',$removeQuotes=true) {


#$line: the csv line to be split


#$delim: the delimiter to split by


#$removeQuotes: if this is false, the quotation marks won't be removed from the fields


    $fields = array();


    $fldCount = 0;


    $inQuotes = false;


    for ($i = 0; $i < strlen($line); $i++) {


        if (!isset($fields[$fldCount])) $fields[$fldCount] = "";


        $tmp = substr($line,$i,strlen($delim));


        if ($tmp === $delim && !$inQuotes) {


            $fldCount++;


            $i += strlen($delim)-1;


        } else if ($fields[$fldCount] == "" && $line[$i] == '"' && !$inQuotes) {


            if (!$removeQuotes) $fields[$fldCount] .= $line[$i];


            $inQuotes = true;


        } else if ($line[$i] == '"') {


            if ($line[$i+1] == '"') {


                $i++;


                $fields[$fldCount] .= $line[$i];


            } else {


                if (!$removeQuotes) $fields[$fldCount] .= $line[$i];


                $inQuotes = false;


            }


        } else {


            $fields[$fldCount] .= $line[$i];


        }


    }


    return $fields;


}


?>

martin dot goldinger at netserver dot ch
28-Oct-2002 08:12


With MAC, use: Save As - CSV for Windows. Then fgetcsv works as expected.

justin at indent dot com dot au
08-Aug-2002 02:24


If you're working in Excel on a Mac and are exporting a spreadsheet as a CSV, PHP won't recognise the line breaks, and interprets the file as one really long line.  It borders on a bug really.  For me, I just open the file in BBEdit or BBEdit Lite, convert the file from Mac to Unix, and all is well.  But if you're dealing with user-contributed files, you'll need to convert the line-endings first... replacing all \r's with \n's should do it.

c dot greenNOSP at Mits dot uq dot edu dot au
23-Jun-2002 10:21


Quoting csv is pretty simple, and there are two steps..I note in previous comments only the second step has been explained.



First fields with double quotes need to double up the quotes, ie _He said "Timmy"..._ should become _He said ""Timmy""..._

Secondly as mentioned above, fields with commas need double quotes.



Here is a simple function to achieve this, that I pass to array walk, if you want to use it somewhere else, prob get rid of reference and return the value.



function check_csv_field_ref(&$item) {

   $item = str_replace('"', '""', $item);

   if (strpos($item, ",") !== FALSE) {

     $item = '"' . $item . '"';

   }

}

joeldegan-AT-yahoo.com
12-Jun-2002 03:01


function to parse multi arrays into csv data


array in... array of array(datasets); first dataset = field names.


usage: 


$toparse[0][0] = "field1";


$toparse[0][1] = "field2";


$toparse[1][0] = "value1";


$toparse[1][1] = "123123123"; // to see


echo export_to_csv($toparse);





<?php


function export_to_csv($inarray){


      while (list ($key1, $val1) = each ($inarray)) {


        while (list ($key, $val) = each ($val1)) {


          if (is_numeric($val)){


        $sendback .= $val.",";


           }else{


            $sendback .= "\"". $val ."\",";


          }//fi


        }//wend


        $sendback = substr($sendback, 0, -1); //chop last ,


        $sendback .= "\n";


      }//wend


    return ($sendback);


}// end function


?>





send the file to the client.. pretty simple.


usage: send_file_to_client("data.csv",export_to_csv($data));





<?php


function send_file_to_client($filename, $data){


    header("Content-type: application/ofx");


    header("Content-Disposition: attachment; filename=$filename");


    echo $data;    


};


?>

blair at squiz . net
14-Aug-2001 09:19


Here is a function that takes an array and adds a CSV line to the passed file pointer.





<?php


function fputcsv ($fp, $array, $deliminator=",") {





  $line = "";


  foreach($array as $val) {


    # remove any windows new lines, 


    # as they interfere with the parsing at the other end


    $val = str_replace("\r\n", "\n", $val);





    # if a deliminator char, a double quote char or a newline 


    # are in the field, add quotes


    if(ereg("[$deliminator\"\n\r]", $val)) {


      $val = '"'.str_replace('"', '""', $val).'"';


    }#end if





    $line .= $val.$deliminator;





  }#end foreach





  # strip the last deliminator 


  $line = substr($line, 0, (strlen($deliminator) * -1));


  # add the newline 


  $line .= "\n";





  # we don't care if the file pointer is invalid, 


  # let fputs take care of it


  return fputs($fp, $line);





}#end fputcsv()


?>

fgetcsv

Description