php 显示sqlserver二进制图片 

<?
header("Content-type:image/ "); 
// Server in the this format: \ or 

// , when using a non default port number

$server = 'KALLESPC\SQLEXPRESS';
$link = mssql_connect('192.168.1.11:1433', 'sa', '123');

if(!$link)
{
    die('Something went wrong while connecting to MSSQL');
}
else{
    mssql_select_db('DATABASE_DATA', $link);
    //$version = mssql_query('SELECT * from RGraph');

    //$sql ="EXEC WhateverSProcYouWant some_arguments"; 

$data = mssql_query('SELECT * from RGraph where sn = 783', $link); 
$row=mssql_fetch_array($data); 
echo $row["sFile"]; 
}

　　

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<table width="100%" border="0">
  <tr>
    <td><img border="0" src="r.php" ></td>
  </tr>
</table>
</body>
</html>

　　

posted @ 2015-10-26 00:08  孤舟残月浅笑嫣然  阅读(511)  评论(0)  编辑  收藏  举报