PHP Parsing file into Array of Array

Question

I have a file with many rows,each row have the following format: 1519382994.85#MSG#Something went wrong

So, for each row i have three field divided by #. A number, a message type and a string.

Now i want to read the file and split the contents. I made it in this way:

//Opening the logger file
$myfile = file_get_contents("operations.txt", "r") or die("Unable to open file!");
$rows = explode("\n", $myfile);
$num_rows = count($rows);
$fieldList = array();
//Parsing rows using '#'
foreach ($rows as $row => $data) {
    $row_data = explode('#', $data);
    array_push($fieldList, (string)$row_data[0]);
    array_push($fieldList, (string)$row_data[1]);
    array_push($fieldList, (string)$row_data[2]);
}

The code is working well but i'd like to have an array of array and this kind of data:

0: Array [ "112323.76", "MSG", "Hello"]
1: Array [ "453435.78", "MSG", "Bye"] etc..

I tryed with this code but i'm doing something wrong.

  $last=0;
 $result = array();
        for ($i = 0; $i < $num_rows; $i++) {
        array_push($result, (string) $fieldList[$last], (string) $fieldList[$last+1],(string) $fieldList[$last+2]);
        //echo $fieldList[$last].'<br>';
        //echo $fieldList[$last+1].'<br>';
        //echo $fieldList[$last+2].'<br>';
        $last=$last+3;
        }

I'm a newbie in PHP someone can help me please and tell me what i'm doing wrong? Tanx a Lot for your time

Kris · Accepted Answer · 2018-02-26 09:51:14Z

3

You could probably make use of the built-in fgetcsv:

array fgetcsv ( resource $handle [, int $length = 0 [, string $delimiter = "," [, string $enclosure = '"' [, string $escape = "\\" ]]]] )

This could look like:

$rows = [];
if (false !== ($handle = fopen("path/to/file", "r"))) 
{
    while (false !== ($row = fgetcsv($handle, 1000, ",")))
    {
        array_push($rows, $row);
    }
    fclose($handle);
}

Don't know if it would be a lot faster, but looks a lot easier to me. The main benefits of this over file() and explode() are:

There is no need to have the entire file in RAM at once, processing could be done one row at a time.
it is easy to support other "Character Seperated Values" type files where fields may be quoted ($enclosure)

edited Feb 26, 2018 at 9:51

answered Feb 26, 2018 at 9:29

Kris

42.1k9 gold badges78 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Death-is-the-real-truth · Accepted Answer · 2018-02-26 09:26:26Z

1

Just needed some modifications in your code. Added comments to modified lines-

$myfile = file_get_contents("operations.txt", "r") or die("Unable to open file!");
$rows = explode("\n", $myfile);
$num_rows = count($rows);
$finalFieldList = array(); // new array
//Parsing rows using '#'
foreach ($rows as $row => $data) {
    $fieldList = array(); // temporary array
    $row_data = explode('#', $data);
    array_push($fieldList, (string)$row_data[0]);
    array_push($fieldList, (string)$row_data[1]);
    array_push($fieldList, (string)$row_data[2]);

    array_push($finalFieldList, $fieldList); // it will push to final array containing all 3 values
}

edited Feb 26, 2018 at 9:26

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

answered Feb 26, 2018 at 9:16

Jigar Shah

6,2332 gold badges32 silver badges41 bronze badges

5 Comments

Nic Over a year ago

This is working in some waybut i get this error. 1st iter is correct. {"0":{"0":"1519382994.96","1":"MSG","2":"blablawentok"} 2nd is wrong "1":{"0":"1519382994.96","1":"MSG","2":"blablawenok","3":"1519382994.96","4":"MSG","5":"Processato CSV"}. So i have anincrementalerror at each iter. Some hints? :)

Jigar Shah Over a year ago

you have made the same mistake in that code as well. You can use another temporary array to get the correct formatting , or it would be better to do in your first foreach loop

Nic Over a year ago

Resolvedin this way, but i think is not elegant... foreach ($rows as $row => $data) { $row_data = explode('#', $data); array_push($fieldList, (string)$row_data[0]); array_push($fieldList, (string)$row_data[1]); array_push($fieldList, (string)$row_data[2]); array_push($result, $fieldList); // it will push to final array containing all 3 values unset($foo); // break references $fieldList = array(); // re-initialize to empty array }

Jigar Shah Over a year ago

yes it is not, you can have look on above answers for decent ways to get your desired output. :)

Nic Over a year ago

I forgot to add the temporary array. It works like a charm now. Ty Alive

Collectives™ on Stack Overflow

PHP Parsing file into Array of Array

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related