Hướng dẫn dùng php fgetcsv trong PHP

[PHP 4, PHP 5, PHP 7, PHP 8]

fgetcsv — Gets line from file pointer and parse for CSV fields

Description

fgetcsv[
    resource $stream,
    ?int $length = null,
    string $separator = ",",
    string $enclosure = "\"",
    string $escape = "\\"
]: array|false

Note:

The locale settings are taken into account by this function. If LC_CTYPE is e.g. en_US.UTF-8, files in one-byte encodings may be read wrongly by this function.

Parameters

A valid file pointer to a file successfully opened by fopen[], popen[], or fsockopen[].

Must be greater than the longest line [in characters] to be found in the CSV file [allowing for trailing line-end characters]. Otherwise the line is split in chunks of length characters, unless the split would occur inside an enclosure.

Omitting this parameter [or setting it to 0, or null in PHP 8.0.0 or later] the maximum line length is not limited, which is slightly slower.

The optional separator parameter sets the field separator [one single-byte character only].

The optional enclosure parameter sets the field enclosure character [one single-byte character only].

The optional escape parameter sets the escape character [at most one single-byte character]. An empty string [""] disables the proprietary escape mechanism.

Note: Usually an enclosure character is escaped inside a field by doubling it; however, the escape character can be used as an alternative. So for the default parameter values "" and \" have the same meaning. Other than allowing to escape the enclosure character the escape character has no special meaning; it isn't even meant to escape itself.

Return Values

Returns an indexed array containing the fields read on success, or false on failure.

Note:

A blank line in a CSV file will be returned as an array comprising a single null field, and will not be treated as an error.

Note: If PHP is not properly recognizing the line endings when reading files either on or created by a Macintosh computer, enabling the auto_detect_line_endings run-time configuration option may help resolve the problem.

Changelog

Examples

Example #1 Read and print the entire contents of a CSV file

See Also

• str_getcsv[] - Parse a CSV string into an array
• explode[] - Split a string by a string
• file[] - Reads entire file into an array
• pack[] - Pack data into binary string
• fputcsv[] - Format line as CSV and write to file pointer

james dot ellis at gmail dot com ¶

13 years ago

If you need to set auto_detect_line_endings to deal with Mac line endings, it may seem obvious but remember it should be set before fopen, not after:

This will work:


This won't, you will still get concatenated fields at the new line position:


shaun at slickdesign dot com dot au ¶

4 years ago

When a BOM character is suppled, `fgetscsv` may appear to wrap the first element in "double quotation marks". The simplest way to ignore it is to progress the file pointer to the 4th byte before using `fgetcsv`.

michael dot arnauts at gmail dot com ¶

10 years ago

fgetcsv seems to handle newlines within fields fine. So in fact it is not reading a line, but keeps reading untill it finds a \n-character that's not quoted as a field.

Example:



Returns:
array[3] {
  [0]=>
  string[5] "col 1"
  [1]=>
  string[4] "col2"
  [2]=>
  string[4] "col3"
}
array[3] {
  [0]=>
  string[29] "this
is
having
multiple
lines"
  [1]=>
  string[8] "this not"
  [2]=>
  string[13] "this also not"
}
array[3] {
  [0]=>
  string[13] "normal record"
  [1]=>
  string[19] "nothing to see here"
  [2]=>
  string[7] "no data"
}

This means that you can expect fgetcsv to handle newlines within fields fine. This was not clear from the documentation.

Sbastien ¶

2 years ago

To use fgetcsv[] with a string instead of a file, you can use the data: wrapper //www.php.net/wrappers.data :

myrddin at myrddin dot myrddin ¶

16 years ago

Here is a OOP based importer similar to the one posted earlier. However, this is slightly more flexible in that you can import huge files without running out of memory, you just have to use a limit on the get[] method

Sample usage for small files:-
-------------------------------------



Sample usage for large files:-
-------------------------------------



And heres the class:-
-------------------------------------


i at camerongreen dot org ¶

4 years ago

This style is shown as an example on this page and in a number of examples on the Internet:



Note, this won't handle new lines within csv fields and thus should probably be avoided.

chris at ocproducts dot com ¶

5 years ago

This function has no special BOM handling. The first cell of the first row will inherit the BOM bytes, i.e. will be 3 bytes longer than expected. As the BOM is invisible you may not notice.

Excel on Windows, or text editors like Notepad, may add the BOM.

Tim Henderson ¶

14 years ago

Only problem with fgetcsv[], at least in PHP 4.x -- any stray slash in the data that happens to come before a double-quote delimiter will break it -- ie, cause the field delimiter to be escaped. I can't find a direct way to deal with it, since fgetcsv[] doesn't give you a chance to manipulate the line before it reads it and parses it...I've had to change all occurrences of '\"' to '" in the file first before feeding ot to fgetcsv[]. Otherwise this is perfect for that Microsoft-CSV formula, deals gracefully with all the issues.

michael dot martinek at gmail dot com ¶

13 years ago

Here's something I put together this morning. It allows you to read rows from your CSV and get values based on the name of the column. This works great when your header columns are not always in the same order; like when you're processing many feeds from different customers. Also makes for cleaner, easier to manage code.

So if your feed looks like this:

product_id,category_name,price,brand_name, sku_isbn_upc,image_url,landing_url,title,description
123,Test Category,12.50,No Brand,0,//www.example.com, //www.example.com/landing.php, Some Title,Some Description

You can do:


If you have any questions or comments regarding this class, they can be directed to as I probably won't be checking back here.



Usage :

jack dot peterson at gmail dot com ¶

11 years ago

If you receive data in the following format:

Time,Dataset1,Dataset2,
timestamp1,item 1 for dataset 1,item1 for dataset2
timestamp2,item 2 for dataset 1,item2 for dataset2

the following code will output a series of arrays grouped by column with the resulting format:
array [
[column 1 title] => array [
[timestamp1] => item1 for dataset1
[timestamp2] => item2 for dataset1
]

[column 2 title] => array [
[timestamp1] => item1 for dataset2
[timestamp2] => item2 for dataset2
]
]