简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

Some summaries about php connecting to mssql

WBOY
Release： 2016-07-25 09:04:34
Original
917 people have browsed it
  2. $conn=mssql_connect("Instance name or server IP","Username","Password");
  4. //Test the connection
  5. if($conn)
  6. {
  7. echo "Connection successful";
  8. }
Copy code

2. Select the database to connect to

  2. mssql_select_db("dbname");
Copy code

3. Execute query

  2. $rs = mssql_query("select top 1 id,username from tbname",$conn);
  3. Or directly execute update, insert and other statements without assigning values ​​to the returned results
  4. mssql_query("update tbname set username ='niunv' where id=1");
Copy code

4. Get the number of rows in the record set

  2. echo mssql_num_rows($rs);
Copy code

5. Get the record set

  2. if($row=mssql_fetch_array($rs))
  3. {
  4. $id = $row[0];//Get the ID field value
  5. $username = $row[1];//Get the username field Value
  6. }
Copy code

6. Get the ID of the new record Set the id field to the IDENTITY field, and after executing the insert statement, a @@IDENTITY global variable value will be generated, and the query will be the ID of the last newly added record.

  2. mssql_query("insert into tbname(username) values ​​('nv')",$conn);
  3. $rs = mssql_query("select @@IDENTITY as id",$conn);
  4. if($ row=mssql_fetch_array($rs))
  5. {
  6. echo $row[0];
  7. }
Copy code

7. Release the record set //More

  2. mssql_free_result($rs);
Copy code

8. Close the connection

  2. mssql_close($conn);
Copy code

Note: It is easier to use PHP to operate MSSQL than to connect to MYSQL in ASP. Therefore, when MSSQL and MYSQL need to coexist, it is easier and easier to use PHP to connect to MSSQL to operate MYSQL and MSSQL. If ASP is to connect to MYSQL, you need to install a MYSQL driver. , the default windows ODBC is not installed, unfortunately...

