How can I submit an HTML form to Google docs as well as to a PHP file

Question

I have the following form :

<div class="ss-form">
<form onsubmit = "return validateForm();" action="https://spreadsheets.google.com/formResponse?hl=en&amp;formkey=dHXVVeEUybk9UNEVYdEdrNlVOSTZMbFE6MA&amp;
theme=0AX42CRXMsmRFxMDNhN2Y&amp;ifq'" method="POST" id="ss-form" name="data"\>

This works well, and submits the data to Google Docs.

My question is, how can I submit this form to google docs AND submit it to a PHP file at the same time?

I have tried using php include, but it does not work as the google docs link is not a php file.

Also tries using cURL but not sure what Im doing wrong :

    //set options
    $curl_connection = curl_init('https://spreadsheets.google.com/');

    curl_setopt($curl_connection, CURLOPT_CONNECTTIMEOUT, 30);
    curl_setopt($curl_connection, CURLOPT_USERAGENT, 
      "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)");
    curl_setopt($curl_connection, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($curl_connection, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($curl_connection, CURLOPT_FOLLOWLOCATION, 1);

    //set data to be posted
        $post_string = "formResponse?hl=en&amp;formkey=dHXVVeEUybk9UNEVYdEdrNlVOSTZMbFE6MA&amp;
    theme=0AX42CRXMsmRFxMDNhN2Y&amp;ifq";

    curl_setopt($curl_connection, CURLOPT_POSTFIELDS, $post_string);
    $result = curl_exec($curl_connection);

    //show information regarding the request
    print_r(curl_getinfo($curl_connection));
    echo curl_errno($curl_connection) . '-' . 
    curl_error($curl_connection);

    //close the connection
    curl_close($curl_connection);

you can submit it to PHP first, then do your php business logic there, and afterward do a `cURL` and submit to google doc — KJYe.Name, Mar 11 '11 at 14:22

score 1 · Answer 1 · answered Feb 17 '12 at 13:16

Follow the instructions on this page and set up a custom handler for the Google Docs form submit:

In step 9, where you replace the form action with the JavaScript code, insert a function that dynamically creates a new form with the same fields and point it to the local PHP script. The function should also copy the data into the new form from the old form and then fire the submit event.

This way, the form data gets posted to Google Docs in the IFRAME and the second "copy" form posts the data to your PHP script. You can even have that second form post into a second, dynamically created IFRAME if you want to handle the 'thank you' in the same page.

score 0 · Answer 2 · answered Mar 11 '11 at 14:23

0

First idea: submit it to your php script and then redirect from the php script to google as a second call.

answered Mar 11 '11 at 14:23

Tobias

7,238
10
46
77

your post string should be i the following format `key1=value1&key2=value2` and i think `curl_init('https://spreadsheets.google.com/formResponse');` – KJYe.Name Mar 11 '11 at 14:36

score 0 · Answer 3 · edited May 23 '17 at 12:04

0

You can send it to your PHP file and send it to google Docs afterwards.

You'll have to add the $_POST parameters. See here for more info how to do that: Possible to post data in a PHP redirect?

edited May 23 '17 at 12:04

Community

1
1

answered Mar 11 '11 at 14:25

konsolenfreddy

9,551
1
25
36

KJYe.Name · Answer 4 · 2011-03-11T14:42:53.253

Let's say you have a php file name submitForm.php, and you basically point the action of your form to submit to this php script. With in this script you handle your php side business logic, and after you are done with that you can use cURL to post a form to google doc. This is one way to do it.

Here is cURL tutorial on how to submit form: PHP cURL Submit Form

Try modify your code to this:

$curl_connection = curl_init('https://spreadsheets.google.com/formResponse');
//setup options for client url connection
curl_setopt($curl_connection, CURLOPT_CONNECTTIMEOUT, 30);
curl_setopt($curl_connection, CURLOPT_USERAGENT, 'Mozilla/4.0 (compatible; MSIE 6.0;      Windows NT 5.1)');
//set data to be posted
    $post_string = "hl=en&amp;formkey=dHXVVeEUybk9UNEVYdEdrNlVOSTZMbFE6MA&amp;
theme=0AX42CRXMsmRFxMDNhN2Y&amp;ifq";

curl_setopt($curl_connection, CURLOPT_POSTFIELDS, $post_string);
//execute the post and then close the connection
curl_exec($curl_connection);

Better yet Format your POST data with this traverse:

//traverse array and prepare data for posting (key1=value1)
    foreach ( $_POST as $key => $value) {
        $post_items[] = $key . '=' . $value;
    }

    //create the final string to be posted using implode()
    $post_string = implode ('&', $post_items);

do you have error_reporting on? `error_reporting(E_ALL);` also check your `phpinfo();` see if it's on. and `display_errors = on` http://php.net/manual/en/function.error-reporting.php — KJYe.Name, Mar 11 '11 at 14:53

seriousdev · Answer 5 · 2011-03-11T15:48:20.150

0

First, set the form's action attribute to yourscript.php.
In yourscript.php write this:

$opts = array('http' =>
    array(
        'method'  => 'POST',
        'header'  => "Content-Type: application/x-www-form-urlencoded\r\nContent-Length: " . strlen(http_build_query($_POST)) . "\r\n", // updated line
        'content' => $_POST
    )
);

$context  = stream_context_create($opts);

$send_data = file_get_contents('<google-docs-form-url>', false, $context);

// then process data

edited Mar 11 '11 at 15:48

answered Mar 11 '11 at 14:25

seriousdev

7,519
8
45
52

Just did this, but getting the following error : failed to open stream: HTTP request failed! HTTP/1.0 411 Length Required in /home/aksystem/public_html/triotech/trioform/updatedb1.php on line 16 – Andre J Mar 11 '11 at 14:42
Thanks, updated it, now Im getting : failed to open stream: HTTP request failed! HTTP/1.0 502 Bad Gateway - Could this have something to do with this being an HTTPS url that im using? – Andre J Mar 11 '11 at 22:15

score 0 · Answer 6 · answered Mar 11 '11 at 14:26

0

Use javascript to submit two ajax forms.

answered Mar 11 '11 at 14:26

Mikhail

8,692
8
56
82

How can I submit an HTML form to Google docs as well as to a PHP file

6 Answers6