分享一个PHP连接sql server的类

大家平常见的最多的是php连接mysql的类，今天给大家分享一个php连接sql server的类。 感兴趣的朋友可以参考下。

3. class DB_Handle {

4. var $ClassName = "DB_Handle";
5. var $Server;
6. var $UserName;
7. var $Password;
8. var $Database;
9. var $LinkID = 0;
10. var $QueryResult = "";
11. var $LastInsertID = "";
12. /* private ignore=>ignore the error and continue, halt=>report the error and halt, report=>report the error and continue */
13. var $Halt_On_Error = "report";
14. var $Error = "";
15. var $ErrNo = 0;
16. /**public
17. * remark: This is the db_mysql_class's structure
18. * function: Set the server,username,password,database variable.
19. */
20. function DB_Handle($server = "", $username = "", $password = "", $database = "") {
21. $this->Server = $server;
22. $this->UserName = $username;
23. $this->Password = $password;
24. $this->Database = $database;
25. }
26. /**public
27. * function: Connect database and select database
28. * success: retun 1
29. * failed: return 0
30. */
31. function connect() {
32. $this->LinkID = @mssql_pconnect ( $this->Server, $this->UserName, $this->Password );
33. if (! $this->LinkID) {
34. $this->halt ( "mssql_pconnect($this->Server,$this->UserName,$this->Password): Failed" );
35. return 0;
36. }
37. if (! @mssql_select_db ( $this->Database )) {
38. $this->halt ( "mssql_select_db($this->Database) Failed." );
39. return 0;
40. }
41. return 1;
42. }
43. /**public
44. * function: Check the database, if exist then select
45. * exist: return 1
46. * not exist: return 0
47. */
48. function selectDatabase() {
49. if (@mssql_select_db ( $this->Database ))
50. return 1;
51. else
52. return 0;
53. }
54. /**public
55. * function: Execute SQL instruction
56. * success: return SQL Result.
57. * failed: return 0;
58. */
59. function execQuery($sql = "") {
60. $this->connect();
61. if ($this->LinkID == 0) {
62. $this->halt ( "Execute SQL Failed: Have not valid database connect." );
63. return 0;
64. }
65. ob_start ();
66. $this->QueryResult = mssql_query ( $sql, $this->LinkID );
67. $error = ob_get_contents ();
68. ob_end_clean ();
69. if ($error) {
70. $this->halt ( "Execute SQL: mssql_query($sql,$this->LinkID) failed." );
71. return 0;
72. }
73. $reg = "#insert into#";
74. if (preg_match ( $reg, $sql )) {
75. $sql = "select @@IDENTITY as id";
76. $res = mssql_query ( $sql, $this->LinkID );
77. $this->LastInsertID = mssql_result ( $res, 0, id );
78. }
79. return $this->QueryResult;
80. }
82. /**public
83. * function: Get the query result's row number
84. * success: return the row fo the Result
85. * failed: return 0
86. */
87. function getTotalRowNum($result = "") {
88. if ($result != "")
89. $this->QueryResult = $result;
90. $row = @mssql_num_rows ( $this->QueryResult );
91. if ($row >= 0)
92. return $row;
93. $this->halt ( "Get a row of result Failed: Result $result is invalid." );
94. return 0;
95. }
97. /**public
98. * function: Get the last insert record's id
99. * success: return id
100. * failed: return 0
101. */
102. function lastInsertID() {
103. return $this->LastInsertID;
104. }
106. /**public
107. * function: Get a field's value
108. * success: return value of the field
109. * failed: return 0
110. */
111. function getField($result = "", $row = 0, $field = 0) {
112. if ($result != "")
113. $this->QueryResult = $result;
114. $fieldvalue = @mssql_result ( $this->QueryResult, $row, $field );
115. if ($fieldvalue != "")
116. return $fieldvalue;
117. $this->halt ( "Get field: mssql_result($this->QueryResult,$row,$field) failed." );
118. return 0;
120. //Here should have error handle
121. }
123. /**public
124. * function: Get next record
125. * success: return a array of the record's value
126. * failed: return 0
127. */
128. function nextRecord($result = "") {
129. if ($result != "")
130. $this->QueryResult = $result;
131. $record = @mssql_fetch_array ( $this->QueryResult );
132. if (is_array ( $record ))
133. return $record;
134. //$this->halt("Get the next record Failed: the Result $result is invalid.");
135. return 0;
136. }
138. /**public
139. * function: Free the Query Result
140. * success return 1
141. * failed: return 0
142. */
143. function freeResult($result = "") {
144. if ($result != "")
145. $this->QueryResult = $result;
146. return @mssql_free_result ( $this->QueryResult );
147. }
149. /**public
150. * function: Set the Halt_On_Error's state
151. * success: return 1
152. * failed: return 0
153. */
154. function setHaltOnError($state = "ignore") {
155. if (! ($state == "ignore" || $state == "report" || $state == "halt")) {
156. $this->halt ( "Set the Halt_On_Error Fail: There is no state value $state" );
157. return 0;
158. }
159. $this->Halt_On_Error = $state;
160. return 1;
161. }
163. /**public
164. * function: Get the Halt_On_Error's state
165. */
166. function getHaltOnError() {
167. return $this->Halt_On_Error;
168. }
170. /**public
171. * function: Get the class's name
172. */
173. function toString() {
174. return $this->ClassName;
175. }
177. /**private
178. * function: Error handle
179. */
180. function halt($msg) {
181. $this->Error = @mysql_error ( $this->LinkID );
182. $this->ErrNo = @mysql_errno ( $this->LinkID );
183. if ($this->Halt_On_Error == "ignore")
184. return;
185. $this->makeMsg ( $msg );
186. if ($this->Halt_On_Error == "halt")
187. die ( "Session halted" );
188. }
190. /**private
191. * function: Make error information and print
192. */
193. function makeMsg($msg) {
194. printf ( "Database error: %s\n", $msg );
195. printf ( "MySQL Error: %s (%s)\n", $this->ErrNo, $this->Error );
196. }
197. }

复制代码