PHP连接数据库类

PHP连接数据库类

Class MySQLDB
{
var $host;
var $user;
var $passwd;
var $database;
var $conn;
//利用构造函数实现变量初始化
//同时连接数据库操作
function MySQLDB($host,$user,$password,$database)
{
$this->host = $host;
$this->user = $user;
$this->passwd = $password;
$this->database = $database;
$this->conn=mysql_connect($this->host, $this->user,$this->passwd) or die("Could not connect to $this->host");
mysql_select_db($this->database,$this->conn) or die("Could not switch to database $this->database");
mysql_query("set names 'gbk'");
}
//该函数用来关闭数据库连接
function Close()
{
MySQL_close($this->conn);
}

//该函数实现数据库查询操作
function Query($queryStr)
{
$res =Mysql_query($queryStr, $this->conn) or die("Could not query database");
return $res;
}

//该函数返回记录集
function getRows($res)
{
    $rowno = 0;
    $rowno = MySQL_num_rows($res);
    if($rowno>0)
    {
    for($row=0;$row<$rowno;$row++ )
         {
            $rows[$row]=MySQL_fetch_array($res);
            //本来为MySQL_fetch_row,但是不能以数组的方式来提取,只能用索引
            //这样可以用索引和名称,更为方便
         }
         return $rows;
      }
    }

//该函数取回数据库记录数

function getRowsNum($res)
{
   $rowno = 0;
   $rowno = mysql_num_rows($res);
   return $rowno;
}

//该函数返回数据库表字段数
function getFieldsNum($res)

{
    $fieldno = 0;
    $fieldno = mysql_num_fields($res);
    return $fieldno;
}

//该函数返回数据库表字段名称集
function getFields($res)
{
$fno = $this->getFieldsNum($res);
   if($fno>0)
      {
         for($i=0;$i<$fno;$i++ )
         {
            $fs[$i]=MySQL_field_name($res,$i);//取第i个字段的名称
         }
         return $fs;
      }
}
}

下面为实例

$SqlDB = new MySQLDB("127.0.0.1","root","123456","message_book");
$sql = "select * from ad_guestbook";
$result = $SqlDB->Query($sql);//查询
$rs = $SqlDB->getRows($result);//获得记录集
$num = $SqlDB->getRowsNum($result);//获得记录数
$name = $SqlDB->getFields($result);
$namenum = $SqlDB->getFieldsNum($result);

for($i=0;$i<$num;$i++){

   echo ($rs[$i]["id"])."    " .($rs[$i]["typeid"]).($rs[$i]["title"])."    "
         .($rs[$i]["content"])."    ".($rs[$i]["name"])."    ".($rs[$i]["time"])."    "
         .($rs[$i]["typeid"])."    ".($rs[$i]["time_1"])."<p>";
}