創建一個類

class DB_class
{//public $name = 'andy';//私有的屬性private static $db;//公共的靜態方法public static function index(){if (self::$db != null ){return self::$db;}self::$db=new DB_class();return self::$db;}//私有的構造方法private function __construct(){}//私有的克隆方法private function __clone(){// TODO: Implement __clone() method.}/*** @return mixed* 查詢*/public function query($sql){//連接數據庫$my = mysqli_connect('127.0.0.1','root','root','zhuangao_six');//選擇字符集mysqli_set_charset($my,'utf8');//執行$res=mysqli_query($my,$sql);$data=mysqli_fetch_all($res,1);mysqli_free_result($res);return  $data;mysqli_close($my);}//增刪改function zsg($sql){//連接數據庫$my = mysqli_connect('127.0.0.1','root','root','zhuangao_six');//選擇字符集mysqli_set_charset($my,'utf8');//執行$res=mysqli_query($my,$sql);
//        $data=mysqli_fetch_all($res,1);
//        mysqli_free_result($res);
//        return  $data;return $res;mysqli_close($my);}
}

使用

//測試新增方法function db(){$db = DB_class::index();//$sql = "select * from owner";$sql = "INSERT INTO owner ( name, age ,sex ) VALUES( 'zhang1', '12','男' )";$data = $db->zsg($sql);}//查找方法function db(){$db = DB_class::index();$sql = "select * from owner";//$sql = "INSERT INTO owner ( name, age ,sex ) VALUES( 'zhang1', '12','男' )";$data = $db->query($sql);}//刪除方法function db(){$db = DB_class::index();$sql = "DELETE FROM owner WHERE id = '1'";$data = $db->zsg($sql);}//修改方法function db(){$db = DB_class::index();$sql = "UPDATE owner SET name='lalal', age='2' WHERE id=2";$data = $db->zsg($sql);}