Jump to content

import a csv to a 2 dimensional array


TheMentor

Recommended Posts

Hi,

 

I have a question: I have a CSV file where the first row are the names of the columns. The format of the CSV file is:

 

Name  |  Surname    | Adress      | Date of birth

Robert |    Miller          |  Athome 1|    29. Februar 1976

.

.

.

 

How should I import the CSV.

 

Thanks in advance.

Link to comment
https://forums.phpfreaks.com/topic/212349-import-a-csv-to-a-2-dimensional-array/
Share on other sites

Thx - I've solved it with this function:

 

$file = fopen('PG.csv', 'r');

$columns = fgetcsv($file);

	while($data = fgetcsv($file))
	{
	  foreach($columns as $key => $col)
	  {
	    $array[$col][] = $data[$key];
	  }
	}
return $array;

 

So - my problem is, that I have to return a specific column (depends on the name of one Index of the first row in the CSV file). How can I solve this problem??

 

Regards

TM

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.