Ispis ostalih kolona funkcionise!
Nebulozni zanci u browseru:
Tabela:
id - tinyint(4)
filename - varchar(50)
image - longblob
upload_form.html
<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
<?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.