Hi folks
I have searched many sites for storing a picture into a database
and retrieve the same. But I got some tutorials when I searched the web. Using
the tutorials I have a made one for me. It was implemented using Php and MySQL.
The downloadable ZIP file includes the following files.
-
index.php
This files links all the files in the project. -
store.php
This does the job of storing the picture into the database. -
viewadd.php
This file shows the entire picture stored in the database. -
getpicture.php
This file actually gets the file from file in the form of picture -
mdbc.inc.php
This is a class file for Mysql feel free to use. I got this over net.
Here is the table description
Id
- > has the picture id
Description
-> has the picture description
bin_data
-> picture data
filename
-> picture file name
filetype
-> picture file type. Like gif or jpeg
etc
link
-> you can store the link incase if you want
to use this for ad exchange
showno
- > no of time ad show etc
clickcount
-> no of time the ad being clicked etc
Query for the table. CREATE TABLE ads
(
id varchar(15),
description varchar(255),
bin_data LONGBLOB,
filename varchar(50),
filesize varchar(50),
filetype varchar(50),
link varchar(255),
shownno integer(5),
clickcount integer(5),
unique(id)
);
If you want to see a site where I have implemented please have a
look at the site http://www.asksathia.com/
Feel free to change anything in the code. If you developed a better
version than this please send me the source code so that
I may update myself. It took me much time when commenting
the code of ease of understanding.
Please vote for me.
Regards
Imthiaz Rafiq
Comments