[ dekifpi @ 11.09.2010. 00:39 ] @
Nabavio sam skriptu za citanje Blob fajla u kojem sam smestio sliku u MYSQL bazi... E sad umesto da mi ocita sliku on ocita samo jedan mali (prazan) kvadratic. Jel neko zna u cemu je problem???? Unapred hvala... Code: <---tabela----> id name image 1 enter.jpg [BLOB - 15KiB] <----CITANJE IZ BAZE----> <?php // Connect to database $handle = mysql_connect("localhost", "root", ""); mysql_select_db("db"); // Get the BLOB field $result = mysql_query("SELECT image FROM store WHERE user_id = 9", $handle); // Read row $data = mysql_fetch_array($result, MYSQL_ASSOC); // Get image data $imagedata = $data["image"]; // Dump BLOB field as JPEG image header("Content-Type: image/jpeg"); header("Content-Disposition: inline; filename=enter.jpg"); echo $imagedata; mysql_close($handle); exit(); ?> |