---

Forum » » Le coin des codeurs » » insertion image ds mysql

---

Posté : 18 janv. 2004 à 13:28

1 - Crétion TABLE

CREATE TABLE binary_data (
id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
description CHAR(50),
bin_data LONGBLOB,
filename CHAR(50),
filesize CHAR(50),
filetype CHAR(50)
);



2 - Destockage du Binaire via GET_DATA.PHP

@mysql_select_db("binary_data");

$query = "select bin_data,filetype from binary_data where id=$id";
$result = @MYSQL_QUERY($query);

$data = @MYSQL_RESULT($result,0,"bin_data");
$type = @MYSQL_RESULT($result,0,"filetype");

Header( "!content-type:! $type");
echo $data;

3 - Visu de l'image

<.img src="GET_DATA.PHP?id=xxx".>

---

Cet article provient de NPDS
https://www.npds.org/viewtopic.php?topic=4160&forum=5