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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: lbf at mail dot ru
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2024 The PHP Group
All rights reserved.
Last updated: Sun Oct 27 16:01:27 2024 UTC