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.
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