<?php
header("Content-type: text/html; charset=gb2312");
class dosql{
private $arr=array(
'host'=>'localhost',
'user'=>'root',
'pwd'=>'',
'dbname'=>'news',
'ci'=>'set names gb2312',
);
private $links;
public $stmt;
public function __construct(){
$this->connect();
}
public function connect(){
$host=$this->arr['host'];
$user=$this->arr['user'];
$pwd=$this->arr['pwd'];
$dbname=$this->arr['dbname'];
$ci=$this->arr['ci'];
$this->links=new pdo("mysql:host=$host;dbname=$dbname","$user","$pwd");
$this->links->query($ci);
}
public function query($sql){
if(!$sm=$this->links->query($sql)){
echo "error";
}
return $sm;
}
public function getRow($sql){
$rk=$this->links->query($sql)->fetch();
return $rk;
}
public function getAll($sql){
$rk=$this->links->query($sql)->fetchAll();
return $rk;
}
}
$stmt=new dosql();
$rs=$stmt->getAll("selectS * from news");
var_dump($rs);
?>