Page 1 of 1

CURL Help! Update Database From Another Site

Posted: Fri Oct 21, 2011 5:00 am
by sweetguyzzz
Hi to all,

I am trying to get following result for my site and I have created a script for it but half script is working and half is not working.

1) My Credit Card merchant send a POST request to one of my site's page. For example lets take my site name mysite1.com so they send POST request to this site.
2) I created a CURL script to send POST request to my another site (i.e. mysite2.com), on a page where my Credit Card Merchant send a request.
3) Then on mysite2.com, I create script to update database records of mysite2.com and send emails to both administrator and customer.

Summary of above is as:

Credit Card Merchant Send POST request to mysite1.com >> mysite1.com send CURL POST request to mysite2.com >> mysite2.com updates database records and send emails.

Now problem is here that both customer and administrator is receiving emails but database records got not updated, I thought that there may be a problem in query (like some special character) so I created a backup table and tried to insert that query in the backup table but now I see that on another order, not a backup table have any record and not a order table have any record updated.

I do not figure out what exactly the problem is.


I use following code on mysite1.com

Code: Select all

<?php
extract($_POST);

if($transactionType=="something") {
  $URL="http://www.mysite2.com/receive.php";
  $ch = curl_init();
  $POST = "fname=$firstName&lname=$lastName&amount=$invoiceChargeAmount&orderid=$orderId&email=$email";
  curl_setopt($ch, CURLOPT_URL,"$URL");
  curl_setopt($ch, CURLOPT_POST, 1);
  curl_setopt($ch, CURLOPT_POSTFIELDS, $POST);
  $result = curl_exec($ch);
  curl_close ($ch);
}

?>

I am very thankful in advance to those who can help. Waiting for serious responses.

Thanks
Sweetguyzzz