[PHP-DEV] Bug #9438 Updated: Error retrieving image field from MSSQL database From: fmk <email protected>
Date: 06/30/01

ID: 9438
Updated by: fmk
Reported By: lbf <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] lbf <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: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>