[REQ] Logiciel de programmation

CREATE TABLE test
(
 num_int SMALLINT DEFAULT '1' NOT NULL AUTO_INCREMENT,
 img_data BLOB NOT NULL,
 PRIMARY KEY (num_int),
 KEY num_int (num_int)
);

==> STOCKAGE <==

< ? php
mysql_connect("localhost","","");
mysql_select_db("bdd");
$img = "image.jpg";

$fp = fopen($img,"r");
$fpdata = fread($fp, filesize($img));
fclose($fp);
$data = addslashes($fpdata);
mysql_query("INSERT INTO test (img_data) VALUES ('$fpdata')");
? >

==> LECTURE <==

< ? php
$connexion = mysql_connect("localhost", "", "");
mysql_select_db("bdd", $connexion);
$requete = "SELECT img_data FROM test WHERE num_int = 1";

$resultat = mysql_query($requete, $connexion);
$tableau = mysql_fetch_array($resultat);
mysql_close($connexion);

$image = $tableau[0];

$fichier = fopen("image/tmp.jpg","w");
fwrite($fichier, $image);
fclose($fichier);
? >

Et enfin ==>
< im g src="image/tmp.jpg">