SQL/phpMyAdmin newbie needs help....
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....
andy206uk posted this at 21:02 — 30th July 2006.
He has: 1,758 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'Andy
heebiejeebieclu posted this at 12:05 — 31st July 2006.
They have: 527 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.
foottuns posted this at 20:03 — 11th October 2006.
They have: 78 posts
Joined: May 2006
why don't you try a content management.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.