[原創]php資料庫連接類_PHP教程

[原創]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.="".$value[1]."n";
}
$Db->close();
return $str;
}

本站原創轉戴載註明 www.111cn.cn

http://www.bkjia.com/PHPjc/445022.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/445022.htmlTechArticle[原創]php資料庫連接類 ?php class Db{ public $conn; public $root='localhost'; public $user='root'; public $pass='root'; public $db='111cn.cn'; public $charset='gb2312'; publ...

