Retrieving Image File from MySQL using PHP

Hello every one here are codes to help you save and retrieve image and audio from your database.

If you don’t understand or you have a problem please send me your code bgn90@yahoo.com

First we will store image to database.

Create database and a table that you will store your files.
—— creating table (create it using mysql commander), Let’s say we are using Database “Africa”…here’s a code that creates a table under database “Africa”.

Create table files (id int auto_increment not null, primary key(id),name varchar(60)not null,type varchar(60)not null,size int(11)not null,content mediumBLOB not null);

*note that MediumBLOB limits the file to 6MB in size.

Then let’s create a file that will upload image and Audio. With this file you’ll be abwle to upload both images and audio files. We will then name our file upload.php

Upload

0){
$fileName = $_FILES[‘userfile’][‘name’];
$tmpName = $_FILES[‘userfile’][‘tmp_name’];
$fileSize = $_FILES[‘userfile’][‘size’];
$fileType = $_FILES[‘userfile’][‘type’];

$fp = fopen(tmpName,’r’);
$content = fread(fp,filesize($tmpName));
$content = addslashes($content);
fclose(fp);

If (!get_magic_qoutes_gpc(){

$fileName = addslashes(fileName);
}

$dbcon = mysql_connect(“localhost”,”username”,”password”);
mysql_select_db(“Africa”,dbcon);
$query = ‘INSERT INTO files (name,size,type,content)VALUES(“‘.$fileName.'”,”‘.$fileSize.'”,”‘.$fileType.'”,”‘.$content.'”)';

mysql_query($query) or die (‘Error, Query failed’);
mysql_close($dbcon);

echo ” files “.$fieName.” Is added to Database Africa”;
}
?>

Copy and paste the above code and run it, do not go for the next code if this one is not running, email me your problem if you can not run the page bgn90@yahoo.com .

I recommend that you upload at least 5 images to your database before moving to this step
Let’s now retrieve what we have saved to our database.

Create a php file to retrieve both images and audio. We will name the file engine.php

After saving this file engine.php

We will need a file that will link you to this engine.php file. Let’s quickly do that, we will need another php file to retrieve from this file.

Let’s name this file link.php

viewer

<?php
$dbcon = mysql_connect("localhost","username","password&quot;
Mysql_select_db('Africa',$dbcon);

$query = "select I'd, name from files";
$result = mysql_query($query) or die ("error, query failed&quot;

If(mysql_num_rows($result)==0)
{
Echo "database Africa is Empty “;
}

Elese

{
While (list($id,$name) = mysql_fetch_arra($result))
{
?>
<a href='engine.php?id=’ Id=” >

We are now done, copy all the files name the accordingly, and see how you can view you data from the database this is how we view images and audio from the database. Not that the link.php file will show the data in your database in a form of anchors/link, when you click them it they will link you to the engine.php file. Same as when you want to ad an image to your php file, use e.g <?php echo "This is my image “; ?>

Copy that e.g code and paste it and save it as php file, and see what I mean.