[原创]php数据库连接类_PHP教程
- WBOY原创
- 2016-07-20 11:06:40910浏览
[原创]php数据库连接类
class Db{
public $conn;
public $root='localhost';
public $user='root';
public $pass='root';
public $db='111cn.cn';
public $charset='gb2312';
public $links='c';
function __construct() {
$this->connect();
}
function connect()
{
try{
if( 'p' == $this->links )
{
$this->conn = mysql_pconnect($this->root,$this->user,$this->pass) or die(mysql_error());
}
else
{
$this->conn = mysql_connect($this->root,$this->user,$this->pass) or die( mysql_error());
}
mysql_select_db($this->db,$this->conn);
mysql_query("set Names '$this->charset'");
}catch (Exception $e){
echo '数据库连接失败，请联系相关人员!';
exit;
}
}
/*
query
*/
function query($sql)
{
$this->row = mysql_query( $sql,$this->conn ) or die( mysql_error());
return $this->row;
}
/*
mysql_num_rows total
*/
function rows($row)
{
return mysql_num_rows( $row );
}
/*
get data store array
*/
function fetch($row,$tag=1)
{
if(1 == $tag )
{
return mysql_fetch_array( $row );
}
else
{
$array =array();
while( $rs = mysql_fetch_array( $row ) )
{
$array[] = $rs;
}
}
return $array;
}
/*
取得刚插入的ID号
*/
function insert_id()
{
return @mysql_insert_id($this->row);
}
//close current database link
function close()
{
return @mysql_close($this->conn);
}
//test mysql version
function version()
{
$query = @mysql_query("SELECT VERSION()",$this->conn);
return @mysql_result($this->$row, 0);
}
}
?>
调用方法。
/*
读取新闻分类
*/
function newOption()
{
$str='';
$Db = new Db();
$query = $Db->query("Select id,typetitle,typeupid,orderid from cn_111cn where typeupid=0 order by orderid asc");
$row = $Db->fetch($query,0);
foreach( $row as $_v => $value )
{
$str.="n";
}
$Db->close();
return $str;
}
本站原创转戴载注明 www.111cn.cn