Store Data In Remote DataBase Using cUrl or Execute a HTTP POST Using PHP CURL

The information isn’t going to be saved on the localhost database — it needs to be stored in a remote database that I cannot connect directly to.I thought about all of the possible solutions for solving this challenge and settled on this flow:

1. User will submit the form, as usual.
2. In the form processing PHP, I use CURL to execute a POST transmission to a PHP script on the customer’s server.
3. The remote script would do a MySQL INSERT query into the customer’s private database.

This solution worked quite well so I thought I’d share it with you. Here’s how you execute a POST using the PHP CURL library.

1. //extract data from the post
   extract($_POST);
   
   //set POST variables
   $url = 'http://mydomain.com/postpage.php';
   $fields = array(
   						'lname'=>urlencode($last_name),
   						'fname'=>urlencode($first_name),
   						'title'=>urlencode($title),
   						'company'=>urlencode($institution),
   						'age'=>urlencode($age),
   						'email'=>urlencode($email),
   						'phone'=>urlencode($phone)
   				);
   
   //url-ify 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);

   Thanks

Related posts:

1. Post Data To Another Website Using cURL In PHP
2. Login to yahoo using cUrl in php
3. Enabling curl on XAMPP for Windows
4. Export MySQL to CSV (Excel) using php
5. Send Email to Multiple Persons using php
6. Append data to a text file using php
7. Simple Visitor Counter Using php