php 显示sqlserver二进制图片

时间:2023-03-09 09:19:16
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>