PHP + ECommerce

[eskimo42]

I am developing a PHP Order Fulfillment System using mysql and I had a few questions. The business I work for sells seven products only. They sell it as a whole set or the 6 individual products desperately. I had a quick few questions:

 

1. As I have it right now I created seven fields in the Orders Table. Qty1,Qty2, Etc... The way I was going to do this was the number in field would represent the quantity they ordered. I then had a class which determines the price etc... I was thinking there must be a better way to do this because when they get to the checkout and orderstatus page i want an easy way to do a loop so i can list exactlyl which products they ordered and the price next to it. Any suggestions?

 

2. My second problem is I wanted to have a three step ordering process. I dont want to put the credit card in a session because of security risks, and I dont want store it in the database because of security issues. Any suggestions on how i can safley obtain my users credit card number and get it to the merchant to be charged without storing it or passing it along in session files?

 

 

Thanks,

 

Evan