Save form data to database then do form action

clay

Hi,

I have an even registration form which a customer fills out and then clicks submit. On submit they are taken to my merchant processor to enter their credit card information and then redirected back to my site.

However, I collect additional information about the customer that is not sent to the merchant provider. For example: Age.

When the customer clicks submit I want to save their information into my database, and then have them go to the merchant page. I do not want to add another step for them to click anything.

What I want to happen is:

1.Customer fills out form.
2. Clicks submit
3. Customer information is entered into table
4. Customer is brought to the othersite.com/order.pl page to enter their credit card
5. Customer clicks submit and their card is approved or declined and they are redirected back to my site.

Suggestions?

dagon

first submit the form to your site, where you can get the information you need then use CURL (for post) or header (for get) to submit the form to the merchant. At least that's how i do it in exactly the same situation.

clay

dagon;10942749 wrote:
first submit the form to your site, where you can get the information you need then use CURL (for post) or header (for get) to submit the form to the merchant. At least that's how i do it in exactly the same situation.

Dagon:

I have been trying to do something like that..

I'm not too familiar with curl

I tried the following which I found on http://davidwalsh.name/execute-http-post-php-curl

After I hit submit, it shows me the payment gateway and the fields are filled out. The URL in the browser is my site's and when I click 'submit' it tries to bring me to mysite.com/transact.pl which obviously doesn't exist.

extract($_POST);

//set POST variables
$url = 'https://www.eProcessingNetwork.com/cgi-bin/dbe/order.pl';
$fields = array(
                  'Total'=>urlencode($Total),
                  'ePNAccount'=>urlencode($ePNAccount),
                  'FirstName'=>urlencode($FirstName),
                  'LastName'=>urlencode($LastName),
                  'Address'=>urlencode($Address),
                  'City'=>urlencode($City),
                  'State'=>urlencode($State),
                  'Zip'=>urlencode($Zip),
                  'EMail'=>urlencode($EMail),
                  'ID'=>urlencode($ID),
                  'ReturnApprovedURL'=>urlencode($ReturnApprovedURL),            

                  'ReturnDeclinedURL'=>urlencode($ReturnDeclinedURL),
                  'Phone'=>urlencode($telephone)

        );

//url-*** the data for the POST
foreach($fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
rtrim($fields_string,'&');

//open connection
$ch = curl_init();

//set the url, number of POST vars, POST data
curl_setopt($ch,CURLOPT_URL,$url);
curl_setopt($ch,CURLOPT_POST,count($fields));
curl_setopt($ch,CURLOPT_POSTFIELDS,$fields_string);

//execute post
$result = curl_exec($ch);

//close connection
curl_close($ch);

MOD EDIT: [noparse]

..

[/noparse] bbcode tags changed to [noparse]

..

[/noparse] tags.

dagon

curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

clay

Is there a specific place I should put that? I tried it and now nothing is appearing at all on the curl page

clay

Are you using eprocessingnetwork by any chance? Could you post what you are doing to make this work?

clay

Still stuck on this