Pokusao sam smestiti slike u bazu. Sve je okej. Upise id, filename, i sliku. U phpMyAdmin pokazuje da je sve upisano, ali pri citanju u browseru ispisuje nebulozne znake za sliku... nigde slike!
Ispis ostalih kolona funkcionise!
Nebulozni zanci u browseru:

Tabela:
id - tinyint(4)
filename - varchar(50)
image - longblob
upload_form.html
upload_image.php
Kod funkcije fopen() pokusaho sam i sa "rb", "r", kao i r. Uvek isti rezultat.
Ispis ostalih kolona funkcionise!
Nebulozni zanci u browseru:
Tabela:
id - tinyint(4)
filename - varchar(50)
image - longblob
upload_form.html
Code:
<form action="upload_image.php" method="post" enctype="multipart/form-data">
<h2>Upload Image</h2>
Name
<input name="filename" type="text" /><br /><br />
<input name="image" size="50" type="file" /><br /><br />
<input name="submit" type="submit" value="Upload" />
</form>
<form action="upload_image.php" method="post" enctype="multipart/form-data">
<h2>Upload Image</h2>
Name
<input name="filename" type="text" /><br /><br />
<input name="image" size="50" type="file" /><br /><br />
<input name="submit" type="submit" value="Upload" />
</form>
upload_image.php
Code:
<?php
$filename = $_POST["filename"];
$image = $_FILES["image"]["name"];
$size = $_FILES["image"]["size"];
$type = $_FILES["image"]["type"];
$data = addslashes(fread(fopen($_FILES["image"]["tmp_name"], rb), $size));
$connection = mysql_connect("localhost","user","password");
mysql_select_db("bazarc", $connection);
$query = "INSERT INTO photo (id, filename, image) VALUES ( NULL, '$filename', '$data')";
mysql_query($query, $connection) or die(mysql_error());
$query = "SELECT image FROM photo";
$result = mysql_query($query, $connection) or die("<b>The iupload failed!</b>");
$output_image = mysql_result($result, 0, "image");
header("Content_type: image/jpeg");
echo $output_image;
?>
<?php
$filename = $_POST["filename"];
$image = $_FILES["image"]["name"];
$size = $_FILES["image"]["size"];
$type = $_FILES["image"]["type"];
$data = addslashes(fread(fopen($_FILES["image"]["tmp_name"], rb), $size));
$connection = mysql_connect("localhost","user","password");
mysql_select_db("bazarc", $connection);
$query = "INSERT INTO photo (id, filename, image) VALUES ( NULL, '$filename', '$data')";
mysql_query($query, $connection) or die(mysql_error());
$query = "SELECT image FROM photo";
$result = mysql_query($query, $connection) or die("<b>The iupload failed!</b>");
$output_image = mysql_result($result, 0, "image");
header("Content_type: image/jpeg");
echo $output_image;
?>
Kod funkcije fopen() pokusaho sam i sa "rb", "r", kao i r. Uvek isti rezultat.