PHP CSV to Associative Array

Question

I have a CSV file that I need to import into an associative array. The data looks like this:

 "General Mills Cereal",http://sidom.com/dyn_li/60.0.75.0/Retailers/Saws/120914_20bp4_img_8934.jpg,$2.25,"9-17.12 oz., select varieties","Valid Sep 14, 2012 - Sep 20, 2012",Saws,"Grocery"

I wan to transform this data into an array where I can grab values like this:

 $items[$row]['title'];
 $items[$row]['imgurl'];
 $items[$row]['itemprice'];
 $items[$row]['itemsize'];
 $items[$row]['expir'];
 $items[$row]['storename'];
 $items[$row]['storetype'];

Where the elements above correspond to my CSV file. How can I import this file into such an array?

Have a look at fgetcsv

clentfort
– clentfort

2012-09-18 19:01:23 +00:00
Commented Sep 18, 2012 at 19:01 — clentfort
– clentfort, Commented Sep 18, 2012 at 19:01

Noam · Accepted Answer · 2012-09-18 19:41:55Z

5

I would suggest using the built-in function fgetcsv
There's a simple usage example there also.

edited Sep 18, 2012 at 19:41

answered Sep 18, 2012 at 19:05

Noam

3,4014 gold badges39 silver badges67 bronze badges

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

Comments

Orbling · Accepted Answer · 2012-09-18 19:37:44Z

4

fgetcsv() will give you a numerically indexed array.

Once you have read all records in to say $rawData, which has a structure along the lines of:

$rawData = array(0 => array(0 => "General Mills Cereal",
                            1 => "http://sidom.com/dyn_li/60.0.75.0/Retailers/Saws/120914_20bp4_img_8934.jpg"
                            2 => "$2.25",
                            3 => "9-17.12 oz.",
                            4 => "select varieties",
                            5 => "Valid Sep 14, 2012 - Sep 20, 2012",
                            6 => "Saws",
                            7 => "Grocery"),
                 ...);

To convert this $rawData array to what you want, you can do something like this:

$fields = array('title', 'imgurl', 'itemprice', 'itemsize',
                'expir', 'storename', 'storetype');

$data = array_map(function($cRow) uses ($fields) {
            return array_combine($fields, $cRow);
        }, $rawData);

answered Sep 18, 2012 at 19:37

Orbling

20.7k4 gold badges56 silver badges64 bronze badges

1 Comment

Arieleo Over a year ago

Just a small correction - "uses" should be "use". Otherwise this worked for me.

Community · Accepted Answer · 2017-05-23 12:02:14Z

3

See below URL

CSV to Associative Array

Try it

run over the csv file line by line, and insert to array like:

$array = array();
$handle = @fopen("file.csv", "r");
if ($handle) {
    while (($line = fgetcsv($handle, 4096)) !== false) {

       $array[$line[0]][$line[1]][$line[2]] = $line[3];
    }
    if (!feof($handle)) {
        echo "Error: unexpected fgets() fail\n";
    }
    fclose($handle);
}

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Sep 18, 2012 at 19:02

Abid Hussain

7,7694 gold badges38 silver badges57 bronze badges

Comments

Jan-Peter Rühmann · Accepted Answer · 2024-01-26 16:09:14Z

0

I´ve done this.

<?php
$file = "galerie.csv";
$handle = fopen($file, "r");
  while (($data = fgetcsv($handle)) !== FALSE) {
    $galerie[$data[0]]["alt"] = $data[1];
    $galerie[$data[0]]["caption"] = $data[2];
   }
fclose($handle);
print_r($galerie);
?>

answered Jan 26, 2024 at 16:09

Jan-Peter Rühmann

213 bronze badges

Collectives™ on Stack Overflow

PHP CSV to Associative Array

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related