PHP Returning array of objects from rows

Question

I want the php to be able to load all the rows in the table into an object each and then add them all to an array and return the array to be converted into java objects etc.

<?php


ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(-1);

$dbhost     = "localhost";
$dbname     = "Example";
$dbuser     = "Example";
$dbpass     = "Example";

 $conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
$objectArray = array();

$stmt = $conn->prepare("SELECT * FROM Table");
while ($row = $stmt->fetch()) 
  {
    #add all columns on this row to an object and add to array
  }
$stmt->execute();

if(!$stmt)
    print_r($dbh->errorInfo());

?>

Ron van der Heijden · Accepted Answer · 2014-02-17 15:26:07Z

1

Why not using the PDO::FETCH_OBJ

$array = array();
while ($row = $stmt->fetch(PDO::FETCH_OBJ)) 
{
    #add all columns on this row to an object and add to array
    $array[] = $row; // $row is an object now
}

answered Feb 17, 2014 at 15:26

Ron van der Heijden

15.1k7 gold badges62 silver badges86 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 10:31:56Z

0

You can also fetch results into a defined class.

Read this reply: PDO PHP Fetch Class

edited May 23, 2017 at 10:31

CommunityBot

11 silver badge

answered Feb 17, 2014 at 15:54

Cups

6,9063 gold badges29 silver badges30 bronze badges

Collectives™ on Stack Overflow

PHP Returning array of objects from rows

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related