Page 1 of 1

Product Order form with mysql database

Posted: Fri Jul 15, 2011 5:24 am
by zacthespack
I have a Mysql database which holds all the product information (product code, description and price), this allows me to display the products on the site and keep them up to date from sage.
What I am trying to do is create a order form for customers to place orders, this does not need any form of payment as this is taken later. What i need help with is creating a form in which when a user starts to type a product code it will then bring up a drop down list searching for that product and allow the user to select the correct product, which then fills in the description and price from the mysql database.
The user would then need to be able to order multiple of the same item and do the same again for many products. Once all that the user wants has been selected a final price would need to be calculated.

If anyone knows of a script already about that I could modify or could help me to build this script I would be very grateful.
Thank you very much

Re: Product Order form with mysql database

Posted: Fri Jul 15, 2011 6:12 pm
by Li0rE
If you have a good command of PHP/MySQL, you can use any available php shopping cart script and modify your current MySQL db to work in an installation of one of those carts.

I'd use osCommerce, since it tends to be more simple than any other widely used one I've seen.