PHP database and Operation instances

PHP database and Operation instances are not very powerful, but they are quite convenient to use.

PHP database and Operation instances are not very powerful, but they are quite convenient to use.
Db. class. php

PHP code

2. /**
3. * Database
4. */
5. Class DataBase
6. {
7. Var $ pConnect = FALSE; // whether to use persistent connections
8. Var $ mHost; // database host
9. Var $ mDatabase;
10. Var $ db; // Database
11. Var $ mUser; // database username
12. Var $ mPwd; // database user password
13. Var $ mConn; // Connection ID
14. Var $ result; // result resource ID for executing the query command
15. Var $ num_rows; // number of returned entries
16. Var $ insert_id; // returns the ID of the last INSERT command.
17. Var $ affected_rows; // number of columns affected by the query command returned
18. // The number of columns (row) affected by INSERT, UPDATE, or DELETE.
19. // If delete does not contain the where clause, 0 is returned.
20. // Constructor
21. Public function _ construct ($ host, $ user, $ pwd, $ db)
22. {
23. $ This-> mHost = $ host;
24. $ This-> mUser = $ user;
25. $ This-> mPwd = $ pwd;
26. $ This-> db = $ db;
27. }
29. // Database connection
30. Public function connect ()
31. {
32. If ($ this-> pConnect)
33. $ This-> mConn = mysql_pconnect ($ this-> mHost, $ this-> mUser, $ this-> mPwd); // persistent connection
34. Else
35. $ This-> mConn = mysql_connect ($ this-> mHost, $ this-> mUser, $ this-> mPwd); // short connect
37. If (! $ This-> mConn) $ this-> dbhalt ("cannot connect to the database! ");
38. If ($ this-> db = "") $ this-> db = $ this-> dbDatabase;
40. If (! Mysql_select_db ($ this-> db, $ this-> mConn ))
41. $ This-> dbhalt ("The database is unavailable! ");
42. } // Eof # dbconnect ()
44. // Change the database
45. Public function dbChange ($ db ){
46. $ This-> db = $ db;
47. $ This-> connect ();
48. }
50. // Execute the SQL statement and return the result resource id
51. Public function execute ($ SQL ){
52. $ This-> result = mysql_query ($ SQL );
53. Return $ this-> result;
54. }
56. // Retrieve array-index and association
57. Public function fetchArray ($ resultType = MYSQL_BOTH)
58. {
59. Return mysql_fetch_array ($ this-> result, $ resultType );
60. }
62. // Obtain the associated array
63. Public function fetchAssoc ()
64. {
65. Return mysql_fetch_assoc ($ this-> result );
66. }
68. // Obtain the number index array
69. Public function fetchIndexArray ()
70. {
71. Return mysql_fetch_row ($ this-> result );
72. }
74. // Obtain the object array
75. Public function fetchObject ()
76. {
77. Return mysql_fetch_object ($ this-> result );
78. }
80. // Number of returned Records
81. Function numRows ()
82. {
83. Return mysql_num_rows ($ this-> result );
84. }
86. // Return all database names in the host
87. Public function dbNames ()
88. {
89. $ RsPtr = mysql_list_dbs ($ this-> mConn );
90. $ I = 0;
91. $ Cnt = mysql_num_rows ($ rsPtr );
92. While ($ I <$ cnt)
93. {
94. $ Rs [] = mysql_db_name ($ rsPtr, $ I );
95. $ I ++;
96. }
97. Return $ rs;
98. }
100. Function dbhalt ($ errmsg ){
101. $ Msg = "database error! ";
102. $ Msg = $ errmsg;
103. Echo "$ msg ";
104. Die ();
105. }
107. // Delete
108. Function delete ($ SQL ){
109. $ Result = $ this-> execute ($ SQL, $ dbbase );
110. $ This-> affected_rows = mysql_affected_rows ($ this-> dbLink );
111. $ This-> free_result ($ result );
112. Return $ this-> affected_rows;
113. }
115. // Add
116. Function insert ($ SQL ){
117. $ Result = $ this-> execute ($ SQL, $ dbbase );
118. $ This-> insert_id = mysql_insert_id ($ this-> dbLink );
119. $ This-> free_result ($ result );
120. Return $ this-> insert_id;
121. }
123. // Modify
124. Function update ($ SQL ){
125. $ Result = $ this-> execute ($ SQL, $ dbbase );
126. $ This-> affected_rows = mysql_affected_rows ($ this-> dbLink );
127. $ This-> free_result ($ result );
128. Return $ this-> affected_rows;
129. }
131. // Close the connection
132. Function dbclose (){
133. Mysql_close ($ this-> dbLink );
134. }
135. } // End class
136. ?>

Directly reference:

 

PHP code

2. Include "db. class. php ";
4. $ Mydb = new DataBase ("localhost", "root", "123456", "test ");
5. $ Mydb-> connect ();
6. $ Mydb-> execute ("set names GBK ");
7. $ Mydb-> execute ("select * from usrs ");
8. Print_r ($ mydb-> dbNames ());
9. ?>