Product Order form with mysql database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
zacthespack
Forum Newbie
Posts: 16
Joined: Mon Oct 11, 2010 9:08 am

Product Order form with mysql database

Post 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
Li0rE
Forum Commoner
Posts: 41
Joined: Wed Jun 07, 2006 6:26 am

Re: Product Order form with mysql database

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