How to transfer order info to payment gateway interface in php?

Now, I have following e-commece application scenario:
1. I have one web site designed for selling one specific software product;
2. There is a form in the page which is used for input contact email, mobile,addr,quantities information;
3.If people are intersted in the product, he will input above information and click submit;
4.The order will be printed on the screen with another button named:pay for this order;
5.After that, the order information including money number, order id will be transfered to the payment gateway(Third party, alipay in china, similar to paypal)in a formatted manner;
6. The alipay handle the payment and will notify my site.
I have couples of questions on above steps:
In the step 5. how can I "store" step 3 inputed information?
How can I transfer that to alipay(paypal)?Can you give more alternative solutions to address this requirement?
Can you give a detail technical description on those steps what happened during those steps?
Thanks!
matiascxAsked:
Who is Participating?
 
joomla_phpCommented:
The order id has to be unique. Usually it's the last order number plus 1. Ideally you lock the order number table while retrieving the highest number, create your order number based on the result, and then unlock the table. Another process requesting the same info (highest order number) has to wait until your transaction is complete. Their result will then be your order number that you inserted into the table. The scenario is something like:

lock order table
get maximum order id from order table
new order id = add one to maximum order id
insert empty order with new order id
unlock order table

As long as you can generate a unique value you can do it without a database. You could do it with a simple order number file that contains a number. A random unique value would not be very human-friendly.
0
 
matiascxAuthor Commented:
To address above order-checkout process, maybe two alternatives, with mysql and without mysql, can anyone kindly give explaination how to implement if with mysql or without mysql?

Thanks!
0
 
matiascxAuthor Commented:
Please be aware that the customer will not be asked to login in to the website which is selling software product.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
matiascxAuthor Commented:
I have found one page: http://www.php-shopping-cart-tutorial.com/paypal-integration.htm describing about integrating shopping cart with paypal. In the code:
<form action="https://www.paypal.com/cgi-bin/webscr" method="POST">

To pay with PayPal now please click on the PayPal icon below:

<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="your@paypal.email">
<input type="hidden" name="item_name" value="Order #{$order_id}">
<input type="hidden" name="amount" value="{$order_amount}">
<input type="hidden" name="currency_code" value="{$currency_iso_3}">
<input type="image" name="submit" src="http://images.paypal.com/images/x-click-but01.gif" alt="Pay with PayPal">

</form>

My concern is How shopping cart store and retrieve and transfer the information of $order_id,$order_ammount information?

Any comments are welcome!
0
 
joomla_phpCommented:
Generally your form will submit the order amount by post; the currency is hard coded; the order id is retrieved from the database (next highest one from current highest order id). This is received in a $_POST. An easier way to is to create PayPal or authorize.net pre-configured buttons. Then you don't need to write code.
0
 
matiascxAuthor Commented:
Hi,joomla_php,
"
the order id is retrieved from the database
"
As I say, the user will not login into the e-commerce system, how the code knows which order id should be retrieved from database??

Assuming many concurrent users are checking out, how to assure the orderid was right?

If there was no database allowed(To simplify program), is it possible to implement the above scenario?

Thanks!
0
 
matiascxAuthor Commented:
I found the easy solution with session technology.
Will the solution impact the server performance?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.