Database help needed.
# October 9, 2008 at 7:35 am
Now, I hope this is the right place and/or the right forum to post this kind of question, but feel free to guide me elsewhere if the topic does not suit this site.
Anyway, I suspect my question is a pretty big ask but Iâ€™ll ask it regardless. Basically, I want to know how to implement some sort of database into a simple XHTML/CSS/JQUERY site to enable users to do functions such as searching, using a â€˜browseâ€™ form to find related entries and for the data to be displayed as a neat, CSS styled table.
Now if it helps, Iâ€™ll try to give a simple example (please excuse the silly subject but I picked something easy).
Letâ€™s pretend my website sells new and used shoes of multiple brands and styles. A user could come to the website and use a form (preferably drop down menus so they donâ€™t have to deal with spelling mistakes) to search the â€˜databaseâ€™ of shoes with information about each shoe. They might be able to choose the brand, the year it was released, gender, the size, and colour/s. When they put all this in and click â€˜submitâ€™, they are presented with the closest matches. If possible, not exactly their entry (otherwise they may never get exactly what they want), but hopefully in the right range, so it might take into consideration one size more and less or the same shoe in different colours etc.
Reading over all of that makes it seem pretty tough (to me at least), but if someone could offer any help, whether it is suggestions, examples, tutorials or whatever, I would be very grateful.
Cheers, and thanks in advance.# December 28, 2008 at 7:28 am
This reply has been reported for inappropriate content.
learn php & sql (or mysql) this will do what you want.
SQL is the database where everything is stored, eg, your shoe, size, make, model, date made, colour, type, etc
and php will do all the server side processing of thte information to and from the database to html.
in the html you can have the css to style as you wish.
php can output the html but it will hide all the php code.
so yes it can be done, but your question looks as if it is a kind of plea for help to do it for you.# January 6, 2009 at 9:32 am
this is a good place to start http://php.about.com/ but yeah definitely need to learn PHP and MySQL as what your describing is basically different queries. Once you have a database created with items stored its then down to the SQL part to ask the database your query and return results on screen.
Hope this helps
You must be logged in to reply to this topic.