mysql 数据库类

<?php
/**
* mysql class by [email=guojx@2008-01-09]guojx@2008-01-09[/email]
*
*/
class MySqlBase
{
/**
  * 构造
  * @param string $conn is mysql handle
  * @param string localhost
  * @param string user
  * @param string password
  * @param string basename
  *
  */
private $conn;
private $rowset = array();
function __construct($localhost,$user,$password,$basename,$commitmode = true)
{
  $this->conn = mysqli_connect($localhost,$user,$password);  
  if($this->conn)
  {
   mysqli_select_db($this->conn, $basename);
   mysqli_query($this->conn, "set names utf8");
   if(!$commitmode)
   {
    mysqli_autocommit($this->conn, $commitmode);
   }
  }
}

/**
  * 析够
  *
  */

function __destruct()
{
  mysqli_close($this->conn);
  $this->conn = null;
}

/**
  * 执行数据查询并返回查询数据
  *
  * @param string $sql
  * @return array
  */
function Search($sql)
{
  $res = mysqli_query($this->conn, $sql);
  if($res)
  {
   while ($row = mysqli_fetch_array($res))
   {
    $rowset[] = $row;
   }
   mysqli_free_result($res);
   return $rowset;
  }
  else
  {
   return null;
  }
}

/**
  * 执行mysql语句，成功返回true失败返回false
  *
  * @param string $sql
  * @return bool
  */
function Execute($sql)
{
  if(@mysqli_query($this->conn, $sql))
  {
   return true;
  }
  else
  {
   return false;
  }
}

/**
  * 获取刚插入记录的id值
  *
  * @return mixed
  */
function GetInsertID()
{
  return mysqli_insert_id($this->conn);
}

/**
  * 提交
  *
  * @return bool
  */
function Commit()
{
  return mysqli_commit($this->conn);
}

/**
  * 回滚
  *
  * @return bool
  */
function RollBack()
{
  return mysqli_rollback($this->conn);
}
function getError(){
  return mysqli_error($this->conn);
}
}
?>