簡單的資料庫鏈式操作的例子

/*

@author Dishy
資料庫封裝
*/
class mysqldb{

private$host;private$username;private$password;private$dbname;private$sql;private$select = true;private$result;private$array;publicfunction__construct($host,$username,$password,$dbname){    $this->host = $host;    $this->username = $username;    $this->password = $password;    $this->dbname = $dbname;    $this->dbconnect();}/*    資料庫連接*/privatefunctiondbconnect(){    mysql_connect($this->host,$this->username,$this->password);    mysql_select_db($this->dbname);}/**執行sql語句***/publicfunctionquery($sql){        $this->sql = $sql;        $this->result = mysql_query($this->sql);        return$this;}/***$select = false時輸出sql語句*/publicfunctionselect($select= true){    $this->select = $select;    if($this->select){        return$this->array =  $this->result();    }else{        return$this->sql;    }}/***結果集*/privatefunctionresult(){    $array = mysql_fetch_array($this->result);    return$array;}

}

?>
使用方法 include “./Api/datebase.php”;
define('DB_HOST_NAME','localhost');
define('DB_HOST_USERNAME','root');
define('DB_HOST_PASSWORD','root');
define('DB_HOST_DB','jciot');
$Jciot_db = new mysqldb(DB_HOST_NAME,DB_HOST_USERNAME,DB_HOST_PASSWORD,DB_HOST_DB);
$a = $Jciot_db->query('select * from jciot_member')->select();
var_dump($a);

?>`

以上就介紹了簡單的資料庫鏈式操作的例子，包括了方面的內容，希望對PHP教程有興趣的朋友有所協助。

