{"id":1118,"date":"2021-11-04T00:56:02","date_gmt":"2021-11-03T16:56:02","guid":{"rendered":"http:\/\/www.tra56.com\/?p=1118"},"modified":"2021-11-04T00:56:02","modified_gmt":"2021-11-03T16:56:02","slug":"1118","status":"publish","type":"post","link":"https:\/\/www.tra56.com\/1118.html","title":{"rendered":"PHP for SQLSrv \u64cd\u4f5c\u7c7b"},"content":{"rendered":"<p>\u64cd\u4f5c\u7c7b<\/p>\n<pre class=\"brush:php;toolbar:false\">&lt;?php\r\n&nbsp;\r\n\/**\r\n*&nbsp;SqlServer\u64cd\u4f5c\u7c7b(sqlsrv)\r\n*&nbsp;Class&nbsp;SQLSrv\r\n*\/\r\nclass&nbsp;SQLSrv\r\n{\r\n&nbsp;&nbsp;&nbsp;private&nbsp;$dbhost;\r\n&nbsp;&nbsp;&nbsp;private&nbsp;$dbuser;\r\n&nbsp;&nbsp;&nbsp;private&nbsp;$dbpw;\r\n&nbsp;&nbsp;&nbsp;private&nbsp;$dbname;\r\n&nbsp;&nbsp;&nbsp;private&nbsp;$port;\r\n&nbsp;&nbsp;&nbsp;private&nbsp;$result;\r\n&nbsp;&nbsp;&nbsp;private&nbsp;$connid&nbsp;=&nbsp;0;\r\n&nbsp;&nbsp;&nbsp;private&nbsp;$insertid&nbsp;=&nbsp;0;\r\n&nbsp;&nbsp;&nbsp;private&nbsp;$cursor&nbsp;=&nbsp;0;\r\n&nbsp;&nbsp;&nbsp;public&nbsp;static&nbsp;$instance&nbsp;=&nbsp;null;\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;__construct($db)\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;function_exists(&quot;sqlsrv_connect&quot;)&nbsp;or&nbsp;die(&quot;&lt;pre&gt;\u8bf7\u5148\u5b89\u88c5&nbsp;sqlsrv&nbsp;\u6269\u5c55\u3002&quot;);\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;dbhost&nbsp;=&nbsp;!empty($db[&#39;hostname&#39;])&nbsp;?&nbsp;$db[&#39;hostname&#39;]&nbsp;:&nbsp;&#39;localhost&#39;;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;dbuser&nbsp;=&nbsp;$db[&#39;username&#39;];\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;dbpw&nbsp;=&nbsp;$db[&#39;password&#39;];\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;dbname&nbsp;=&nbsp;$db[&#39;dbname&#39;];\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;port&nbsp;=&nbsp;!empty($db[&#39;port&#39;])&nbsp;?&nbsp;$db[&#39;port&#39;]&nbsp;:&nbsp;1433;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;connect();\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;public&nbsp;static&nbsp;function&nbsp;getdatabase($db){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(empty(self::$instance)){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;self::$instance&nbsp;=&nbsp;new&nbsp;SQLSrv($db);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;self::$instance;\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u8fde\u63a5\u6570\u636e\u5e93\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;int\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;private&nbsp;function&nbsp;connect()\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$serverName&nbsp;=&nbsp;&quot;{$this-&gt;dbhost},&nbsp;{$this-&gt;port}&quot;;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$connectionInfo&nbsp;=&nbsp;array(&nbsp;&quot;Database&quot;=&gt;$this-&gt;dbname,&nbsp;&quot;UID&quot;=&gt;$this-&gt;dbuser,&nbsp;&quot;PWD&quot;=&gt;$this-&gt;dbpw);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(!$this-&gt;connid&nbsp;=&nbsp;@sqlsrv_connect($serverName,&nbsp;$connectionInfo)){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;halt(print_r(&nbsp;sqlsrv_errors(),&nbsp;true));\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$this-&gt;connid;\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u6267\u884csql\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;$sql\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;mixed\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;query($sql)\r\n{\r\nif(empty($sql)){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;halt(&#39;SQL&nbsp;IS&nbsp;NULL!&#39;);\r\n}\r\n&nbsp;\r\n$result&nbsp;=&nbsp;sqlsrv_query($this-&gt;connid,&nbsp;$sql);\r\n&nbsp;\r\nif(!$result){&nbsp;&nbsp;\/\/\u8c03\u8bd5\u7528\uff0csql\u8bed\u53e5\u51fa\u9519\u65f6\u4f1a\u81ea\u52a8\u6253\u5370\u51fa\u6765\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;halt(&#39;MsSQL&nbsp;Query&nbsp;Error&#39;,&nbsp;$sql);\r\n}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;result&nbsp;=&nbsp;$result;\r\n&nbsp;\r\nreturn&nbsp;$this-&gt;result;\r\n}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u83b7\u53d6\u4e00\u6761\u6570\u636e\uff08\u4e00\u7ef4\u6570\u7ec4\uff09\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;$sql\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;array|bool\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;find($sql)\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;result&nbsp;=&nbsp;$this-&gt;query($sql);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$args&nbsp;=&nbsp;$this-&gt;fetch_array($this-&gt;result);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$args&nbsp;;\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u83b7\u53d6\u591a\u6761\uff08\u4e8c\u7ef4\u6570\u7ec4\uff09\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;$sql\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;string&nbsp;$keyfield\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;array\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;findAll($sql,&nbsp;$keyfield&nbsp;=&nbsp;&#39;&#39;)\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$array&nbsp;=&nbsp;array();\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;result&nbsp;=&nbsp;$this-&gt;query($sql);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while($r&nbsp;=&nbsp;$this-&gt;fetch_array($this-&gt;result)){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if($keyfield){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$key&nbsp;=&nbsp;$r[$keyfield];\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$array[$key]&nbsp;=&nbsp;$r;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}else{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$array[]&nbsp;=&nbsp;$this-&gt;objectToArray($r);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$array;\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u5bf9\u8c61\u8f6c\u6570\u7ec4\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;$obj\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;array\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;private&nbsp;function&nbsp;objectToArray($obj){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ret&nbsp;=&nbsp;array();\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;foreach&nbsp;($obj&nbsp;as&nbsp;$key&nbsp;=&gt;&nbsp;$value)&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(gettype($value)&nbsp;==&nbsp;&quot;array&quot;&nbsp;||&nbsp;gettype($value)&nbsp;==&nbsp;&quot;object&quot;){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ret[$key]&nbsp;=&nbsp;&nbsp;$this-&gt;objectToArray($value);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}else{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ret[$key]&nbsp;=&nbsp;$value;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$ret;\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;fetch_array($query,&nbsp;$type&nbsp;=&nbsp;SQLSRV_FETCH_ASSOC)\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(is_resource($query))&nbsp;return&nbsp;sqlsrv_fetch_array($query,&nbsp;$type);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if($this-&gt;cursor&nbsp;&lt;&nbsp;count($query)){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$query[$this-&gt;cursor++];&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;FALSE;&nbsp;\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;affected_rows()\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;sqlsrv_rows_affected($this-&gt;connid);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;num_rows($query)\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;is_array($query)&nbsp;?&nbsp;count($query)&nbsp;:&nbsp;sqlsrv_num_rows($query);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;num_fields($query)\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;sqlsrv_num_fields($query);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u91ca\u653e\u8fde\u63a5\u8d44\u6e90\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;$query\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;free_result($query)\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(is_resource($query))&nbsp;@sqlsrv_free_stmt($query);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;insert_id()\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$this-&gt;insertid;\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;fetch_row($query)\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;sqlsrv_num_rows($query);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;bool\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;close()\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;sqlsrv_close($this-&gt;connid);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u629b\u51fa\u9519\u8bef\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;string&nbsp;$message\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@param&nbsp;string&nbsp;$sql\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;halt($message&nbsp;=&nbsp;&#39;&#39;,&nbsp;$sql&nbsp;=&nbsp;&#39;&#39;)\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$_sql&nbsp;=&nbsp;!empty($sql)&nbsp;?&nbsp;&quot;MsSQL&nbsp;Query:$sql&nbsp;&lt;br&gt;&quot;&nbsp;:&nbsp;&#39;&#39;;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;exit(&quot;&lt;pre&gt;{$_sql}Message:$message&quot;);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u5f00\u59cb\u4e00\u4e2a\u4e8b\u52a1.\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;begin()\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;sqlsrv_begin_transaction($this-&gt;connid);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u63d0\u4ea4\u4e00\u4e2a\u4e8b\u52a1.\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;commit()\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;sqlsrv_commit($this-&gt;connid);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u56de\u6eda\u4e00\u4e2a\u4e8b\u52a1.\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;rollback()\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;sqlsrv_rollback($this-&gt;connid);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u8fd4\u56de\u670d\u52a1\u5668\u4fe1\u606f\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;array\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;static&nbsp;function&nbsp;serverInfo(){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;sqlsrv_server_info($this-&gt;connid);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u8fd4\u56de\u5ba2\u6237\u7aef\u4fe1\u606f\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;@return&nbsp;array|null\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;static&nbsp;function&nbsp;clientInfo(){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;sqlsrv_client_info($this-&gt;connid);\r\n&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;\/**\r\n&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;\u6790\u6784\u51fd\u6570,\u5173\u95ed\u6570\u636e\u5e93,\u5783\u573e\u56de\u6536\r\n&nbsp;&nbsp;&nbsp;&nbsp;*\/\r\n&nbsp;&nbsp;&nbsp;public&nbsp;function&nbsp;__destruct()\r\n&nbsp;&nbsp;&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(!is_resource($this-&gt;connid)){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;free_result($this-&gt;result);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$this-&gt;close();\r\n&nbsp;&nbsp;&nbsp;}\r\n}<\/pre>\n<p><span style=\"color: rgb(61, 70, 77); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, \u5fae\u8f6f\u96c5\u9ed1, Tahoma, Arial, sans-serif; background-color: rgb(255, 255, 255);\">2. [\u4ee3\u7801]\u4f7f\u7528\u65b9\u6cd5<\/span><\/p>\n<pre class=\"brush:php;toolbar:false\">&lt;?php\r\nrequire&nbsp;&quot;database\/sqlsrv_driver.php&quot;;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\/\/\u5bfc\u5165\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b\r\n&nbsp;\r\n$_db&nbsp;=&nbsp;array(&nbsp;\/\/\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\r\n&nbsp;&nbsp;&nbsp;&#39;hostname&#39;&nbsp;=&gt;&nbsp;&#39;localhost&#39;,&nbsp;\/\/\u4e3b\u673a\u5730\u5740\r\n&nbsp;&nbsp;&nbsp;&#39;username&#39;&nbsp;=&gt;&nbsp;&#39;sa&#39;,&nbsp;\/\/\u7528\u6237\u540d\r\n&nbsp;&nbsp;&nbsp;&#39;password&#39;&nbsp;=&gt;&nbsp;&#39;123&#39;,&nbsp;\/\/\u5bc6\u7801\r\n&nbsp;&nbsp;&nbsp;&#39;dbname&#39;&nbsp;=&gt;&nbsp;&#39;test_db&#39;,&nbsp;\/\/\u6570\u636e\u5e93\u540d\r\n&nbsp;&nbsp;&nbsp;&#39;port&#39;&nbsp;=&gt;&nbsp;1433,&nbsp;\/\/\u7aef\u53e3&nbsp;&nbsp;\u9ed8\u8ba41433\r\n);\r\n$db&nbsp;=&nbsp;SQLSrv::getdatabase($_db);&nbsp;\/\/\u6570\u636e\u5e93\u8fde\u63a5\r\n&nbsp;\r\n#\u6700\u7ec8&nbsp;$db&nbsp;\u5c31\u662f\u4f60\u7684\u6570\u636e\u5e93\u5b9e\u4f8b\r\n&nbsp;\r\n#\u67e5\u8be2\u793a\u4f8b\r\n$sql&nbsp;=&nbsp;&quot;select&nbsp;*&nbsp;from&nbsp;table1&quot;;\r\n&nbsp;\r\n#\u67e5\u8be2\u5355\u6761\uff1a\r\n$result&nbsp;=&nbsp;$db-&gt;find($sql);\r\n&nbsp;\r\n#\u67e5\u8be2\u591a\u6761\uff1a\r\n$result&nbsp;=&nbsp;$db-&gt;findAll($sql);\r\n&nbsp;\r\n#\u6267\u884c\u589e\u5220\u6539\uff1a\r\n$result&nbsp;=&nbsp;$db-&gt;query($sql);\r\n&nbsp;\r\n#...<\/pre>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u64cd\u4f5c\u7c7b &lt;?php &nbsp; \/** *&nbsp;SqlServer\u64cd\u4f5c\u7c7b(sqlsrv) *&#038;n [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,92],"tags":[],"class_list":["post-1118","post","type-post","status-publish","format-standard","hentry","category-php","category-phpcode"],"_links":{"self":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/1118"}],"collection":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/comments?post=1118"}],"version-history":[{"count":1,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/1118\/revisions"}],"predecessor-version":[{"id":1119,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/1118\/revisions\/1119"}],"wp:attachment":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/media?parent=1118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/categories?post=1118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/tags?post=1118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}