Read the contents of CSV file based on PHP

Read data from all rows in a CSV file at once

<?php $file = fopen (' windows_2011_s.csv ', ' R '); while ($data = Fgetcsv ($file)) {//reads a single line of content//print_r ($data) per CSV;//This is an array, to get each data, access the array subscript can $goods_list[] = $data;} Print_r ($goods _list);/* foreach ($goods _list as $arr) {    if ($arr [0]!= "") {        echo $arr [0]. " <br> ";    }} */Echo $goods _list[2][0]; Fclose ($file);? >

Reads a row of data from a CSV file

<?phpfunction Get_file_line ($file _name, $line) {  $n = 0;  $handle = fopen ($file _name, ' R ');  if ($handle) {    while (!feof ($handle)) {        + + $n;        $out = Fgets ($handle, 4096);        if ($line = = $n) break;    }    Fclose ($handle);  }  if ($line = = $n) return $out;  return false;} Echo get_file_line ("Windows_2011_s.csv", 10);? >

Read CSV file number of rows (line interval)

<?phpfunction Get_file_line ($file _name, $line _star,  $line _end) {    $n = 0;    $handle = fopen ($file _name, "R");    if ($handle) {        while (!feof ($handle)) {            + + $n;            $out = Fgets ($handle, 4096);            if ($line _star <= $n) {                $ling [] = $out;            }            if ($line _end = = $n) break;        }        Fclose ($handle);    }    if ($line _end== $n) return $ling;    return false;} $AA = Get_file_line ("Windows_2011_s.csv", one, one);  From line 11th to line 20th, foreach ($aa as $BB) {    echo $bb.

In addition to find two methods from the Internet (no test, do not know good or bad to make)

< $handle =fopen ("1.csv", "R"), while (!feof ($handle)) {$buffer =fgetss ($handle, 2048); $data =explode (",", $buffer); $num =count ($data); for ($i =0; $i < $num; $i + +) {Print_r ($data);}}? >

<? $handle =fopen ("1.csv", "R"); $row =1;while ($data =fgetcsv ($handle, 1000, " , ")) {$num =count ($data); for ($i =0; $i < $num; $i + +) {echo $data [$i];} $row + +;}?