Load mySQL results in arrays into a array

Question

I can't figure out how to load the mySQL results (address,name) into this format:

$to=array(
    array("address"=>"[email protected]","name"=>"John Doe"),
    array("address"=>"[email protected]","name"=>"Jo Frost"),
    array("address"=>"[email protected]","name"=>"Some One"),
    etc...
);

Please the old way for learning. Thx.

It would be helpful to see what code you have currently and what it outputs. — ArtisticPhoenix
– ArtisticPhoenix, Commented Jul 31, 2016 at 20:55
Do you want to load data into this format from dbase? If so its just fetchAll in all dbase providers. — Mehmet SÖĞÜNMEZ
– Mehmet SÖĞÜNMEZ, Commented Jul 31, 2016 at 21:00
It's a demo script I like to adjust, so the code above is inside but I have my data in a mySQL database. — Harry
– Harry, Commented Jul 31, 2016 at 21:03

buildok · Accepted Answer · 2016-08-03 20:11:57Z

1

like that

$query = 'SELECT address, name FROM table';
$mysqli = new mysqli('host', 'user', 'password', 'database');

if ($mysqli->connect_errno) {
    echo 'Connect failed:' . $mysqli->connect_error;
    exit();
}

if($res = $mysqli->query($query)) {
    $ret = [];
    while($row = $res->fetch_assoc()) {
       $ret[] = $row;
    }

    print_r($ret);

 } else {
      echo $mysqli->error;
 }

see more:

http://php.net/manual/en/book.mysqli.php

http://php.net/manual/en/mysqli.query.php

http://php.net/manual/en/mysqli-result.fetch-assoc.php

edited Aug 3, 2016 at 20:11

answered Jul 31, 2016 at 21:21

buildok

7956 silver badges7 bronze badges

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

6 Comments

Harry Over a year ago

Thanks... but the only output I got is: Array ( )

buildok Over a year ago

How do you do a database query?

Harry Over a year ago

What do you mean? I just test your code copy/paste with, ofcourse, the right variables for table, database etc.

buildok Over a year ago

make another copy/paste

Harry Over a year ago

I found out: you forgot the () behind fetch_assoc, it works, thanks.

|

Collectives™ on Stack Overflow

Load mySQL results in arrays into a array

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related