用户评论:
[#1]
scott dot chu at udngroup dot com [2015-10-07 15:49:21]
Martin K.'s post quoted: "If the file you are reading is in CSV format do not use file(), use fgetcsv(). file() will split the file by each newline that it finds, even newlines that appear within a field (i.e. within quotations).". He is right. However, in my case, fgetcsv has problem on dealing with Chinese characters, so I can't use it either.
I'm currently trying to figure out how to read in a csv line that has linefeed character in some field's contents from a csv file pleasantly though there are some ugly ways to do it.
[#2]
Martin K. [2014-08-05 16:38:20]
If the file you are reading is in CSV format do not use file(), use fgetcsv(). file() will split the file by each newline that it finds, even newlines that appear within a field (i.e. within quotations).
[#3]
marco dot remy at aol dot com [2014-06-17 07:54:23]
Here's my CSV converter
supports Header and trims all fields
Note: Headers must be not empty!
returnfalse;# Read lines of file to array$file_lines=file($file,FILE_IGNORE_NEW_LINES|FILE_SKIP_EMPTY_LINES);# Empty fileif($file_lines=== array())
returnNULL;# Read headers if you want toif($header===true) {$line_header=array_shift($file_lines);$array_header=array_map('trim',str_getcsv($line_header,$delim,$encl));
}$out=NULL;# Now line per line (strings)foreach ($file_linesas$line) {# Skip empty linesif(trim($line) ==='')
continue;# Convert line to array$array_fields=array_map('trim',str_getcsv($line,$delim,$encl));# If header present, combine header and fields as key => valueif($header===true)$out[] =array_combine($array_header,$array_fields);
else$out[] =$array_fields;
}
return$out;
}?>
[#4]
Anonymous [2013-12-25 16:31:35]
("file()'s problem with UTF-16" is wrong. This is updated.
The former may miss the last line of the string.)
file() seems to have a problem in handling
UTF-16 with or without BOM.
file() is likely to think "\n"=LF (0A) as a line-ending.
So, not only "000A" but also "010A, 020A,...,FE0A, FF0A,..."
are regarded as line-endings.
Moreover, file() causes a serious problem in UTF-16LE.
file() loses first "0A" (the first half of "0A00")!
And the next line begins with "00" (the rest of "0A00").
So lines after the first "0A" are totally different.
To avoid this phenomena,
eg. in case (php_script : UTF-8 , file : UTF-16 with line-ending "\r\n"),
mb_regex_encoding('UTF-16');// to help mb_ereg_..() work properly$str=file_get_contents($file_path);$to_encoding='UTF-16';// encoding of string$from_encoding='UTF-8';// encoding of PHP_script$pattern1=mb_convert_encoding('[^\r]*\r\n',$to_encoding,$from_encoding);mb_ereg_search_init($str,$pattern1);
while ($res=mb_ereg_search_regs()) {$file[] =$res[0];
}$pattern2=mb_convert_encoding('\A.*\r\n(.*)\z',$to_encoding,$from_encoding);mb_ereg($pattern2,$str,$match);$file[] =$match[1];?>
instead of
$file = file($file_path);
If line-ending is "\n",
$pattern1 = mb_convert_encoding('[^\n]*\n', $to_encoding, $from_encoding);
[#5]
bingo at dingo dot com [2013-10-14 12:36:50]
To write all the lines of the file in other words to read the file line by line you can write the code like this:
$names=file('name.txt');// To check the number of linesechocount($names).'
';
foreach($namesas$name)
{
echo$name.'
';
}?>
this example is so basic to understand how it's working. I hope it will help many beginners.
Regards,
Bingo
[#6]
twichi at web dot de [2011-09-13 12:33:51]
read from CSV data (file) into an array with named keys
... with or without 1st row = header (keys)
(see 4th parameter of function call as true / false)
if ($head===true) {$anzdata=count($csvxrow);$z=0;
for($x=1;$x
foreach($keydataas$key) {$out[$z][$key] =$csv_data[$x][$i];$i++;
}$z++;
}
}
else {$i=0;
foreach($csvxrowas$item) {$item=chop($item);$item=str_replace($encl,'',$item);$csv_data=explode($delm,$item);
for ($y=0;$y
}$i++;
}
}
return$out;
}// --------------------------------------------------------------?>
fuction call with 4 parameters:
(1) = the file with CSV data (url / string)
(2) = colum delimiter (e.g: ; or | or , ...)
(3) = values enclosed by (e.g: ' or " or ^ or ...)
(4) = with or without 1st row = head (true/false)
// ----- view ------echo"
\r\n";print_r($csvdata);
echo"
\r\n";// -----------------?>PS: also see: http://php.net/manual/de/function.fgetcsv.php to read CSV data into an array
... and other file-handling methods
^
[#7]
d basin [2009-10-14 15:47:11]
this may be obvious, but it took me a while to figure out what I was doing wrong. So I wanted to share. I have a file on my "c:\" drive. How do I file() it?
Don't forget the backslash is special and you have to "escape" the backslash i.e. "\\":
$lines=file("C:\\Documents and Settings\\myfile.txt");
foreach($linesas$line)
{
echo($line);
}?>
hope this helps...
[#8]
jon+spamcheck at phpsitesolutions dot com [2008-04-16 01:03:49]
A user suggested using rtrim always, due to the line ending conflict with files that have an EOL that differs from the server EOL.
Using rtrim with it's default character replacement is a bad solution though, as it removes all whitespace in addition to the '\r' and '\n' characters.
A good solution using rtrim follows:
$line=rtrim($line,"\r\n") .PHP_EOL;?>
This removes only EOL characters, and replaces with the server's EOL character, thus making preg_* work fine when matching the EOL ($)
[#9]
vbchris at gmail dot com [2008-02-16 01:15:40]
If you're getting "failed to open stream: Permission denied" when trying to use either file() or fopen() to access files on another server. Check your host doesn't have any firewall restrictions in-place which prevent outbound connections. This is the case with my host Aplus.net
[#10]
Reversed: moc dot liamg at senroc dot werdna [2007-07-12 02:25:59]
This note applies to PHP 5.1.6 under Windows (although may apply to other versions).
It appears that the 'FILE_IGNORE_NEW_LINES' flag doesn't remove newlines properly when reading Windows-style text files, i.e. files whose lines end in '\r\n'.
Solution: Always use 'rtrim()' in preference to 'FILE_IGNORE_NEW_LINES'.
[#11]
info at carstanje dot com [2006-11-28 00:33:13]
Using file() for reading large text files > 10 Mb gives problems, therefore you should use this instead. It is much slower but it works fine. $lines will return an array with all the lines.
$handle= @fopen('yourfile...',"r");
if ($handle) {
while (!feof($handle)) {$lines[] =fgets($handle,4096);
}fclose($handle);
}?>
[#12]
justin at visunet dot ie [2003-03-20 09:36:27]
Note: Now that file() is binary safe it is 'much' slower than it used to be. If you are planning to read large files it may be worth your while using fgets() instead of file() For example:
$fd=fopen("log_file.txt","r");
while (!feof($fd))
{$buffer=fgets($fd,4096);$lines[] =$buffer;
}fclose($fd);?>
The resulting array is $lines.
I did a test on a 200,000 line file. It took seconds with fgets() compared to minutes with file().
[#13]
andrea at brancatelli dot it [2002-03-16 11:16:02]
file() has a strange behaviour when reading file with both \n and \r as line delimitator (DOS files), since it will return an array with every single line but with just a \n in the end. It seems like \r just disappears.
This is happening with PHP 4.0.4 for OS/2. Don't know about the Windows version.
扫一扫
113
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
