php - 嵌套方法对吗？为什么我得到空查询？

Question

我想知道为什么我在使用该代码时会出错？有人可以帮忙吗？我的类(class)是使用嵌套方法从数据库中获取一些信息，假设我得到一个空查询

<?php
class db {
 public function __construct(){
 if(mysql_connect("localhost","root","0000")){
     mysql_select_db("myblog");

 }else{
     echo mysql_error();
 }

 }

   public function select($row){
      $sql="SELECT".$row;
      return $this;
   }

   public function from($table){
      $sql.="FROM".$table;
      return $this;
   }

   public function where($condition){
     $sql.="WHERE".$condition;
      return $this;
   }

}
$ddb=new db;
$qq=$ddb->select("*")->from("news")->where("id='1'");
$query=  mysql_query($qq);
while($row=mysql_fetch_object($query)){
    echo $row->title;
}
?>

Answer 1

您必须定义 __toString() 特殊方法才能将您的对象用作字符串:

class db {

    private $sql = '';

    public function __construct() {
        if (mysql_connect("localhost", "root", "0000")) {
            mysql_select_db("myblog");
        } else {
            echo mysql_error();
        }
    }

    public function select($row) {
        $this->sql = "SELECT ".$row;
        return $this;
    }

    public function from($table) {
        $this->sql .= " FROM ".$table;
        return $this;
    }

    public function where($condition) {
        $this->sql .= " WHERE ".$condition;
        return $this;
    }

    public function __toString() {
        return $this->sql;
    }

}

$ddb = new db();
$qq = $ddb->select("*")->from("news")->where("id='1'");
$query = mysql_query($qq);
while ($row = mysql_fetch_object($query)) {
    echo $row->title;
}