Can anyone recommend the best way for a noob to implement a simple database on a web page that can return results based on user input? For example, a user inputs their age, location, gender, etc., and specific products are returned to that user. I want it to be fairly easy to update the database of products and grow it. Would I use xml and javascript for this? Is it something MySQL and PHP would be better for? Is there a pre-made code snippet I can purchase and just plug into my wordpress site? Any advice is greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is My SQL right for this?
- Thread starter cfry999
- Start date
All databases are designed to return results based on input.
However the ease of use will depend greatly on how you craft the database tables.
Javascript is a client side language, and as such can't access a database directly. Even using an intermediary layer such as Ajax requires server side language like PHP to actually connect to the database to request and return the results.
Any Pre-Made scripts would still require database in place with the products that its going to search in. If your website already has a database of products in place then you can use that in combination with a PHP, ASP etc.. script to craft the queries. The queries would depend largely on your specific return needs, and how the database has been constructed.
What server side language you choose depends on what your web host supports. If it supports Wordpress, then PHP would be the logical choice.
----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
Behind the Web, Tips and Tricks for Web Development.
However the ease of use will depend greatly on how you craft the database tables.
Javascript is a client side language, and as such can't access a database directly. Even using an intermediary layer such as Ajax requires server side language like PHP to actually connect to the database to request and return the results.
Any Pre-Made scripts would still require database in place with the products that its going to search in. If your website already has a database of products in place then you can use that in combination with a PHP, ASP etc.. script to craft the queries. The queries would depend largely on your specific return needs, and how the database has been constructed.
What server side language you choose depends on what your web host supports. If it supports Wordpress, then PHP would be the logical choice.
----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
Behind the Web, Tips and Tricks for Web Development.
- Status
Similar threads
- Locked
- Question