PHP fgetcsv() Function
 Complete PHP Filesystem Reference
Definition and Usage
The fgetcsv() function parses a line from an open file, checking for
CSV fields.
The fgetcsv() function stops returning on a new line, at the specified length,
or at EOF, whichever comes first.
This function returns the CSV fields in an array on success, or FALSE on
failure and EOF.
Syntax
|
fgetcsv(file,length,separator,enclosure)
|
| Parameter |
Description |
| file |
Required. Specifies the file to check |
| length |
Optional. Specifies the maximum length of a line. Must be
greater than the longest line (in characters) in the CSV file. Omitting this
parameter (or setting it to 0) the line length is not limited, which is
slightly slower. Note: This parameter is required in versions prior to
PHP 5 |
| separator |
Optional. A character that specifies the field separator.
Default is comma ( , ) |
| enclosure |
Optional. A character that specifies the field enclosure
character. Default is " |
Tips and Notes
Tip: Also see the fputcsv() function.
Example 1
<?php
$file = fopen("contacts.csv","r");
print_r(fgetcsv($file));
fclose($file);
?>
|
The CSV file:
Kai Jim, Refsnes, Stavanger, Norway
Hege, Refsnes, Stavanger, Norway
|
The output of the code above will be:
Array
(
[0] => Kai Jim
[1] => Refsnes
[2] => Stavanger
[3] => Norway
)
|
Example 2
<?php
$file = fopen("contacts.csv","r");
while(! feof($file))
{
print_r(fgetcsv($file));
}
fclose($file);
?>
|
The CSV file:
Kai Jim, Refsnes, Stavanger, Norway
Hege, Refsnes, Stavanger, Norway
|
The output of the code above will be:
Array
(
[0] => Kai Jim
[1] => Refsnes
[2] => Stavanger
[3] => Norway
)
Array
(
[0] => Hege
[1] => Refsnes
[2] => Stavanger
[3] => Norway
)
|
Complete PHP Filesystem Reference
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data.
Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions.
New features in Version 2010!
Download a free, fully functional 30-day trial to experience the following features:
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
Download a fully-functional trial today!
|
|
|
|
