include/Db_mysql.php 2008-03-23 17:45
<?php
/*********************/
/* */
/* Version : 5.1.0 */
/* Author : RM */
/* Comment : 071223 */
/* */
/*********************/
class db_mysql
{
var $querycount = 0;//查询数
var $pagetime;//页面时间
//连接数据库
function connect( $Host, $User, $Password, $Pconnect = 0 )
{
if ( $Pconnect )
{
if ( !mysql_pconnect( $Host, $User, $Password ) )
{
db_mysql::halt( "MYSQL 数据库无法连接,如果确认服务器没问题请检查程序设置" );
}
}
else if ( !mysql_connect( $Host, $User, $Password ) )
{
db_mysql::halt( "MYSQL 数据库无法连接,如果确认服务器没问题请检查程序设置" );
}
}
//选择数据库
function select_db( $Database )
{
return mysql_select_db( $Database );
}
//查询数据库
function query( $sql )
{
$query = mysql_query( $sql );
if ( $query )
{
++$this->querycount;
}
else
{
db_mysql::halt( "MYSQL QUERY 错误", $sql );
}
return $query;
}
function fetch_array( $query, $type = MYSQL_ASSOC )
{
$nu = mysql_fetch_array( $query, $type );
return $nu;
}
function fetch_object( $query, $type = MYSQL_ASSOC )
{
$nu = mysql_fetch_object( $query, $type );
return $nu;
}
function fetch_row( $query )
{
$nu = mysql_fetch_row( $query );
return $nu;
}
function result( $query, $row )
{
$nu = mysql_result( $query, $row );
return $nu;
}
function num_rows( $query )
{
$num = mysql_num_rows( $query );
return $num;
}
function affected_rows( )
{
return mysql_affected_rows( );
}
function num_fields( $query )
{
return mysql_num_fields( $query );
}
function free_result( $query )
{
return mysql_free_result( $query );
}
function insert_id( )
{
$id = mysql_insert_id( );
return $id;
}
function error( )
{
return mysql_error( );
}
function errno( )
{
return mysql_errno( );
}
function close( )
{
return mysql_close( );
}
//显示错误的详细信息并停止
function halt( $msg, $sql = "" )
{
$date = date( "Y-m-d H:i:s", time( ) );
$errormsg = "时间:".$date."<br>";
$errormsg .= "提示:".$msg."<br>";
$errormsg .= "前当地址:".$_SERVER['REQUEST_URI']."<br>";
if ( $sql )
{
$errormsg .= "SQL 语句: ".htmlspecialchars( $sql )."<br>";
}
$errormsg .= "错误:".db_mysql::error( )."<br>";
$errormsg .= "错误号:".db_mysql::errno( )."<br>";
echo $errormsg;
exit( );
}
//现在时间
function nowtime( )
{
$array = explode( " ", microtime( ) );
$time = $array[0] + $array[1];
return $time;
}
//查询总数
function querycount( )
{
return $this->querycount;
}
}
?>