php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #9438 Error retrieving image field from MSSQL database
Submitted: 2001-02-24 20:27 UTC Modified: 2001-06-30 15:27 UTC
From: lbf at mail dot ru Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.0.4pl1 OS: Win2000 Prof SP1
Private report: No CVE-ID: None
 [2001-02-24 20:27 UTC] lbf at mail dot 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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-06-30 15:27 UTC] fmk@php.net
Handling of binary data is changed for php4.0.6. Please update and try again.
 
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Sat May 28 03:04:04 2022 UTC