php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #10413 Error retrieving image field from MSSQL database
Submitted: 2001-04-19 22:01 UTC Modified: 2001-07-23 10:12 UTC
From: jesus dot estrada at qbien dot net Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.0.4pl1 OS: Win2k
Private report: No CVE-ID: None
 [2001-04-19 22:01 UTC] jesus dot estrada at qbien dot net
Looks like there's a problem in the Windows version of the mssql extension. I'm having the same problem as Leonid Freidin with queries that have a image in the result.
I'm using php4.04pl1.
This is the code.

<?
$con = mssql_connect("laptop2000","sa","adfasdf") or die("couldnt connect to db");  //Nos conectamos al servidor de BD
if (mssql_select_db("MexMatch",$con)) {
	$query= "select * from Usuario where apodo = 'karls'";  //It crashes here, because I have an image field here.
	$result = mssql_query($query,$con) or die("bke");
	while($array = mssql_fetch_array($result))
		echo $array{"apodo"};
	mssql_free_result($result);
	}
	
mssql_close($con);
?>

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-06-30 14:51 UTC] fmk@php.net
Handling of binary data was changed in php4.0.6. Please update and try again.
 [2001-07-23 10:12 UTC] jesus dot estrada at qbien dot net
Looks like it's working in php 4.0.6 
Thanks.
 
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Sun May 22 21:05:44 2022 UTC