完整的PHP操作MySQL数据库类

1. class database
2. {
3. private $hostname;
4. private $user;
5. private $pass;
6. private $dbname;
7. private $linkflag;
8. private $charset;
10. function __construct()
11. {
12. $this->hostname="localhost";
13. $this->user="root";
14. $this->pass="111";
15. $this->dbname="";
16. $this->charset="utf8"; //gb2312 GBK utf8
17. $this->linkflag=mysql_connect($this->hostname,$this->user,$this->pass);
18. mysql_select_db($this->dbname,$this->linkflag) or die($this->error());
19. mysql_query("set names ".$this->charset);
20. }
22. function __set($property_name,$value)
23. {
24. return $this->$property_name=$value;
25. }
27. function __get($property_name)
28. {
29. if(isset($this->$property_name))
30. {
31. return $this->$property_name;
32. }
33. else return null;
34. }
36. function __call($function_name, $args)
37. {
38. echo "
    你所调用的方法 $function_name 不存在
    \n";
39. }
41. function query($sql)
42. {
43. $res=mysql_query($sql) or die($this->error());
44. return $res;
45. }
47. function fetch_array($res)
48. {
49. return mysql_fetch_array($res);
50. }
52. function fetch_object($res)
53. {
54. return mysql_fetch_object($res);
55. }
57. function fetch_obj_arr($sql)
58. {
59. $obj_arr=array();
60. $res=$this->query($sql);
61. while($row=mysql_fetch_object($res))
62. {
63. $obj_arr[]=$row;
64. }
65. return $obj_arr;
66. }
68. function error()
69. {
70. if($this->linkflag)
71. {
72. return mysql_error($this->linkflag);
73. }
74. else return mysql_error();
75. }
77. function errno()
78. {
79. if($this->linkflag)
80. {
81. return mysql_errno($this->linkflag);
82. }
83. else return mysql_errno();
84. }
86. function affected_rows()
87. {
88. return mysql_affected_rows($this->linkflag);
89. }
91. function num_rows($sql)
92. {
93. $res=$this->execute($sql);
94. return mysql_num_rows($res);
95. }
97. function num_fields($res)
98. {
99. return mysql_num_fields($res);
100. }
102. function insert_id()
103. {
104. $previous_id=mysql_insert_id($this->linkflag);
105. return $previous_id;
106. }
108. function result($res,$row,$field=null)
109. {
110. if($field===null)
111. {
112. $res=mysql_result($res,$row);
113. }
114. else $res=mysql_result($res,$row,$field);
115. return $res;
116. }
118. function version()
119. {
120. return mysql_get_server_info($this->linkflag);
121. }
123. function data_seek($res,$rowNum)
124. {
125. return mysql_data_seek($res,$rowNum);
126. }
128. function __destruct()
129. {
130. //mysql_close($this->linkflag);
131. }
133. }
135. ?>

复制代码

数据库类, PHP, MySQL