OK, so I have a MySQL database. What I want to be able to do is let users add data to the database, and then for everybody's results to be searchable.
A similar project to mine would be to let visitors submit their site, and to turn everybody's submitted sites into a special search engine.
So, I need a form for submitters to fill in, and a search function.
I realise that this will probably a lot to explain in one post, so if you know any articles....
heebie.co.uk has arrived. Don't get the heebie jeebies.
Te audire no possum. Musa sapientum fixa est in aure.
I cannot hear you. I have a banana in my ear
This site is best viewed using a web browser. Anyone trying to use a rhinoceros or elephant does so at their own risk
andy206uk posted this at 21:02—30th July 2006.
He has: 1,742 posts
Joined: Jul 2002
It's probably best that you buy a book to be honest. I don't think many people have the kind of time required to teach you how to do this in a forum post and not all online tutorials will be detailed enough. I should imagine sitepoint.com will have a relevant tutorial.
The MySQL stuff is relatively simple, just two lines one for inserting the data from the form and one to select the data based on the search parameters it's writing the PHP to do all the stuff in the middle that's a bit more complicated.
Here's an example of an SQL insert:
INSERT INTO `dbname` VALUES ('blah','blah','blah')'Here's an SQL select based on a query (returning 10 results):
SELECT * FROM `dbname` WHERE blah = 'blah' LIMIT 0, 10'Andyk
Music Rants News and Reviews | My Photoblog | Blog of a Web Designer
Give a man a fish and you feed him for a day. Teach him to use the Net and he won't bother you for weeks.
heebiejeebieclu posted this at 12:05—31st July 2006.
He has: 524 posts
Joined: Aug 2004
OK, this might be more complicated than I imagined, but thanks for your help andy. I'll work on it and see what I come up with.
heebie.co.uk has arrived. Don't get the heebie jeebies.
Te audire no possum. Musa sapientum fixa est in aure.
I cannot hear you. I have a banana in my ear
This site is best viewed using a web browser. Anyone trying to use a rhinoceros or elephant does so at their own risk
foottuns posted this at 20:03—11th October 2006.
They have: 78 posts
Joined: May 2006
why don't you try a content management.