数据库类php,数据库操作类（PHP/mysql）

var$dbhostname;

var$dbname;

var$dbuser;

var$dbpassword;

var$connid;

var$query;

var$result;

var$resultid;

var$insertid;

var$rows;

var$errCode&＃61;0;

var$errString&＃61;"";

var$debugString&＃61;"";

var$xml&＃61;"";/* 构造函数 */functionDatabase()

{$this->dbhostname&＃61;"localhost";//登录数据库主机名$this->dbname&＃61;"yourdb";/数据库名$this->dbuser&＃61;"root";//数据库登录用户名$this->dbpassword&＃61;"";//数据库登录密码$this->_connect();//连接数据库$this->_db_select();//选择数据库}/* 数据库执行函数, $type 执行操作类型, ""为查询, "update"为更新, "insert"为插入, "delete"为删除 */functiondb_query($sql,$type)

{$this->query&＃61;$sql;

if ($this->_query())

{

if(empty($type))

{$this->_num_rows();//返回查询的函数$this->result&＃61;$this->_fetch_array();//返回查询结果}

if ($type&＃61;&＃61;"insert")

{$this->insertid&＃61;&＃64;mysql_insert_id();//返回插入的ID自动增量}

returntrue;

}

else

returnfalse;

}/* 数据库结果生成XML */functioncreateXML($itemroot&＃61;"child",$item&＃61;"root")

{$dom&＃61; newDOMDocument("1.0","utf-8");$dom->preserveWhiteSpace&＃61;false;$dom->formatOutput&＃61;true;$rootNode&＃61;$dom->createElement($item);

for($i&＃61;0;$iresult);$i&＃43;&＃43;)

{$itemNode&＃61;$dom->createElement($itemroot);

foreach($this->result[$i] as$key&＃61;>$value)

{//$value &＃61; iconv("gb2312","utf-8",$value);$tmpNode&＃61;$dom->createElement($key,$value);$itemNode->appendChild($tmpNode);

}$rootNode->appendChild($itemNode);

}$dom->appendChild($rootNode);

if ($this->xml&＃61;$dom->saveXML())

return$this->xml;

else

returnfalse;

}/* 连接数据库 */function_connect()

{$this->connid&＃61; &＃64;mysql_connect($this->dbhostname,$this->dbuser,$this->dbpassword);

if (false&＃61;&＃61;$this->connid)

{$this->errCode&＃61;1;$this->errString&＃61;"不能连接数据库&＃xff01;";$this->debugString&＃61;"不能连接数据库: ".mysql_error();$this->showErr();

returnfalse;

}

else

returntrue;

}/* 选择数据库 */function_db_select()

{$selectFlag&＃61; &＃64;mysql_select_db($this->dbname,$this->connid);

if (false&＃61;&＃61;$selectFlag)

{$this->errCode&＃61;2;$this->errString&＃61;"不能选择数据库&＃xff01;";$this->debugString&＃61;"不能选择数据库: ".$this->dbname;$this->showErr();

returnfalse;

}

else

returntrue;

}/* 数据库查询语句 */function_query()

{$this->resultid&＃61; &＃64;mysql_query($this->query,$this->connid);

if (false&＃61;&＃61;$this->resultid)

{$this->errCode&＃61;3;$this->errString&＃61;"数据库查询语句错误&＃xff01;";$this->debugString&＃61;"数据库查询语句错误: ".$this->query.mysql_error();$this->showErr();

returnfalse;

}

else

returntrue;

}/* 返回查询记录总数 */function_num_rows()

{$this->rows&＃61; &＃64;mysql_num_rows($this->resultid);

}/* 返回结果数组 */function_fetch_array()

{

if ($this->errCode!&＃61;3)

{$tmpResult&＃61;"";$i&＃61;0;

while ($row&＃61;mysql_fetch_array($this->resultid,MYSQL_ASSOC))

{$tmpResult[$i] &＃61;$row;$i&＃43;&＃43;;

}//end while.return empty($tmpResult) ?NULL:$tmpResult;

}

}/* 显示错误信息 $debugString用于调试&＃xff0c;$errString用于给客户显示 */functionshowErr()

{//echo $this->debugString."/n";}/* 关闭连接&＃xff0c;释放内存 */functionclose()

{

&＃64;mysql_free_result($this->resultid);

&＃64;mysql_close($this->connid);

}

function__destruct()

{

if($this->connid)

{$this->close();

}

}

}/* 数据库查询类  end*/?>