分享一个PHP连接sqlserver的类

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

3. <?php

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