mysql資料庫連接類

<?php

 

代碼如下	複製代碼
$dbhost = 'localhost';    // 資料庫伺服器  $dbuser = 'root';     // 資料庫使用者名稱  $dbpw = 'qwaszx';             // 資料庫密碼  $dbname = 'movie';  // 資料庫名  $adminemail = 'haha@163.com'; // 系統管理員 Email     $database = 'mysql';  // 不能修改此處  $tplrefresh = 1;  // 模板自動重新整理開關 0=關閉, 1=開啟  $pconnect = 0;   // 資料庫連接方式 0=connect, 1=pconnect

 

// ============================================================================

代碼如下

複製代碼

class db_class {  var $querynum = 0;  //function dbstuff() { global $fp; $fp = fopen("./tempdata/dblog.txt", "w"); }  function connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect = 0) {   if($pconnect) {    if(!@mysql_pconnect($dbhost, $dbuser, $dbpw)) {     $this->halt('Can not connect to MySQL server');    }   } else {    if(!@mysql_connect($dbhost, $dbuser, $dbpw)) {     $this->halt('Can not connect to MySQL server');    }   }   mysql_query("SET NAMES 'GB2312'");//www.111cn.net  }  function select_db($dbname) {   return mysql_select_db($dbname);  }  function fetch_array($query, $result_type = MYSQL_ASSOC){   $query = mysql_fetch_array($query, $result_type);   return $query;  }  function query($sql, $silence = 0) {   //echo "|$sql|<br>"; //debug   //@fwrite($GLOBALS[fp], $sql." "); //debug   $query = mysql_query($sql);         //echo 'query:'.$query.'<br>';      if(!$query && !$silence)         {          $this->halt('MySQL Query Error', $sql);   }         $this->querynum++;   return $query;  }  function unbuffered_query($sql, $silence = 0) {   $func_unbuffered_query = @function_exists('mysql_unbuffered_query') ? 'mysql_unbuffered_query' : 'mysql_query';   $query = $func_unbuffered_query($sql);   if(!$query && !$silence) {    $this->halt('MySQL Query Error', $sql);   }   $this->querynum++;   return $query;//www.111cn.net  }  function get_one($sql){         $SQL=$sql;   if(function_exists('mysql_unbuffered_query')){    $query = mysql_unbuffered_query($SQL);   }else{    $query = mysql_query($SQL);   }   $this->querynum++;   if (!$query)  $this->halt('Query Error: ' . $SQL);      $rs =& mysql_fetch_array($query, MYSQL_ASSOC);   mysql_free_result($query);   return $rs;  }  function affected_rows() {   return mysql_affected_rows();  }  function error() {   return mysql_error();  }  function errno() {   return mysql_errno();  }  function result($query, $row) {   $query = @mysql_result($query, $row);   return $query;www.111cn.net  }  function num_rows($query) {   $query = mysql_num_rows($query);   return $query;  }  function num_fields($query) {   return mysql_num_fields($query);  }  function free_result($query) {   return mysql_free_result($query);  }  function insert_id() {   $id = mysql_insert_id();   return $id;  }  function fetch_row($query) {   $query = mysql_fetch_row($query);   return $query;  }  function close() {   return mysql_close();  }  function halt($message = '', $sql = '') {           echo $message;               } }

/***********************************************************/
// ========= 串連資料庫 =====================www.111cn.net==================================

代碼如下	複製代碼
$db = new db_class; $db->connect($dbhost, $dbuser, $dbpw, $pconnect); $db->select_db($dbname); unset($dbhost, $dbuser, $dbpw, $dbname, $pconnect);