Practical and simple mysql database connection class

Practical and simple mysql database connection class_PHP tutorial

WBOY

Release： 2016-07-13 17:04:03

Original

922 people have browsed it

实用简单的mysql教程数据库教程连接类
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")."|$sqlrn");
// @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);
  }
}
}