Change Array Name php

Question

I want to load a CSV file dynamically into php and store it in an array. I can't get the array name changed to the form I want it to be. The first array should be numbered as normal, the second should contain the header of the CSV file.

This is my current function to solve the problem:

static function parseCSV($path){

        $fp = file($path);
        $array = array();
        for ($i = 0; $i < count($fp); $i++) {
            $e = explode("," , $fp[$i+1]);
            foreach($e as $data){
                $array[$e[0]][] = $data;
            }
        }
        
        print_r($array);
    }

This is the Output:

Array
(
    [Louis] => Array
        (
            [0] => Louis 
            [1] => 000               
            [2] => 01.01.2001
            [3] => Canada
        )

    [Hannah] => Array
        (
            [0] => Hannah
            [1] => 001              
            [2] => 02.02.2002             
            [3] => Germany        


        )
)

The output I would like:

Array
(
    [1] => Array
        (
            [name] => Louis 
            [id] => 000               
            [birthday] => 01.01.2001
            [country] => Canada
        )

    [2] => Array
        (
            [name] => Hannah
            [id] => 001              
            [birthday] => 02.02.2002             
            [country] => Germany        


        )
)

Does this answer your question? https://stackoverflow.com/q/10181054/367456 — hakre, Nov 21 '22 at 18:47

subodhkalika · Answer 1 · 2022-11-21T15:17:49.780

0

You can create a new row data array with the specific array index:

static function parseCSV($path){
        $headers = ['name', 'id', 'birthday', 'country'];
        $fp = file($path);
        $array = array();
        for ($i = 0; $i < count($fp); $i++) {
            $rows = explode("," , $fp[$i+1]);
            foreach($rows as $row) {
                $associativeArray = array();
                foreach($row as $index=>$value) {
                    $associativeArray[$headers[$index]] = $value;   
        
                }
                array_push($array, $associativeArray);
            }
        }
        
        print_r($array);
    }

edited Nov 21 '22 at 15:17

answered Nov 21 '22 at 13:21

subodhkalika

1,964
1
9
15

``$array[$i + 1][] = [ 'name' => $e[0], 'id' => $e[1], 'birthday' => $e[2], 'country' => $e[3]`` Also, you don't the inner foreach then. – OMi Shah Nov 21 '22 at 13:31
This works, but I need to be able to load the data dynamically from the CSV file. – Paganini29 Nov 21 '22 at 13:41
Are your csv headers always fixed ? Will you always have name, id, birthday and country? – subodhkalika Nov 21 '22 at 14:40
Yes, they are always the same in this task. But I simplified it a bit for this, I actually have a lot more data. – Paganini29 Nov 21 '22 at 14:59
You can have a headers array separately and run a loop to set them in. Updated answer. – subodhkalika Nov 21 '22 at 15:18
I tried that, unfortunately it didn't work at all. – Paganini29 Nov 21 '22 at 16:08

Change Array Name php

1 Answers1