<?php
\n\/*=============
\n\u6b64\u6587\u4ef6\u662f Microsoft SQL Server \u5171\u4eab\u6e90\u61c9\u7528\u7a0b\u5e8f\u7684\u4e00\u90e8\u5206\u3002
\n\u7248\u6b0a\u6240\u6709 (C) \u5fae\u8edf\u516c\u53f8\u3002 \u7248\u6b0a\u6240\u6709\u3002<\/p>\n
\u6b64\u4ee3\u78bc\u548c\u4fe1\u606f\u201c\u6309\u539f\u6a23\u201d\u63d0\u4f9b\uff0c\u4e0d\u63d0\u4f9b\u4efb\u4f55\u4fdd\u8b49
\n\u7a2e\u985e\uff0c\u7121\u8ad6\u662f\u660e\u793a\u7684\u9084\u662f\u6697\u793a\u7684\uff0c\u5305\u62ec\u4f46\u4e0d\u9650\u65bc
\n\u9069\u92b7\u6027\u548c\/\u6216\u9069\u7528\u6027\u7684\u6697\u793a\u4fdd\u8b49
\n\u7279\u6b8a\u7528\u9014\u3002
\n============= *\/<\/p>\n
header(“Content-Type: text\/html;charset=utf-8”);
\n\/* $serverName = “(local)\\sqlexpress”;
\n$connectionInfo = array( “Database”=>”AdventureWorks”); *\/<\/p>\n
$serverName = “tcp:192.168.17.7, 1433”;
\n$connectionInfo = array(“Database”=>”AdventureWorks2014″,”Uid”=>”sa”, “PWD”=>”xyz.1234”);<\/p>\n
echo “$serverName<br\/>”;
\necho “$connectionInfo<br\/>”;<\/p>\n
echo ‘$serverName<br\/>’;
\necho ‘$connectionInfo<br\/>’;<\/p>\n
\/* \u8eab\u4efd\u9a57\u8b49 \u8207 \u9023\u63a5. *\/
\n$conn = sqlsrv_connect( $serverName, $connectionInfo);<\/p>\n
echo “$conn<br\/>”;<\/p>\n
if( $conn === false )
\n{
\necho “\u7121\u6cd5\u9023\u7dda.”.”<br\/>”;
\ndie( print_r( sqlsrv_errors(), true));
\n}
\nelse
\n{
\necho “\u9023\u7dda\u6210\u529f.”.”<br\/>”;
\n}<\/p>\n
\/* \u53d6\u5f97\u7522\u54c1\u5716\u7247\u4ee3\u865f \u8ff0\u53e5 *\/
\n$tsql = “SELECT LargePhoto
\nFROM Production.ProductPhoto AS p
\nJOIN Production.ProductProductPhoto AS q
\nON p.ProductPhotoID = q.ProductPhotoID
\nWHERE ProductID = ‘150’”;<\/p>\n
$params = array(&$_REQUEST[‘productId’]);<\/p>\n
echo “$tsql”.”<br\/>”;<\/p>\n
\/* \u67e5\u8a62. *\/
\n$stmt = sqlsrv_query($conn, $tsql, $params);<\/p>\n
echo “$stmt”.”<br\/>”;<\/p>\n
if( $stmt === false ) {
\necho “Error in statement execution.<\/br>”;
\ndie( print_r( sqlsrv_errors(), true));
\n}<\/p>\n
\/* \u7167\u7247\u64f7\u53d6 as a binary stream. *\/
\n$getAsType = SQLSRV_PHPTYPE_STREAM(SQLSRV_ENC_BINARY);
\nif ( sqlsrv_fetch( $stmt ) )
\n{
\n$image = sqlsrv_get_field( $stmt, 0, $getAsType);
\nfpassthru($image);
\n}
\nelse
\n{
\necho “Error in retrieving data.<\/br>”;
\ndie(print_r( sqlsrv_errors(), true));
\n}<\/p>\n
\/* Free the statement and connection resources. *\/
\nsqlsrv_free_stmt( $stmt );
\nsqlsrv_close( $conn );
\n?><\/p>\n","protected":false},"excerpt":{"rendered":"
<?php \/*============= \u6b64\u6587\u4ef6\u662f Microsoft SQL Server \u5171\u4eab\u6e90\u61c9 […]<\/p>\n","protected":false},"author":1,"featured_media":247,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25,38],"tags":[],"jetpack_featured_media_url":"http:\/\/www.dxQerp.cn\/wp-content\/uploads\/2020\/09\/cropped-wionhd_zyi4-scaled-1.jpg","_links":{"self":[{"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/posts\/1545"}],"collection":[{"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1545"}],"version-history":[{"count":1,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/posts\/1545\/revisions"}],"predecessor-version":[{"id":1546,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/posts\/1545\/revisions\/1546"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/media\/247"}],"wp:attachment":[{"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1545"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}