php - 修改php oop mysql查询

Question

嘿，感谢之前的帮助，我现在有了一个很棒的函数来查询特定的数据行。

    class Posts{

      public static function singleQuery($table, $value){

        return mysql_fetch_object(
           mysql_query("select * from $table where id=$value"), __CLASS__);

      }

    }

$set = Posts::singleQuery('settings', '1');
echo $post->title;

我希望修改它，以便它查询以下内容:

SELECT * FROM posts ORDER BY id DESC LIMIT 0, 3"

然后在我的 View /索引页面上创建一个“回显循环”或一个 foreach 类型的交易。像这样的东西:

foreach ($a as $b){  
    echo "yadda"  
}

我希望这是有道理的..

Answer 1

$result = mysql_query("SELECT * FROM posts ORDER BY id DESC LIMIT 0, 3"), __CLASS__);

while($object = mysql_fetch_object($result)) {
   // each round of while has the next line in $object
   $return[] = $object;
}

return $return;

...

$array = Posts::multipleQuery(...);
foreach($array AS $row) {
   echo $row->title;
}