user = $user; if ($pass != "") $this -> pass = $pass; if ($databa">
时间:2021-07-01 10:21:17 帮助过:16人阅读
 host = $host;      if ($user != "") $this -> user = $user;      if ($pass != "") $this -> pass = $pass;      if ($database != "") $this -> database = $database;	       if (!$this -> conn = @mysqli_connect($this -> host, $this -> user, $this -> pass))	  {        return $this -> output("连接数据库 '".$this -> host."' 失败。".mysqli_error($this -> conn));      }	   mysqli_query($this -> conn,"SET NAMES 'utf8'");       $this -> selectdb();    }function selectdb($database="")	{      if ($database != "" && $database != $this -> database)        $this -> database = $database;      if (!mysqli_select_db($this -> conn, $this -> database))	  {        return $this -> output("无法使用数据库 '".$this -> database."'。");      }	}function query($sql="", $database="")                     //$sql	{      if ($sql != "") $this -> sql = $sql;      if ($database != "" && $database != $this -> database)	  {        $olddb = $this -> database;        $this -> selectdb($database);      }      $this -> result = @mysqli_query($this -> conn,$this -> sql);      if (mysqli_error($this -> conn) != "")	  {        return $this -> output("执行以下SQL语句时失败:'".$this -> sql."' 
".mysqli_error($this -> conn));      }      $this -> n = @mysqli_affected_rows($this -> conn);                         if (!empty($olddb)) $this -> selectdb($olddb);                     return $this -> result;			}function get_data()	{   /*   if(!$this -> result || !preg_match("/^Resource/i", $this -> result)){    */                if(!$this -> result || !is_resource($this->result)){             return $this->output("没有数据,请先执行SQL的'select'语句!");      }      $count=0;      $this -> m = @mysqli_num_rows($this -> result);      if ($this -> m > 0)	  {        while ($row = mysqli_fetch_array($this -> result))		{          $data[$count] = $row;          $count++;        }        return $this->result=$data;      }	  else	  {        return $this -> output("数据为空!");      }      mysqli_free_result($this -> result);	}function output($msg){  $this->err=$msg;  if ($this->debug)echo $msg;  return false;}  }?>////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////";	echo "
";	} $sql = "SELECT * FROM t6_dept where de_id>'0' ORDER BY de_id ASC"; $db -> query($sql); $result = $db -> get_data(); if(!$result)       {	echo "取出数据失败result 0";	echo "
";	echo "
";	}echo $result[0]["de_name"];          //无法显示数据print_r($db);?>  
  mysqli_query($this -> conn,$this -> sql) 返回的是 mysqli_result 对象,不是 resource (资源)  
 所以 !is_resource($this->result) 成立,程序提前结束  
 
   mysqli_query($this -> conn,$this -> sql) 返回的是 mysqli_result 对象,不是 resource (资源)   
 所以 !is_resource($this->result) 成立,程序提前结束  
  if(!$this -> result || !is_object($this->result)){       
         return $this->output("没有数据,请先执行SQL的'select'语句!");  
       } 
   if(!$this -> result || !is_object($this->result)){        
         return $this->output("没有数据,请先执行SQL的'select'语句!");   
       }