今天有空寫了個簡單連接數據庫的類：
## ***db.class.php***
~~~
<?php
class sql{
//+--------------------------
//| 連接數據庫
//|
//+--------------------------
public $db;
public function linkSql($host,$user,$pass,$dbname){
if(empty($host)){
exit("連接失敗，請檢查輸入是否有誤。");
}
$this->db = @new mysqli($host,$user,$pass,$dbname);
if(@$db->connect_error){
die("連接數據庫失敗:".$db->connect_error);
}
}
//+--------------------------
//| 查詢數據庫
//|
//+--------------------------
public function query($sql){
$res = $this->db->query($sql);
if ($res == false) {
exit("Sql語句錯誤！請檢查語句.");
}
return $res;
}
}
~~~
++------------------------------------------------------++
## ***index.php***
~~~
<?php
require_once("./db.class.php");
require_once("./db.inc.php");
$mysql = new sql();
$link = $mysql->linkSql(HOST,USER,PASS,DBNAME);
$arr = $mysql->query("select * from user");
print_r($arr);
~~~
++----------------------------------------------------++
## ***db.inc.php***
~~~
<?php
define("HOST","localhost");
define("USER","root");
define("PASS","123qwe!@#");
define("DBNAME","api");
~~~
-------2016.03.18整理
