Bug #9438 Updated: Error retrieving image field from MSSQL database
| From: | fmk@php.net | Date: | Sat, 30 Jun 2001 19:27:45 +0000 |
| Subject: | Bug #9438 Updated: Error retrieving image field from MSSQL database | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-58563@lists.php.net to get a copy of this message | ||
ID: 9438
Updated by: fmk
Reported By: lbf@mail.ru
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Operating system:
PHP Version: 4.0.4pl1
Assigned To:
Comments:
Handling of binary data is changed for php4.0.6. Please update and try again.
Previous Comments:
---------------------------------------------------------------------------
[2001-02-24 20:27:09] lbf@mail.ru
When I try to retrieve image field from MSSQL7 database I get "PHP has encountered an Access
Violation at 77FCA9EA" and all PHP engine becomes unstable after this. The script is very
simple:
<?
include("msdb.php");
$id=$HTTP_GET_VARS["id"];
$rs=mssql_query("select Image from SpecBannerData where SpecBannerID=" . $id,$conn);
$arr=mssql_fetch_row($rs);
if ($arr)
{
header( "Content-type: image/jpg");
echo $arr[0];
}
?>
msdb.php:
<?
$conn=mssql_connect("127.0.0.1","sa","");
if (!$conn)
{
echo ("Can not connect to the database");
}
if (!mssql_select_db("metasearch",$conn))
{
echo ("Can not connect to the database");
}
?>
I'm quite new in PHP, but I met some other people report the same problems in PHP-related
forums. I used only precompiled PHP modules downloaded from php.net.
Best regards,
Leonid Freidin
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=9438&edit=2