php+mysql 物件導向 增刪改查

新手一枚，求指導。

localhost = $localhost;//就用$this->localhost 代替。 $this->root  = $root;$this->password  = $password;$this->database  = $database;    }public function Connect(){mysql_connect($this->localhost,$this-root,$this->password);mysql_select_db ($this->database);mysql_query ("set names utf8");}public function Close(){mysql_close();}public function myarray($result){//形參return mysql_fetch_array($result);}public function myquery($sql){return @mysql_query($sql);}public function myrows($result){return mysql_num_rows($result);}public function myselect($users){return $this->myquery("select * from $users");}}$db = new Mysql("localhost","root","","stu_system");

 myselect("users");if(is_array($result)){while($row=$db->myarray($result)){?>
   

  

   

    
id
    
name
    
sex
    
phone
   

    
 
    

    
 
    

    
&name = &sex = &phone= "> 修改 "> 刪除
   
  
 

擷取不到我的資源，找不到問題在哪。

回複討論(解決方案)

if(is_array($result)){ 這句判斷有問題。

$result應是resource，而不是array
你可以var_dump(is_array($result)); 是boolean false的。

改為： if($db->myrows($result)>0){

沒有執行 Connect 方法
沒有執行 myquery 方法

myselect 方法返回的是資源

沒有執行 Connect 方法
沒有執行 myquery 方法

myselect 方法返回的是資源

同上

localhost = $localhost;                                            //就用$this->localhost 代替。         $this->root      = $root;        $this->password  = $password;        $this->database  = $database;            }         public function Connect(){        $this->link = mysql_connect($this->localhost, $this->root, $this->password);        mysql_select_db ($this->database, $this->link );        mysql_query     ("set names utf8");    }         public function Close(){        mysql_close();    }              public function myarray($result){                    //形參        return mysql_fetch_array($result);    }         public function myquery($sql){        $this->res = mysql_query($sql) or die (mysql_error());        return $this->res;    }         public function myrows($result){        return mysql_num_rows($result);    }              public function myselect($users){        return $this->myquery("select * from $users");    }} $db = new Mysql("localhost","root","","stu_system");$db->Connect();
 myselect("users"); while($row=$db->myarray($result)){?> 
   
    
  

   
 
    
id
 
    
name
 
    
sex
 
    
phone
 
   
 
    
 
 
    
 
    
 
 
    
 
    
 & name = & sex = & phone= "> 修改  "> 刪除 
 
   
  
 
