ID: 9438
Updated by: fmk
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]