//定义封装的类:公共的数据库类
class MySQL{
private $host;//主机
private $name;//用户名
private $pass;//密码
private $database;//数据库
private $charset;//编码
private $conn;//连接
//用set get函数
function __set($n,$v){
$this->$n=$v;
}
function __get($n){
return $this->$n;
}
//构造函数赋值
function __construct($host,$name,$pass,$db,$cs){
$this->host=$host;
$this->name=$name;
$this->pass=$pass;
$this->database=$db;
$this->charset=$cs;
$this->conn=$this->getConn();
}
//得到链接
function getConn(){
$conn = mysql_connect($this->host,$this->name,$this->pass) or die("连接失败");
mysql_select_db($this->database,$conn) or die("失败");
mysql_query("set names '$this->charset'");
return $conn;
}
function myUpdate($sql){
$res = mysql_query($sql,$this->conn) or die(mysql_error());
if($res>0){
echo "成功";
}else{
echo "失败";
}
return $res;
}
function myFetch($result){
$row = mysql_fetch_array($result);
return $row;
}
}
这样的一个类 比不用类直接连接好在哪里?
展开