Easily add data from database to multidimensional array using php

Question

How can I easily add data from MySQL to a multidimensional array in PHP? I am making a search box and I want to store the first name, and the last name in the array.

Why does not this work.

$result = mysqli_query($db, $sql) or die(mysqli_error());

$data = array();

while ($row = mysqli_fetch_array($result)) {
    $data[$row['primary']] = $row['firstname'], $row['lastname'];
}

learn basic php. $data[$row['primary']] = array($row['firstname'], $row['lastname']);. And if all you wanted as the firstname/lastname, that's all you should have selected, and the lien woudl be $data[$row['primary']] = $row — Marc B
– Marc B, Commented May 27, 2014 at 21:44

kvambaam · Accepted Answer · 2014-05-31 22:15:42Z

1

$data[$row['primary']] = array($row['firstname'], $row['lastname']);

answered May 31, 2014 at 22:15

kvambaam

4965 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Easily add data from database to multidimensional array using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related