Build a multidimensional array from the php string

 Here is a portion of $preparedstring:

555555,Jones,Brian,NYC,1000,2011-10-21 00:00:00,Check,1542,0, ,Check, ,0, ,Check, ,; 6666666,Miler,Christopher,Chicago,1000,2011-10-26 00:00:00,Check,6406,0, ,Check, ,0, ,Check, ,;

I am trying to convert a HTML table to a multidimensional array. I have converted the table into a long string, each cell being delimited with a comma and each row being delimited with a semicolon.

I am not exactly sure how to build the multidimensional array from this string. This is what I have tried so far:

<?php
$outerARR = explode(";", $preparedstring);

    $arr = array
    (
    foreach ($outerARR as $arrvalue) {
        $innerarr = explode(",", $arrvalue);
        $innerarr[0]=>array
        (
         $innerarr[];
         )
    }
    );
?>

this gives me a syntax error near the

$arr = array

(

opening parenthesis.

---

Your approach to solving the problem is sadly very wrong, though there are many solutions to your problem, I would use something like the below.

---

How does the code work?

First we use explode to split our string up in smaller chunks, ; is our delimiter.

We pass this newly created array to array_map as it's second parameter.

array_map takes two parameters, the first one is a function that will be called for every member of the second paramater (which should be an array).

Inside our callback to array_map we use explode to once again split out the values, now with , as our delimiter.

---

$data = "1,2,3;4,5,6;7,8,9";

$ret = array_map (
  function ($_) {return explode (',', $_);},
  explode (';', $data)
);

print_r ($ret);

output

Array
(
    [0] => Array
        (
            [0] => 1
            [1] => 2
            [2] => 3
        )

    [1] => Array
        (
            [0] => 4
            [1] => 5
            [2] => 6
        )

    [2] => Array
        (
            [0] => 7
            [1] => 8
            [2] => 9
        )

)

---

It doesn't work, why?

Probably because you are using a version of PHP prior to 5.3, if so you can use this snippet instead:

function explode_by_comma ($_) {
  return explode (',', $_);
}

$ret = array_map ('explode_by_comma', explode (';', $data));