HELP PLEASE, not that hard...
Posted 02 April 2003 - 12:12 PM
I am going to create a graffiti database website.
I have over 500 images that i wish to store in a MYSQL datbase.
The images will be split into 10 or so sections according to the area their from.
I heard it is better to store the image path rather than the image its self in the db, as loading time will be reduced.
I also have myadmin, so this could make things easier.
So basicaly i want to know how to set that database out??
what tables and fields would i need to produce what i outlined above?
i basicaly want sections of thumbnails that link to their appropriate pictures on the DB. and for them to be pulled on to one universal page.
any help anyone can give me will me much apreciated. As this is the first time i ever attempted using php-mysql.
Posted 02 April 2003 - 12:23 PM
with the fields like
picture_ID, section_ID, picture_URL
the picture_ID\'s would be unique numbers or names just some way to uniquely Identify the picture.
from there you can determin the url and what section they belong to.
if you have a standard way of naming the pictures and they are stored in a standard way, you could get by with only picture_ID and section_ID and build the url dynamically based on your standard.
Posted 02 April 2003 - 01:06 PM
where do i have the actual image folder....simply on the server?
(or at the moment, its all running from htdocs folder. So just in there?)
i want the images to work as thumbnails. So when a thumbnail is clicked on, what sort of code would be used to pull the image from the appropriate db?
a query of some sort, but like i said im well ameture....so....i dont know.
but thanks, its great to get some help
Posted 02 April 2003 - 01:13 PM
as far as the code for the thumbnails
I would prolly set it up as just
make the img a link to a php page that will parse the information out
the link would look something like showpic.php?pic_id=mycat
then in the showpic.php file you would get the pic id from the url using
$id = $_GET[\'pic_id\']
then use $id to search the database for the url
and sections would be pretty much the same
a link to a specific section my look like showsect.php?sect_id=animals
then in the showsect page you would get the variable
$section = $_GET[\'animals\']
then search the database for all the pics that have a section id of animals
since you are using thumbnails also you might have to create another field in your database with the path to the thumbnail.
hope all of this doesn\'t confuse you.
Posted 02 April 2003 - 01:48 PM
BUT if im storing all the thumbs in the db,
in the site ideally i would like about 30 on each page.
so can you lets say have a 5x6 table (=30) and somehow have the thumbnails dynamicaly* put in the cells. Or would you have to put a path to the individual image in the db, in the cell.
Also, (sorry please bear with me) can the thumbnails have their parent images links designated to them in the db. so no html has to be written.
So, if you had a selection of thums on a page...and clicked on one
it would go to its big image automatically.
I think stage one for me is to create a db with a images folder and a thums folder with one of each in them, and try to get it to work fo just one image.
thanks for your help and advice though
Posted 02 April 2003 - 02:05 PM
don\'t get discouraged you dealling with PHP, MYSQL, and database theory.
none of these is \"easy\" by itself stick in there.
There always seems to be someone on these forums to help when you get stuck.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users