Create array from MySQL PDO query results

Question

I have the table "users" :

________________________________________________
|---ID---|---Email---|---Birthday---|---City---|
|---1----|[email protected]|-02/03/1989---|---NY-----|
|---2----|[email protected]|-06/01/1990---|---LA-----|
------------------------------------------------

This is the query i use in pdo :

$qry = "SELECT * FROM users";

What i want is to stock the result from mysql pdo query in an array variable like this:

$result = array(
   array("id"=>1,
    "email"=>"[email protected]".
    "birthday"=>"02/03/1989",
    "city"=>"NY"),
   array("id"=>2,
    "email"=>"[email protected]".
    "birthday"=>"06/01/1990",
    "city"=>"LA")
);

How can i insert all the results in an array like this in php ?

jeroen · Accepted Answer · 2014-04-16 15:28:07Z

1

You can use fetchAll():

$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
          ^^^^^ or whatever you use

answered Apr 16, 2014 at 15:28

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

Create array from MySQL PDO query results

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related