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();
?>
<---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();
?>