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.
I will tell you want is the job of each files.
1). index.php
This files links all the files in the project.
2). store.php
This does the job of storing the picture into the database.
3). viewadd.php
This file shows the entire picture stored in the database.
4). getpicture.php
This file actually gets the file from file in the form of picture
5). 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
imthiazrafiq@gmx.net
Msn id: imthiazrafiq@gmx.net
Yahoo id: imthiazrafiq
ICQ: 24294947
URL: http://high-flyer.da.ru/
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
Re-scan downloaded files using your personal virus checker before using it.
NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
Terms of Agreement:
By using this code, you agree to the following terms...
You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
Frankly, even before I start use your codes, the Class.php file is so complex as I can't understand many lines of it! Kindly, publish a lite version, which have some simple class.php file (If this comment was disrespectful, please report it.)
very easy and unstandcode (If this comment was disrespectful, please report it.)
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
By 9 Users
Download code
7/21/2002 10:29:43 PM: 
