php mysql帮助类,基于PHP的MYSQL操作类

自己最常用的MYSQL操作类

class mysql

{

public $fetch_mode = MYSQL_BOTH;

public $record = array( );

public $count = NULL;

public function __construct( )

{

$this->connect( );

}

public function connect( )

{

if ( !( $this->link = mysql_connect( DB_HOST, DB_USER, DB_PASS ) ) )

{

exit( mysql_error( ) );

}

mysql_query( "SET NAMES UTF8" );

if ( !mysql_select_db( DB_DATE, $this->link ) )

{

exit( "未能找到数据库：".DB_DATE );

}

}

public function ping( )

{

if ( !mysql_ping( $this->link ) )

{

mysql_close( $this->link );

$this->connect( );

}

}

public function query( $sql )

{

mysql_query( "SET NAMES UTF8" );

return mysql_query( $sql );

}

public function num_rows( $result )

{

return mysql_num_rows( $result );

}

public function affected_rows( )

{

return mysql_affected_rows( );

}

public function num_fields( $result )

{

return mysql_num_fields( $result );

}

public function free_result( $result )

{

return mysql_free_result( $result );

}

public function insert_id( )

{

return mysql_insert_id( );

}

public function close( )

{

return mysql_close( );

}

public function fetch_array( $result )

{

if ( $result )

{

return mysql_fetch_array( $result, $this->fetch_mode );

}

}

public function fetch_row( $rs )

{

$this->record = mysql_fetch_array( $rs, $this->fetch_mode );

return $this->record;

}

public function fetch_all( $rs )

{

$arr = array( );

while ( $this->record = mysql_fetch_array( $rs, $this->fetch_mode ) )

{

$arr[] = $this->record;

}

return $arr;

}

}

?>