Parse a CVS-like file in PHP and store it as a dictionary

Question

I have text file that I am generating that looks like this:

ipaddress,host
ipaddress,host
ipaddress,host
ipaddress,host
ipaddress,host
...

How could i read through this file and store each line as a key value pair?

ex.

array{
       [ipaddress]=>[host]
       [ipaddress]=>[host]
       [ipaddress]=>[host]
       ..........
     }

[What you have tried?](http://mattgemmell.com/2008/12/08/what-have-you-tried/) — Jason McCreary, Jan 16 '13 at 16:47
@airza, why? I wouldn't use regular expressions here, it is simple string split. — Glavić, Jan 16 '13 at 16:49
Do some of the work before you posts an easy question. At least say, "This is what I have, what am I doing wrong?" This isn't like a homework completion site. — Steve Nguyen, Jan 16 '13 at 16:51
possible duplicate of [Searching through a CSV file](http://stackoverflow.com/questions/13249018/php-searching-through-a-csv-file-the-oop-way/13287221#13287221) — Gordon, Jan 16 '13 at 17:13

score 1 · Accepted Answer · answered Jan 16 '13 at 16:50

1

$arr = file('myfile.txt');
$ips = array();

foreach($arr as $line){
  list($ip, $host) = explode(',',$line);
  $ips[$ip]=$host;
}

answered Jan 16 '13 at 16:50

dnagirl

20,196
13
80
123

score 0 · Answer 2 · answered Jan 16 '13 at 16:51

0

For a simple solution:

<?php
    $hosts = file('hosts.txt', FILE_SKIP_EMPTY_LINES);
    $results = array();
    foreach ($hosts as $h) {
        $infos = explode(",", $h);
        $results[$infos[0]] = $infos[1];
    }
?>

answered Jan 16 '13 at 16:51

Louis XIV

2,224
13
16

score 0 · Answer 3 · answered Jan 16 '13 at 16:52

Try the function explode.

//open a file handler
$file = file("path_to_your_file.txt");

//init an array for keys and values
$keys= array();
$values = array();

//loop through the file
foreach($file as $line){

    //explode the line into an array
    $lineArray = explode(",",$line);

    //save some keys and values for this line
    $keys[] = $lineArray[0];
    $values[] = $lineArray[1];
}

//combine the keys and values
$answer = array_combine($keys, $values);

score 0 · Answer 4 · answered Jan 16 '13 at 16:59

<?php
$handle = @fopen("ip-hosts.txt", "r");
$result = array();
if ($handle) {
    while (($buffer = fgets($handle, 4096)) !== false) {
        $t = explode(',', $buffer);
        $result[$t[0]] = $t[1];
    }
    if (!feof($handle)) {
        echo "Error: unexpected fgets() fail\n";
    }
    fclose($handle);
}
// debug:
echo "<pre>";
print_r($result);
echo "</pre>"
?>

Parse a CVS-like file in PHP and store it as a dictionary

4 Answers4