1. Install at least mssql client on the web server 2. Open php.ini and remove the semicolon in front of;extension=php_mssql.dll If necessary: ​​extension_dir needs to be specified 3. It is recommended to use php

  2. /**
  3. *mssql database connection class
  4. **/
  5. class SQL{
  7. var $server;
  8. var $userName;
  9. var $passWord;
  10. var $dataBase;
  12. var $linkID = 0;
  13. var $queryResult;
  14. var $lastInsertID;
  16. var $pageNum = 0;//分页用---共有几条数据
  17. var $ER;
  19. /**
  20. *Constructor
  21. **/
  22. function SQL($Server='',$UserName='',$PassWord='',$DataBase=''){
  23. $this->server = $Server;
  24. $this->userName = $UserName;
  25. $this->passWord = $PassWord;
  26. $this->dataBase = $DataBase;
  27. }
  28. /**
  29. *Database connection
  30. **/
  31. function db_connect(){
  32. $this->linkID = mssql_pconnect($this->server,$this->userName,$this->passWord);
  33. if(!$this->linkID){
  34. $this->ER = "db_connect($this->server,$this->userName,$this->passWord) error";
  35. return 0;
  36. }
  37. if (!mssql_select_db($this->dataBase,$this->linkID)) {
  38. $this->ER = "mssql_select_db($this->dataBase,$this->lastInsertID) error";
  39. return 0;
  40. }
  41. return $this->linkID;
  42. }
  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. }
  56. /**
  57. *Data operation
  58. **/
  59. function query($Str){
  60. if ($this->linkID == 0) {
  61. $this->ER = "数据库还没有连接！！";
  62. }
  64. $this->queryResult = mssql_query($Str);
  65. //$this->queryResult = mssql_query($Str,$this->linkID);
  66. if (!$this->queryResult) {
  67. $this->ER = "$Str.没有操作成功,query error！！";
  68. return 0;//********************For errors in PHP 4.3.9 and above, use 1
  69. }
  70. return $this->queryResult;
  71. }
  73. /**
  74. *Data acquisition
  75. **/
  76. function fetch_array($result){
  77. if($result != "") $this->queryResult = $result;
  78. $rec =mssql_fetch_array($this->queryResult);
  80. if(is_array($rec)){
  81. return $rec;
  82. }
  84. //$this->ER = "没有获取数据！";
  85. return 0;
  86. }
  88. /**public
  89. * function: Free the Query Result
  90. * success return 1
  91. * failed: return 0
  92. */
  93. function freeResult($result=""){
  94. if($result != "") $this->queryResult = $result;
  95. return mssql_free_result($this->queryResult);
  96. }
  98. /**
  99. *Get the number of affected rows
  100. *Get the number of operated rows
  101. **/
  102. function num_rows($result=""){
  103. if ($result != "") {
  104. $this->queryResult = $result;
  105. $row = mssql_num_rows($this->queryResult);
  106. return $row;
  107. }
  108. }
  110. /**
  111. *Get query results---Multiple
  112. **/
  113. function result_ar($str=''){
  114. if (empty($str)) {
  115. return 0;
  116. }
  117. $back = array();
  118. $this->queryResult = $this->query($str);
  120. while ($row = $this->fetch_array($this->queryResult)) {
  121. $back[] = $row;
  122. }
  123. return $back;
  124. }
  126. /**
  127. *Database information paging
  128. *$Result database operation
  129. *str ==sql statement
  130. *page ==Which page
  131. *showNum ==How many pages to display
  132. */
  133. function page($Str,$Page=0,$ShowNum=5){
  134. $back = array();//返回数据
  135. $maxNum = 0;
  136. if ($Str == "") {
  137. $this->ER = "没有数据";
  138. return 0;
  139. }
  140. $this->queryResult = $this->query($Str);
  141. if($this->queryResult){
  142. if($Page==""){
  143. $nopa=0;
  144. }else{
  145. $nopa = ($Page-1)*$ShowNum;
  146. if ($nopa<0) {
  147. $nopa = 0;
  148. }
  149. }
  150. $maxNum=$this->num_rows($this->queryResult);
  151. $k=0;
  152. $i=0;
  153. $dd=$this->fetch_array($this->queryResult);
  155. while($dd&&$nopa<=$maxNum&&$i<$ShowNum){
  156. if($nopa >= $maxNum) $nopa = $maxNum;
  157. mssql_data_seek($this->queryResult,$nopa);
  159. $row=$this->fetch_array($this->queryResult);
  161. $nopa++;
  162. $i++;
  163. $back[] = $row;
  165. if ($nopa >=$maxNum) {
  166. break;
  167. }
  168. }
  169. }
  170. $this->pageNum = $maxNum;
  171. return $back;
  172. }
  174. /**
  175. *Page html page number
  176. */
  177. function page_html($DataNum=0,$Page=1,$ShowNum=3,$web,$Post=''){
  178. if ($DataNum == 0) {
  179. $back = "没有要查询的数据";
  180. }else {
  181. if ($ShowNum<=0) {
  182. $ShowNum = 3;
  183. }
  184. if ($Page<=0) {
  185. $Page = 1;
  186. }
  187. if (empty($web)) {
  188. $web = "#";
  189. }
  190. $pageNum = ceil($DataNum/$ShowNum);
  191. if ($Page <= 1) {
  192. $top = "首页<<";
  193. }else {
  194. $top = "首页<< ";
  195. }
  196. if ($Page !==1) {
  197. $upPage = "上一页";
  198. }else {
  199. $upPage = "上一页";
  200. }
  201. if ($Page < $pageNum) {
  202. $downPage = "下一页";
  203. }else {
  204. $downPage = "下一页";
  205. }
  206. if ($Page == $pageNum) {
  207. $foot = ">>尾页";
  208. }else {
  209. $foot = " >>尾页";
  210. }
  212. $back = <<
  213. 共 $pageNum 页
  214. 第 $Page/$pageNum 页 $top $upPage $downPage $foot
  215. EOT;
  216. }
  217. return $back;
  218. }
  219. }//end class
  220. ?>
复制代码


Related labels：
有关php连接mssql的一些总结
source：php.cn
Previous article：PHP data operation examples of rounding, rounding and rounding Next article：Learn four functions for distinguishing values ​​in php arrays
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
When using Laravel on Ubuntu, an unsupported property was specified on the PDO object: MSSQL My UbuntuvagrantLaravelHomestead setup is configured to connect to MSSQL. Randomly, it sta...
From 2023-10-30 23:05:50
0
1
256
MySql and SQL settings before update trigger Updates of different tables/columns cannot update tables in stored functions/triggers I have a join table with 2 tables (A and C) with n:m relationship. The connection table (B...
From 2023-09-14 21:54:36
0
1
303
How to draw a line between two points using js and CSS This is a simple HTML page containing 2 points and a line connecting the points, added usi...
From 2023-09-12 11:41:32
0
1
305
Join 3 tables referencing table 1 in MYSQL and combine values ​​with comma separator I have a problem joining three tables. First try to join two tables is successful but on t...
From 2023-09-11 19:18:28
0
2
243
"Array.push() does not work properly when Mongoose Populate" I read another post about this problem but I can't figure out how to apply it to my situat...
From 2023-09-08 11:50:21
0
1
209
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！