一聚教程网:一个值得你收藏的教程网站

热门教程

实用简单的mysql 数据库连接类

时间:2022-07-02 09:27:59 编辑:袖梨 来源:一聚教程网

class DB
{
 //database connection
 var $con = FALSE;

 function DB($MYSQL_HOST=MYSQL_HOST, $MYSQL_USER=MYSQL_USER, $MYSQL_PASS=MYSQL_PASS,$MYSQL_DB=MYSQL_DB)
 {
  $this->con = @mysql_connect($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS) or die("Could not connect to database");

  if ($this->con)
  {
   @mysql_select_db($MYSQL_DB, $this->con) or die ("Could not select database");
  }

  return $this->con;
 }


 function Query($sql, $tran = false)
 {
 // if (!file_exists(MYSQL_LOG))
 // {
 //  @umask(0);
 //  @mkdir(MYSQL_LOG, 0777);
 // }

  // ¼־
  //$fp = @fopen(MYSQL_LOG.date("Ymd").".txt", "a");

  // д־
 // @fwrite($fp, date("Y-m-d H:i:s")."|$sql ");
 // @fclose($fp);

  $this->sql = $sql;

  if ($tran)
  {
   $this->result = @mysql_query($this->sql) OR $this->RollBack();
   return $this->result;
  }
  else
  {
      mysql_query("SET NAMES 'utf8'");
   //mysql_query("SET NAMES 'gbk'");
   $this->result = @mysql_query($this->sql);
   return $this->result;
  }
 }


 function RollBack()
 {
  $this->Query("ROLLBACK;");
  die("MySQL ROLLBACK;");
 }


 function NumRows($result)
 {
  $this->result = $result;
  return @mysql_num_rows($this->result);
 }


 function FetchRow($result)
 {
  $this->result = $result;
  return @mysql_fetch_row($this->result);
 }


 function FetchArray($result)
 {
  $this->result = $result;
  return @mysql_fetch_array($this->result, MYSQL_ASSOC);
 }
 function FetchArray2($result)
 {
  $this->result = $result;
  return @mysql_fetch_array($this->result, MYSQL_BOTH);
 }
 

 function FetchObject($result)
 {
  $this->result = $result;
  return @mysql_fetch_object($this->result);
 }


 function FreeResult($result)
 {
  $this->result = $result;
  return @mysql_free_result($this->result);
 }

 function DataSeek($result)
 {
 //复位记录集指针
  $this->result = $result;
  return mysql_data_seek($this->result,0);
 }
 
 function InsertID()
 {
  //$this->con = $con;
  return @mysql_insert_id($this->con);
 }


 function Close()
 {
  if($this->con)
  {
   @mysql_close($this->con);
  }
 }
}

热门栏目