开发者

getting null values while reading from csv file

开发者 https://www.devze.com 2023-02-09 16:17 出处:网络
I have a csv file which has a word for each row like this word1 word2 word3 And have the following code to read the data:

I have a csv file which has a word for each row like this

word1
word2
word3

And have the following code to read the data:

$arr = array();
$fh = fopen('path/to/file', 'r');
while (($rows = fgetcsv($fh)) !== false) {
 print_r($rows);
 if (!in_array($rows[0], $arr))
  $arr[] = "'".trim($rows[0])."'";
}
fclose($fh);
print_r($arr);

The problem is im getting empty strings/null for $rows[0] and im quite sure the data is there.

Array ( [0] => )
Array ( [0]开发者_如何学运维 => )
Array ( [0] => )

Array ( [0] => '' [1] => '' [2] => '' [3] => '' )

Any help would be greatly appreciated.


You're trying to read the words into an array? Replace all that with just:

$arr = file('/path/to/file');
print_r($arr);


Cannot reproduce. I'm assuming there is something wrong with your file format. Most likely there is an empty line on top (which I'm not quite sure, but might fail the !== false test).

Better try:

$arr = array_map("str_getcsv", file("words.csv"));
print_r($arr);

And if you need to re-add the quotes, do a separate loop.


The file reading part has already been answered, but about your loop to add the quotes, you could use array_walk():

function add_quotes(&$item)
{
    $item = "'" . $item . "'";
}

array_walk($arr, "add_quotes");
0

精彩评论

暂无评论...
验证码 换一张
取 消