<?php
class db{
private $host;
private $user;
private $pass;
private $db_name;
private $sql;
private $tab_name;
private $cols;
//以上是属性的声明
public function __construct($host,$user,$pass,$db_name,$sql){
//构造函数会在实例化对象前调用这个方法,提供了一个契机:初始化属性
//如果实例化一个类的对象的时候 传递了参数,意味着向构造函数里传递参数
$this ->host = $host;
$this ->user = $user;
$this ->pass = $pass;
$this ->db_name = $db_name;
$this ->sql =$sql;
//以上是属性的初始化
$this ->connect();//调用方法函数
}
public function connect(){
//如果连接数据库成功返回一个标识,这个表示用来以后断开数据库的表示
mysql_connect($this->host,$this->user,$this->pass);
mysql_select_db($this->db_name);
mysql_query($this->sql);
}
//查询所有内容
public function selects($tab_name){
$this->tab_name = $tab_name;
$sql ="select *from {$tab_name}";
$rows=mysql_query($sql);
$arr =array();
while($row = mysql_fetch_array($rows)){
$arr[]=$row;
}
return $arr;
}
//获得一条记录(通过mysql_fetch_assoc获得关联数组,mysql_fetch_row获得额索引数组)
public function selectrow($tab_name,$cols){
$this->cols =$cols;
$sql ="select *from {$tab_name}";
$rows=mysql_query($sql);
$res = mysql_fetch_row($rows);
return $res;
}
}
?>
class db{
private $host;
private $user;
private $pass;
private $db_name;
private $sql;
private $tab_name;
private $cols;
//以上是属性的声明
public function __construct($host,$user,$pass,$db_name,$sql){
//构造函数会在实例化对象前调用这个方法,提供了一个契机:初始化属性
//如果实例化一个类的对象的时候 传递了参数,意味着向构造函数里传递参数
$this ->host = $host;
$this ->user = $user;
$this ->pass = $pass;
$this ->db_name = $db_name;
$this ->sql =$sql;
//以上是属性的初始化
$this ->connect();//调用方法函数
}
public function connect(){
//如果连接数据库成功返回一个标识,这个表示用来以后断开数据库的表示
mysql_connect($this->host,$this->user,$this->pass);
mysql_select_db($this->db_name);
mysql_query($this->sql);
}
//查询所有内容
public function selects($tab_name){
$this->tab_name = $tab_name;
$sql ="select *from {$tab_name}";
$rows=mysql_query($sql);
$arr =array();
while($row = mysql_fetch_array($rows)){
$arr[]=$row;
}
return $arr;
}
//获得一条记录(通过mysql_fetch_assoc获得关联数组,mysql_fetch_row获得额索引数组)
public function selectrow($tab_name,$cols){
$this->cols =$cols;
$sql ="select *from {$tab_name}";
$rows=mysql_query($sql);
$res = mysql_fetch_row($rows);
return $res;
}
}
?>