photo_php

<?php
/*=============
此文件是 Microsoft SQL Server 共享源應用程序的一部分。
版權所有 (C) 微軟公司。 版權所有。

此代碼和信息“按原樣”提供，不提供任何保證
種類，無論是明示的還是暗示的，包括但不限於
適銷性和/或適用性的暗示保證
特殊用途。
============= */

header(“Content-Type: text/html;charset=utf-8”);
/* $serverName = “(local)\sqlexpress”;
$connectionInfo = array( “Database”=>”AdventureWorks”); */

$serverName = “tcp:192.168.17.7, 1433”;
$connectionInfo = array(“Database”=>”AdventureWorks2014″,”Uid”=>”sa”, “PWD”=>”xyz.1234”);

echo “$serverName<br/>”;
echo “$connectionInfo<br/>”;

echo ‘$serverName<br/>’;
echo ‘$connectionInfo<br/>’;

/* 身份驗證 與 連接. */
$conn = sqlsrv_connect( $serverName, $connectionInfo);

echo “$conn<br/>”;

if( $conn === false )
{
echo “無法連線.”.”<br/>”;
die( print_r( sqlsrv_errors(), true));
}
else
{
echo “連線成功.”.”<br/>”;
}

/* 取得產品圖片代號 述句 */
$tsql = “SELECT LargePhoto
FROM Production.ProductPhoto AS p
JOIN Production.ProductProductPhoto AS q
ON p.ProductPhotoID = q.ProductPhotoID
WHERE ProductID = ‘150’”;

$params = array(&$_REQUEST[‘productId’]);

echo “$tsql”.”<br/>”;

/* 查詢. */
$stmt = sqlsrv_query($conn, $tsql, $params);

echo “$stmt”.”<br/>”;

if( $stmt === false ) {
echo “Error in statement execution.</br>”;
die( print_r( sqlsrv_errors(), true));
}

/* 照片擷取 as a binary stream. */
$getAsType = SQLSRV_PHPTYPE_STREAM(SQLSRV_ENC_BINARY);
if ( sqlsrv_fetch( $stmt ) )
{
$image = sqlsrv_get_field( $stmt, 0, $getAsType);
fpassthru($image);
}
else
{
echo “Error in retrieving data.</br>”;
die(print_r( sqlsrv_errors(), true));
}

/* Free the statement and connection resources. */
sqlsrv_free_stmt( $stmt );
sqlsrv_close( $conn );
?>