return an array of objects

Question

want from a method return an array of objects, what is the best way retrieving data from the db and then populate a list of objects to be returned.

       <?php

        class DataObject{
          public function GetObjetList(){
           // Connect to the database server
           $dbh = new PDO("mysql:host=localhost;dbname=bookdb", "webuser", "secret");
           // Execute the query return 1200 register
           $stmt = $dbh->query('SELECT sku, title FROM products ORDER BY title');
           while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
                $sku = $row['sku'];
                $title = $row['title'];
                return something?? --> how to??
          }
        }
       ?>

regards!

silkfire · Accepted Answer · 2014-09-25 18:09:56Z

2

PDO already has a fetch mode that returns objects.

Change your code to this:

while ($row = $stmt->fetch(PDO::FETCH_OBJ)) {

edited Sep 25, 2014 at 18:09

answered Mar 14, 2014 at 14:53

silkfire

26.3k17 gold badges92 silver badges116 bronze badges

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

Comments

Your Common Sense · Accepted Answer · 2014-03-14 15:06:28Z

-1

class DataObject
{
    public function __construct($pdo)
    {
        $this->db = $pdo;
    }
    public function GetObjetList()
    {
        $sql = 'SELECT sku, title FROM products ORDER BY title';
        return $this->db->query($sql)->fetchAll(PDO::FETCH_OBJ);
    }
}

edited Mar 14, 2014 at 15:06

answered Mar 14, 2014 at 14:57

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Comments

Daniel W. · Accepted Answer · 2014-03-14 14:57:54Z

-2

Put the return after the while, not inside, use FETCH_OBJ and an array:

     $rows = array();
     $rows = $stmt->fetchAll(PDO::FETCH_OBJ);
     return $rows;

answered Mar 14, 2014 at 14:57

Daniel W.

32.6k15 gold badges99 silver badges155 bronze badges

Collectives™ on Stack Overflow

return an array of objects

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related