php 中用于操作 MySQL 数据库的类
db.php
PHP Code 复制内容到剪贴板
1. <?php
2. /*
3. * mysql 数据库 DB 类
4. * @package db
5. * @author 9streets
6. * @version 2010-11-09
7. * @copyrigth http://www.9streets.cn/
8. */
9. class db {
10.
var $connection_id = "";
11. var $pconnect = 0;
12. var $shutdown_queries = array();
13. var $queries = array();
14. var $query_id = "";
15. var $query_count = 0;
16. var $record_row = array();
17. var $failed = 0;
18. var $halt = "";
19. var $query_log = array();
20. function connect($db_config){
21. if ($this->pconnect){
22. $this->connection_id = mysql_pconnect($db_config["hostname"], $db_confi
g["username"], $db_config["password"]);
23. }else{
24. $this->connection_id = mysql_connect($db_config["hostname"], $db_config[
"username"], $db_config["password"]);
25. }
26. if ( ! $this->connection_id ){
27. $this->halt("Can not connect MySQL Server");
28. }
29. if ( ! @mysql_select_db($db_config["database"], $this->connection_id) ){
30. $this->halt("Can not connect MySQL Database");
31. }
32. if ($db_config["charset"]) {
33. @mysql_unbuffered_query("SET NAMES '".$db_config["charset"]."'");
34. }
35. return true;
36. }