Example of PHP reading and processing large CSV files by line

/** * Csv_get_lines reads a few rows of data from a CSV file * @param $csvfile CSV file path * Number of rows @param $lines read * Number of start lines @param $offset * @return Array * * */bbs.it-home.org function Csv_get_lines ($csvfile, $lines, $offset = 0) { if (! $fp = fopen ($csvfile, ' R ')) { return false; } $i = $j = 0; while (false!== ($line = fgets ($fp))) { if ($i + + < $offset) { Continue } Break } $data = Array (); while (($j + + < $lines) &&!feof ($fp)) { $data [] = Fgetcsv ($FP); } Fclose ($FP); return $data; } Copy Code Call Method: $data = Csv_get_lines (' path/bigfile.csv ', 10, 2000000); Print_r ($data); Copy Code The function mainly adopts the idea of line positioning, and the file pointer positioning is achieved by skipping the number of start lines. The above function tests the files within 500M, runs smoothly, and does not test for larger files, please use them or improve them.

