{"id":126,"date":"2021-03-08T00:25:06","date_gmt":"2021-03-08T00:25:06","guid":{"rendered":"https:\/\/phptutorial.net\/?page_id=126"},"modified":"2021-07-20T13:11:15","modified_gmt":"2021-07-20T13:11:15","slug":"php-csv","status":"publish","type":"page","link":"https:\/\/www.phptutorial.net\/php-tutorial\/php-csv\/","title":{"rendered":"PHP CSV"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to deal with CSV files in PHP, including creating and reading CSV files.<\/p>\n\n\n\n

A quick introduction to CSV files #<\/a><\/h2>\n\n\n\n

CSV stands for comma-separated values. A CSV file is a text file that stores tabular data in the form of comma-separated values. A CSV file stores each record per line. And it may have a header.<\/p>\n\n\n\n

When you open a CSV file using a spreadsheet application, you’ll see that the file is nicely formatted like this:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

However, if you view the CSV file in a text editor, it looks like the following:<\/p>\n\n\n

Symbol,Company,Price\nGOOG,\"Google Inc.\",800\nAAPL,\"Apple Inc.\",500\nAMZN,\"Amazon.com Inc.\",250\nYHOO,\"Yahoo! Inc.\",250\nFB,\"Facebook, Inc.\",30<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
Typically, a CSV file uses a comma (,<\/code>) to separate fields in a CSV file. If the field content also contains a comma(,<\/code>), the CSV file surrounds that field with double quotes, e.g., “Facebook, Inc..” <\/p>\n\n\n\n
Besides using the comma (,<\/code>) character, a CSV file may use other characters to separate fields such as semicolon (;<\/code>).<\/p>\n\n\n\n
Writing to a CSV file #<\/a><\/h2>\n\n\n\n
To write a line to a CSV file, you use the fputcsv()<\/code> function:<\/p>\n\n\n
fputcsv ( resource $handle , array<\/span> $fields , string $delimiter = \",\"<\/span> , string $enclosure = '\"'<\/span> , string $escape_char = \"\\\\\"<\/span> ) : int|false<\/span><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
The following example uses the fputcsv()<\/code> function to write data to a CSV file:<\/p>\n\n\n
<?php<\/span>\n\n$data = [\n\t['Symbol'<\/span>, 'Company'<\/span>, 'Price'<\/span>],\n\t['GOOG'<\/span>, 'Google Inc.'<\/span>, '800'<\/span>],\n\t['AAPL'<\/span>, 'Apple Inc.'<\/span>, '500'<\/span>],\n\t['AMZN'<\/span>, 'Amazon.com Inc.'<\/span>, '250'<\/span>],\n\t['YHOO'<\/span>, 'Yahoo! Inc.'<\/span>, '250'<\/span>],\n\t['FB'<\/span>, 'Facebook, Inc.'<\/span>, '30'<\/span>],\n];\n\n$filename = 'stock.csv'<\/span>;\n\n\/\/ open csv file for writing<\/span>\n$f = fopen($filename, 'w'<\/span>);\n\nif<\/span> ($f === false<\/span>) {\n\tdie<\/span>('Error opening the file '<\/span> . $filename);\n}\n\n\/\/ write each row at a time to a file<\/span>\nforeach<\/span> ($data as<\/span> $row) {\n\tfputcsv($f, $row);\n}\n\n\/\/ close the file<\/span>\nfclose($f);<\/span><\/code><\/span>Code language:<\/span> HTML, XML<\/span> (<\/span>xml<\/span>)<\/span><\/small><\/pre>\n\n\n
How it works.<\/p>\n\n\n\n