[RESOLVED] How to insert image into MSSQL with PHP

Faouzi_MESSEOUD

Hi,
I use Microsoft SQLServer with PHP. I want to insert an image uploaded, into a table, field type image. I have a problem to insert a file into a table, and retrieve it (display an image).
To accomplish the insertion, I use the following:
$nom_file = $FILES['fichier']['name'];
$taille = $FILES['fichier']['size'];
$tmp = $FILES['fichier']['tmp_name'];
$type = $FILES['fichier']['type'];

$img_binaire = str_replace("'","''",file_get_contents ($_FILES['fichier']['tmp_name'])); //l'image en binaire

And to update the table:

$requete="update trs_machine_inter set id_intermodel ='$intermodel', user_id ='$user', machine_id ='$machine_id', img_type ='$type', filesize ='$taille',".
"dcreate ='$date_creation', photo ='$img_binaire',".
"where id_minter='$code_intervention'";
$resultat=mssql_query($requete,$idConnexion);

To display the image, Iuse in other file (image.php):

$requete="select id_minter, photo, img_type, filesize from trs_machine_inter where id_minter=".$id;
$resultat=mssql_query($requete,$idConnexion);
$enreg=mssql_fetch_array($resultat);
header("Content-type: ".$enreg[2]);
header("Content-length: ".$enreg[3]);
echo $enreg[1];

But, the image dont displayed.

bastien

http://www.weberdev.com/get_example-4062.html

http://www.weberdev.com/get_example-4063.html

Faouzi_MESSEOUD

Hi Bastien,

These exemples (http://www.weberdev.com/get_example-4062.html
, http://www.weberdev.com/get_example-4063.html) are about how to insert image with MySQL database, my purpose is how to insert the image in SQLServer database.
The function $data = addslashes($data); is without effect in SQLServer. I used str_replace("'","''",$data), but is also not working.
Thanks

bastien

Do you have magic_quotes on? That would tend to invalidate the add_slashes function since you are then using the slash to escape the slash.

Using str_replace on the single quotes is fine, but its usually not the only character that could make the db barf on the insert.

Faouzi_MESSEOUD

Hi,
I success to resolve the problem of insertion an image and retrieve it as the following:
Insertion:
$tmp = $FILES['fichier']['tmp_name'];
$size = filesize($tmp);
set_magic_quotes_runtime(0);//to desactive the default escape spacials caracters made by PHP in the externes files
// $img_binaire = base64_encode(str_replace("'","''",file_get_contents ($FILES['fichier']['tmp_name']))); this manner isnot work for files uper to 1 K0
$img_binaire = base64_encode(fread(fopen(str_replace("'","''",$tmp), "r"), $size));

Display image:
header("Content-type: ".$enreg['img_type']);
echo base64_decode($enreg['photo']);