Read data from all rows in a CSV file at once
Copy CodeThe code is as follows:
$file = fopen (' windows_2011_s.csv ', ' R ');
while ($data = Fgetcsv ($file)) {//reads a row of CSV each time
Print_r ($data); This is an array, to get every data, access the array subscript can
$goods _list[] = $data;
}
Print_r ($goods _list);
/* foreach ($goods _list as $arr) {
if ($arr [0]!= "") {
echo $arr [0]. "
";
}
} */
echo $goods _list[2][0];
Fclose ($file);
?>
Reads a row of data from a CSV file
Copy CodeThe code is as follows:
function 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)
Copy CodeThe code is as follows:
function 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", 11, 20); 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)
Copy CodeThe code is as follows:
$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);
}
}
?>
Copy CodeThe code is as follows:
$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 + +;
}
?>
http://www.bkjia.com/PHPjc/327695.html www.bkjia.com true http://www.bkjia.com/PHPjc/327695.html techarticle The data copy code code for all rows in a CSV file is read once: Php $file = fopen (' windows_2011_s.csv ', ' R '), while ($data = Fgetcsv ($file)) {//per read in CSV A row of polygons ...