Convert a string to an array - PHP

Question

Possible Duplicate:
Load and read a csv file with php

I have the following string:

Mr,Tom,Jones,Add1,Add2,"Add3,Add3 extra",Town,County,postcode,99999,888,777

I am tring to get the string into an array that looks like the below:

Array
(
    [0] => Mr
    [1] => Tom
    [2] => Jones
    [3] => Add1
    [4] => Add2
    [5] => "Add3,Add3 extra"
    [6] => Town
    [7] => County
    [8] => Postcode
    [9] => 99999
    [10] => 888
    [11] => 777
)

if you explode the string by "," it splits array item 5 into 2 parts which I am trying to avoid. The original data comes from a CSV.

Ultimatly I am trying to import a CSV and create a new DB on the fly with the headers and file content against the correct headers.

Thanks in advance.

score 6 · Answer 1 · edited Aug 12 '12 at 13:02

6

Try fgetcsv():

fgetcsv — Gets line from file pointer and parse for CSV fields

edited Aug 12 '12 at 13:02

kapa

77,694
21
158
175

answered Aug 10 '12 at 15:04

Peter Kiss

9,309
2
23
38

1

[`str_getcsv()`](http://php.net/manual/en/function.str-getcsv.php) could do that work too. – Florent Aug 10 '12 at 15:06
True but if he has a file with the data (CSV mostly means "i have a file") then he should use fgetcsv(). – Peter Kiss Aug 10 '12 at 15:07

score 2 · Answer 2 · edited Aug 12 '12 at 13:03

2

$array = str_getcsv( 'Mr,Tom,Jones,Add1,Add2,"Add3,Add3 extra",Town,County,postcode,99999,888,777', ',', '"' );

This will get you to an array with what you want.

str_getcsv()

edited Aug 12 '12 at 13:03

kapa

77,694
21
158
175

answered Aug 10 '12 at 15:11

Jester

1,285
14
24

score 0 · Answer 3 · answered Aug 10 '12 at 15:05

<?php
$row = 1;
if (($handle = fopen("test.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
        echo "<p> $num fields in line $row: <br /></p>\n";
        $row++;
        for ($c=0; $c < $num; $c++) {
            echo $data[$c] . "<br />\n";
        }
    }
    fclose($handle);
}
?>

From fgetcsv

score 0 · Answer 4 · answered Aug 10 '12 at 15:06

0

You can use str_getcsv().

str_getcsv — Parse a CSV string into an array

answered Aug 10 '12 at 15:06

Shubham

21,300
18
66
89

Convert a string to an array - PHP

4 Answers4