Uploading and retrieving image from mysql : How to ?
Posted: Wed Jul 02, 2008 5:51 am
Hey guys....i've found a complete coding for uploading files such as image from mysql using php script...but the problem here is..when i wanted to see whether the data had been successfully uploaded into my database...my table of images return "empty"..but my php return successfully uploaded which means successfully stored in the database....why does this happen? does the <input type = "hidden" > in the upload form is the cause?
Below are the codes:

Another thing is...how to retrieve or display the image back to php page??
Thanks
Azhan
________________
http://www.productcoverdesign.com- " Cheapest E-cover Design"
Below are the codes:
Code: Select all
<html>
<head><title>Store binary data into SQL Database</title></head>
<body>
<?php
// code that will be executed if the form has been submitted:
if ($submit) {
// connect to the database
// (you may have to adjust the hostname,username or password)
MYSQL_CONNECT("localhost","root","paswword");
mysql_select_db("database_name");
$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
$result=MYSQL_QUERY("INSERT INTO images (description,bin_data,filename,filesize,filetype) ".
"VALUES('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')");
$id= mysql_insert_id();
print "<p>This file has the following Database ID: <b>$id</b>";
MYSQL_CLOSE();
} else {
// else show the form to submit new data:
?>
<form method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
File Description:<br>
<input type="text" name="form_description" size="40">
<input type="hidden" name="MAX_FILE_SIZE" value="1000000">
<br>File to upload/store in database:<br>
<input type="file" name="form_data" size="40">
<p><input type="submit" name="submit" value="submit">
</form>
<?php
}
?>
</body>
</html>
Another thing is...how to retrieve or display the image back to php page??
Thanks
Azhan
________________
http://www.productcoverdesign.com- " Cheapest E-cover Design"