php中类操作是一个基本技能,下面咸宁网站建设公司封装一个类操作:实现代码如下
<?php
header("Content-type: text/html; charset=utf-8");
class db{
private $arr=array(
'host'=>'localhost',
'dbname'=>'news',
'user'=>'root',
'pwd'=>'',
'ci'=>'set names utf8',
);
public $db;
public function __construct(){
$this->connect();
}
public function connect(){
$this->db=new pdo("mysql:host={$this->arr['host']};dbname={$this->arr['dbname']}","{$this->arr['user']}","{$this->arr['pwd']}");
$this->db->query("set names utf8");
if(!$this->db)
{
echo "连接失败,检查数据库连接数据";
}else{
//echo "连接成功";
}
}
public function query($sql){
$stmt=$this->db->query($sql);
return $stmt;
}
public function fetchAll($sql){
return $this->db->query($sql)->fetchAll(PDO::FETCH_ASSOC);
}
}
$mypdo=new db();
$sql="";//写一个SQL语句
$rk=$mypdo->fetchAll($sql);
var_dump($rk);
?>