返回一个对象数组

问题描述：

想从一个方法中返回一个对象数组，最好的方法是什么从数据库中检索数据，然后填充要返回的对象列表.

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??
          }
        }
       ?>

问候！

答

PDO 已经有一个返回对象的获取模式.

PDO already has a fetch mode that returns objects.

将您的代码更改为:

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

返回一个对象数组

相关推荐