php - Read all csv files in directory doesn't read lines correctly

I have a script that reads all CSV files in a given directory. The reading is okay, but the output isn't what I'm seeking.

The content of the files is

7,5133606393691467151,000000000000000000
5,-841871172646878578,00000000000000
8,-482903031559659252,000000000000
Copy code

Desired output

Array (
    [0] => Array
    (
       id: 7
       number_1: 5133606393691467151
       number_2: 000000000000000000
    )
    [1] => Array (
       id: 5
       number_1: -841871172646878578
       number_2: 00000000000000
    )
    [2] => Array (
       id: 8
       number_1: -482903031559659252
       number_2: 000000000000
    )
)
Copy code

This is my code so far

$files = glob("SQLs/*.csv");

foreach($files as $file) {

    if (($handle = fopen($file, "r")) !== FALSE) {
        while (($data = fgetcsv($handle, 4096, ",")) !== FALSE) {
            foreach ($data as $lineArr) {
                list($id[],$number_1[],$number_2[]) = $lineArr;
            }
        }
        fclose($handle);
    } else {
        echo "Could not open file: " . $file;
    }
}
Copy code

Currently got error 500 when I run it through the browser. If I run it in a console likephp example.php >> output.txt got nothing again. The file output.txt is empty.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.