Page 1 of 1
Help with a search function
Posted: Thu Apr 30, 2009 8:49 pm
by gord1020
Hey everyone.
I am a total noob with PHP and mysql, although I'm pretty good at HTML/CSS. I'm also great at dreamweaver, if that helps. Anyways I really want to mimic what a professional photography site is doing with their pictures for 5k road races.
http://www.mondphotos.com takes pictures of road races then posts them to their website. If you click on one of the races it brings you to another page which allows one to search by finish time. how do they achieve this? even if I can't do that, can someone tell me how I can somehow link a photo and a runner's ID number... and then be able to search by the ID number and the picture appear.
I really would love to have something like this working. All help is appreciated.
THANK YOU!!
Re: Help with a search function
Posted: Fri May 01, 2009 12:18 am
by it2051229
I think you haven't finished your PHP and MySQL tutorial.
Re: Help with a search function
Posted: Fri May 01, 2009 3:38 am
by Benjamin

Moved to PHP - Code
This is really a coding issue rather than a database issue. Before you worry about retrieving/storing information into a database you need to know how to manipulate the data using a programming language.
We really don't write code for people here... unless you pay

So if you have any code that you have written already, we will be happy to help you.
Re: Help with a search function
Posted: Fri May 01, 2009 5:44 am
by gord1020
how could I start going about doing this?
Re: Help with a search function
Posted: Fri May 01, 2009 8:47 pm
by it2051229
well you just finish your PHP and MYsql Tutorial and you start coding.. and if you have trouble with HOW or WHAT or whatever issue you're encountering, just ask... we do this step by step annnddd eventually you'll get to do a lot of modifications and you'll be able to learn. Well yeah every starters sucks at first but hey you're on the learning stage.
Re: Help with a search function
Posted: Mon May 25, 2009 3:12 pm
by gord1020
I've completed my mysql tutorial and have a pretty good understanding of some PHP. Now....
here is what I have:
http://stevenspraguememorialrun.com/search.php
JUST TYPE "31" into the search box and click submit. PRESTO you have your race results as well as pictures of you from race day.
What I did was created a mysql database with all the runner info in it and then I made a search form.
Now for the picture function I simply put the image file into a folder on my server and put the filename into the mysql table.
Easy enough! The thing is I don't want to sit here and go through hundreds of people and find their corresponding picture filename and manually paste it into the mysql table. is there any automated way of doing this. I already tagged every picture from the race with the BIB numbers that are in the image (embedded into the pictures metadata). Can I somehow upload all the pictures to my server and tell the php to look through the metadata??
(((Its just the pictures that are giving me trouble not the other info.)))
Here is an image of my sql setup:

As you can see I manually entered the filename of the picture with runner number 31 in it.
Please help!