Transform string from associative array into multidimensional array

Question

I'm storing images links into the database separating them with ,, but I want to transform this string into an array, but I'm not sure how to do it.

So my array looks like this:

$array = array(
"name" => "Daniel",
"urls" => "http:/localhost/img/first.png,http://localhost/img/second.png"
);

So I'd like to have it in the following form:

$array2 = array(
"name" => "Daniel",
"urls" => array("http:/localhost/img/first.png",
                "http://localhost/img/second.png" )
);

fixing the db structure would be a better idea, en.wikipedia.org/wiki/First_normal_form — user8011997
– user8011997, Commented Jan 14, 2018 at 20:29

Viktor · Accepted Answer · 2018-01-14 20:13:22Z

2

I haven't been PHP'ing for a while, but for that simple use-case I would use explode.

$array['urls'] = explode(',', $array['urls']);

Uncertain if I interpreted your question correct though?

answered Jan 14, 2018 at 20:13

Viktor

5172 gold badges8 silver badges27 bronze badges

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

3 Comments

IncredibleHat Over a year ago

Explode will work for his case. Although he really should be storing multiple images in a second table linked by id of the first table. Storing anything in a single field by comma can lead to many issues later with flexibility and maintenance.

Viktor Over a year ago

Agreed. But you gotta start with something.

Progrock Over a year ago

If the urls contain comma(s), splitting by comma could be problematic.

user2560539 · Accepted Answer · 2018-01-14 20:25:43Z

0

You can use array_walk_recursive like in the following example.

function url(&$v,$k)
{
    if($k=='urls') {
    $v = explode(",",$v);
    }
}
$array = array(
"name" => "Daniel",
"urls" => "http:/localhost/img/first.png,http://localhost/img/second.png"
);
array_walk_recursive($array,"url");

You can check the output on PHP Sandbox

answered Jan 14, 2018 at 20:25

user2560539

Collectives™ on Stack Overflow

Transform string from associative array into multidimensional array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related