How to parse CSV strings? Use the PHP built-in function str_getcsv() to parse CSV strings into arrays, supporting the setting of separators, wrappers and escape characters; when processing fields with quotes and line breaks, str_getcsv() can automatically recognize and parse correctly; the difference from fgetcsv() is that the latter is used for file reading, while str_getcsv() directly processes strings; in actual applications, you can first split multi-behavior arrays and then process them line by line, combining array_map and exploit to improve efficiency. If you need to associate the array, you can manually merge the title rows and data rows.

Parsing CSV strings is a common requirement in PHP, such as processing CSV content uploaded from a form or CSV data received by the API. str_getcsv() is a very convenient built-in function that parses well-formed CSV strings into arrays without manually opening the file.

Understand the basic usage of str_getcsv()

str_getcsv() function takes a CSV format string and parses it into a one-dimensional or two-dimensional array (depending on whether the input contains multiple lines). It has several optional parameters for controlling separators, encapsulation characters, and escape characters.

 array str_getcsv ( string $input , string $delimiter = "," , string $enclosure = '"' , string $escape = "\\" )

• $input : The CSV string to parse.
• $delimiter : The delimiter between fields, the default is a comma , .
• $enclosure : The encapsulation symbol of the field, the default is double quotes " .
• $escape : escape character, default is backslash \ .

For example:

 $csvString = 'name,age,city
John,25,"New York"
Alice,30,"San Francisco"';

$rows = array_map('str_getcsv', exploit("\n", $csvString));

// Output result:
// Array (
// [0] => Array ( [0] => name [1] => age [2] => city )
// [1] => Array ( [0] => John [1] => 25 [2] => New York )
// [2] => Array ( [0] => Alice [1] => 30 [2] => San Francisco )
// )
print_r($rows);

How to deal with fields with quotes and line breaks

If a CSV field contains special characters (such as commas and line breaks), it is usually wrapped in double quotes. str_getcsv() can automatically identify these situations and parse them correctly.

For example:

 $csvString = 'id,message
1,"This is a message with, comma and
a line break inside quotes"';

The above CSV contains a field with commas and newlines, but since it is wrapped in double quotes, str_getcsv() can still correctly handle it as a complete field.

It should be noted that if the fields in the CSV are not wrapped correctly, or the quotes are used inconsistently, it may lead to parsing errors. So it is important to ensure that the original data format is standardized.

Combining the difference between fgetcsv() and str_getcsv()

If you are working on files instead of strings, you will usually use fgetcsv() . But if you get a string (such as a POST submission or API request), str_getcsv() is more appropriate.

Their main differences are:

• fgetcsv() is used to read a line from a file pointer and parse it;
• str_getcsv() acts directly on the string and does not need to open the file.

For simple string parsing, str_getcsv() is lighter and more flexible.

A few tips in practical applications

• If there are multiple lines in the CSV string, it is recommended to split it into an array first with explode("\n", $csvString) and then process it line by line.
• If you are not sure what the delimiter is, you can try passing in common options tests such as tab \t or semicolon ; .
• If you want to convert each row into an associative array (keynamed with the first row), you can manually merge it after parsing:

 $headers = array_shift($rows); // Assume that the first behavior header line $data = array_map(function ($row) use ($headers) {
    return array_combine($headers, $row);
}, $rows);

Although this step is not a feature that comes with str_getcsv() , it is very practical in actual development.

Basically that's it. Using str_getcsv() well can save a lot of trouble of manually processing CSV. As long as you pay attention to the input format specification, you can easily complete the parsing task.

The above is the detailed content of How to parse a CSV string in PHP with str_getcsv. For more information, please follow other related articles on the PHP Chinese website!