$1.99

Includes working source code with form, style sheet and recaptcha integration

Have you ever wanted to do the following?

• Embed a google form into your site without using iframes?


• Control the thank you page of your google form?

• Send out confirmation emails to the user who submitted the form or to people who should receive the google form data?


• Attach a file to your form?


• Setup a captcha script on your google form?

There are two ways to accomplish this:

1. Use the Google API - Go to Tutorial
2. Use a PHP curl function to submit to the form but you have to make your form public so you can access it anonymously from your curl script. - See Tutorial Below

Code Sample

Note: This is just a basic example without the CSS or captcha. For all my sample code please purchase the package above.

 

googlesandwich.php
//----------------------------------------------------
// Google Form Sandwich
// Created by Jaz Witham (Jazzerup)
// 2011
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
// Script allows you to write custom php code
// before submitting a form to google
//----------------------------------------------------
//Google Form Key
$formkey = "dFdDTFBFRG1yZm9MckZUanFuM2dEd1E6MQ";
//Email address of person who should get email notification of form submission
$toemail = "
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
 ";
$thankyou = "http://www.jazzerup.com/blogexamples/googleform/thankyou.html";
//Change this URL to your google form address
$googleformURL = "https://spreadsheets.google.com/formResponse?formkey=$formkey";
//-----------------Start send email script------------------------
//This is where you would put any custom scripting such as using php to send confirmation emails
$name = $_POST["entry_0_single"];  //Replace the periods in the field name with underscore.
$fromemail = $_POST["entry_1_single"];
$subject = $_POST["entry_2_single"];
$body = $_POST["entry_3_single"];
$header = "From: " . $fromemail . "\r\n";
$header .= "Reply-To: " . $fromemail . "\r\n";
if (!(mail($toemail,$subject,$body,$header))) {
   echo("
<p>Message delivery failed...</p>
 
");
   echo("from email: $fromemail to email: $toemail");
  }
//-----------------End send email script------------------------
 
//----------------Send Form Fields to Google--------------------
//Loops through the form fields and creates a query string to submit to google
foreach ($_POST as $var => $value) {
 
    if ($var != "ignore") {
    $postdata=$postdata . htmlentities(str_replace("_", "." , $var)) . "=" . $value . "&amp;";
    }
}
//remove the extra comma
$postdata=substr($postdata,0,-1);
//Submit the form fields to google
$ch = curl_init();
curl_setopt ($ch, CURLOPT_URL,$googleformURL);
curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt ($ch, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6");
curl_setopt ($ch, CURLOPT_TIMEOUT, 60);
curl_setopt ($ch, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt ($ch, CURLOPT_POSTFIELDS, $postdata);
curl_setopt ($ch, CURLOPT_POST, 1);
$data = curl_exec ($ch);
curl_close($ch);
//echo $data;
//Redirect to your thank you page
header( "Location: $thankyou" ) ;
 

Now that you have a custom form page you can add a captcha to it if you want.
How to add captcha

$1.99

Includes examples, working source code with forms, style sheet, spreadsheet sample and recaptcha integration

Have you ever wanted to do the following?

• Embed a google form into your site without using iframes?


• Control the thank you page of your google form?

• Send out confirmation emails to the user who submitted the form or to people who should receive the google form data?


• Attach a file to your form?


• Setup a captcha script on your google form?

There are two ways to accomplish this:

1. Use the Google API - Tutorial Below
2. Use a PHP curl function to submit to the form but you have to make your form public so you can access it anonymously from your curl script. - Go to Tutorial

Step 2 - Create your Google Form

Create your Google Form and save the form to your desktop or build an html form from scratch.

Want a head start? You can use the Google Docs Template that I created for this tutorial.

 

The form fields on your web page will need to match your column headers in your google spreadsheet BUT it has to be all lower case and no space.

 

 

Example: If your column name is "First Name" then your field name needs to be "firstname"

Have your form action do a post to the "googlesandwich.php" page

<form action="googlesandwich.php" method="POST" enctype="multipart/form-data" id="ss-form"></form>

 

Step 3 - Create your Google Sandwich Page

A Google sandwich page is the page you submit your form to. It does all the hard work and then redirects to a thank you page.

 

Example 1 - Submit to Google Spreadsheet

Copy this code and paste into a googlesandwich.php page. Change the variables at the top to match your information.

 

googlesandwich_basic.php
 
//----------------------------------------------------
// Google Form Sandwich
// Created by Jaz Witham (Jazzerup)
// 2011
// http://www.jazzerup.com
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
// Script uses the Google API to save values of a form into
// a Google Spreadsheet
//----------------------------------------------------
 
 
// Gmail email address and password for google spreadsheet
$user = "
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
 ";
$pass = "yourpassword";
 
// Google Spreadsheet ID (You can get it from the URL when you view the spreadsheet)
$spreadsheetKey = "0AqPXsH_13gn4dFpaelRsN2RZOXlDd1Zvdzk2OGV3S1E";
 
// od6 is the first worksheet in the spreadsheet
$worksheetID = "od6";
 
// Redirect to your thank you page
$thankyou = "../thankyou.html";
 
//-----------------------------------------------------------
// No need to edit below unless you're a hacker =)
//-----------------------------------------------------------
 
// Include the loader and Google API classes for spreadsheets
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Http_Client');
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
Zend_Loader::loadClass('Zend_Gdata_Docs');
 
// Authenticate ourselves with Google Docs and create a Zend_Gdata_Spreadsheets object.
$authService = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
$httpClient = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $authService);
$spreadsheetService = new Zend_Gdata_Spreadsheets($httpClient);
 
foreach ($_POST as $var => $value) {
//Populate the form values into an array to save to the google spreadsheet
      $FormData[$var] = $value;
} 
 
// Save your form data to your Google spreadsheet
$insertedListEntry = $spreadsheetService->insertRow($FormData, $spreadsheetKey, $worksheetID);
 
//Redirect to your thank you page
header( "Location: $thankyou" ) ;
 
 
 

Example 2 - Submit to Google Spreadsheet and Upload Attachment to Google Docs

This form will submit the form values to a spreadsheet and also upload a file to google docs

 
//----------------------------------------------------
// Google Form Sandwich
// Created by Jaz Witham (Jazzerup)
// 2011
// http://www.jazzerup.com
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
// Script uses the Google API to save values of a form into
// a Google Spreadsheet and uploads file to Google Docs
//----------------------------------------------------
 
// Gmail email address and password for google spreadsheet
$user = "
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
 ";
$pass = "yourpassword";
 
// Google Spreadsheet ID (You can get it from the URL when you view the spreadsheet)
$spreadsheetKey = "0AqPXsH_13gn4dEJCc3VieGFkbWNsUGNMSkdFbVFLdEE";
 
// od6 is the first worksheet in the spreadsheet
$worksheetID="od6";
 
// Redirect to your thank you page
$thankyou = "../thankyou.html";
 
//-----------------------------------------------------------
// No need to edit below unless you're a hacker =)
//-----------------------------------------------------------
 
// Include the loader and Google API classes for spreadsheets
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Http_Client');
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
Zend_Loader::loadClass('Zend_Gdata_Docs');
 
//-----------------------------------------------------------
// Part One - Connect to our Google Spreadsheet
//-----------------------------------------------------------
// Authenticate ourselves with Google Docs and create a Zend_Gdata_Spreadsheets object.
$authService = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
$httpClient = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $authService);
$spreadsheetService = new Zend_Gdata_Spreadsheets($httpClient);
 
foreach ($_POST as $var => $value) {
  //Populate the form values into an array to save to the google spreadsheet
      $FormData[$var] = $value;
} 
 
// Give your file a unique name
$useruploaded = $FormData["yourname"];
$fileToUpload = $_FILES['attachment']['name'];
$dateuploaded = date("ymd_Hi", time());
 
// The file a unique name will be the user who uploaded, the file name and the date uploaded.
$filenewname = $useruploaded .  " - " . $fileToUpload . " - " . $dateuploaded;
 
// push the attachment to the bottom of the array so it shows up in your spreadsheet
$FormData["attachment"] = $filenewname;
 
// Save your form data to your Google spreadsheet
// Save your form data to your Google spreadsheet
$insertedListEntry = $spreadsheetService->insertRow($FormData, $spreadsheetKey, $worksheetID);
 
//-----------------------------------------------------------
// Part Two - Upload Attached File to Google Docs
//-----------------------------------------------------------
$fileToUploadTemp = $_FILES['attachment']['tmp_name'];
$content_type = $_FILES['attachment']['type'];
 
 
//-----------------------------------------------
// Upload File
//-----------------------------------------------
// Upload the file and convert it into a Google Document. 
// With this version of the API you can only upload certain files
// csv, txt, doc, docx, xls, xlsx,ppt, pptx   
 
$service = Zend_Gdata_Docs::AUTH_SERVICE_NAME;
$client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $service);
$docs = new Zend_Gdata_Docs($client);
 
// Find out the file mimetype
$filenameParts = explode('.', $fileToUpload);
$fileExtension = end($filenameParts);
 
// Upload the file to google docs
$newDocumentEntry = $docs->uploadFile($fileToUploadTemp, $filenewname, Zend_Gdata_Docs::lookupMimeType($fileExtension), Zend_Gdata_Docs::DOCUMENTS_LIST_FEED_URI);
 
// Redirect to your thank you page
header( "Location: $thankyou" ) ;
 
 

Example 3 - Submit to Google Spreadsheet and Upload Attachment to Your Web Site

This form will submit the form values to a spreadsheet and also upload a file to a folder on your web site

 
 
//----------------------------------------------------
// Google Form Sandwich
// Created by Jaz Witham (Jazzerup)
// 2011
// http://www.jazzerup.com
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
// Script uses the Google API to save values of a form into
// a Google Spreadsheet and uploads file to your web server
//----------------------------------------------------
 
// Gmail email address and password for google spreadsheet
$user = "
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
 ";
$pass = "yourpassword";
 
// Google Spreadsheet ID (You can get it from the URL when you view the spreadsheet)
$spreadsheetKey = "0AqPXsH_13gn4dEJCc3VieGFkbWNsUGNMSkdFbVFLdEE";
 
// od6 is the first worksheet in the spreadsheet
$worksheetID="od6";
 
// Redirect to your thank you page
$thankyou = "../thankyou.html";
 
// Path to your web folder for saving the attachment.  This folder needs to have 777 permissions on it.
$webfolder = "/path/to/your/webfolder/";
 
//-----------------------------------------------------------
// No need to edit below unless you're a hacker =)
//-----------------------------------------------------------
 
// Include the loader and Google API classes for spreadsheets
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Http_Client');
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
Zend_Loader::loadClass('Zend_Gdata_Docs');
 
//-----------------------------------------------------------
// Part One - Connect to our Google Spreadsheet
//-----------------------------------------------------------
// Authenticate ourselves with Google Docs and create a Zend_Gdata_Spreadsheets object.
$authService = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
$httpClient = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $authService);
$spreadsheetService = new Zend_Gdata_Spreadsheets($httpClient);
 
foreach ($_POST as $var => $value) {
  //Populate the form values into an array to save to the google spreadsheet
      $FormData[$var] = $value;
} 
 
// Give your file a unique name
$useruploaded = $FormData["yourname"];
$fileToUpload = $_FILES['attachment']['name'];
$dateuploaded = date("ymd_Hi", time());
 
// The file a unique name will be the user who uploaded, the file name and the date uploaded.
$filenewname = $useruploaded .  " - " . $fileToUpload . " - " . $dateuploaded;
 
// push the attachment to the bottom of the array so it shows up in your spreadsheet
$FormData["attachment"] = $filenewname;
 
// Save your form data to your Google spreadsheet
// Save your form data to your Google spreadsheet
$insertedListEntry = $spreadsheetService->insertRow($FormData, $spreadsheetKey, $worksheetID);
 
//-----------------------------------------------------------
// Part Two - Upload Attached File to Google Docs
//-----------------------------------------------------------
$fileToUploadTemp = $_FILES['attachment']['tmp_name'];
$content_type = $_FILES['attachment']['type'];
 
//-----------------------------------------------
// Upload File
//-----------------------------------------------
// Upload the file to your web server
 
 
if ($_FILES['attachment']['error'] > 0)
    {
    echo "An error has occurred.";
    echo "Error Code: " . $_FILES['attachment']['error'];
    }
 else
    {
 
    move_uploaded_file($_FILES['attachment']['tmp_name'],
    $webfolder . $filenewname);
  }
 
// Redirect to your thank you page
header( "Location: $thankyou" ) ;
 
 

Example 4 - Submit to Google Spreadsheet and Send Email with Attached File

This form will submit the form values to a spreadsheet and also send an email with an attached file

 
//----------------------------------------------------
// Google Form Sandwich
// Created by Jaz Witham (Jazzerup)
// 2011
// http://www.jazzerup.com
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
// Script uses the Google API to save values of a form into
// a Google Spreadsheet and sends an email with attachment
//----------------------------------------------------
 
// Gmail email address and password for google spreadsheet
$user = "
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
 ";
$pass = "yourpassword";
 
// Google Spreadsheet ID (You can get it from the URL when you view the spreadsheet)
$spreadsheetKey = "0AqPXsH_13gn4dFpaelRsN2RZOXlDd1Zvdzk2OGV3S1E";
 
// od6 is the first worksheet in the spreadsheet
$worksheetID="od6";
 
// Redirect to your thank you page
$thankyou = "../thankyou.html";
 
/*
If you want it to go to multiple recipients then make a comma delimited list
"
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
  , 
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
  , 
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
 "
*/
$mail_to = "
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
 ";
$from_mail = "
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
 ";
$from_name = "Name";
$reply_to =  "
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
 ";
$subject = $_POST['subject'];
$message = $_POST['message'];
 
// Include the loader and Google API classes for spreadsheets
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Http_Client');
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
Zend_Loader::loadClass('Zend_Gdata_Docs');
 
//-----------------------------------------------------------
// Part One - Connect to our Google Spreadsheet
//-----------------------------------------------------------
// Authenticate ourselves with Google Docs and create a Zend_Gdata_Spreadsheets object.
$authService = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
$httpClient = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $authService);
$spreadsheetService = new Zend_Gdata_Spreadsheets($httpClient);
 
foreach ($_POST as $var => $value) {
  //Populate the form values into an array to save to the google spreadsheet
  $FormData[$var] = $value;
} 
 
// push the attachment to the bottom of the array so it shows up in your spreadsheet
$FormData["attachment"] = $_FILES['attachment']['name'];
 
// Save your form data to your Google spreadsheet
$insertedListEntry = $spreadsheetService->insertRow($FormData, $spreadsheetKey, $worksheetID);
 
 
//Redirect to your thank you page
header( "Location: $thankyou" ) ;
 
//-----------------------------------------------------------
// Part Two - Send Email with Attachment
//-----------------------------------------------------------
 
// Attachment Information
$file_name = $_FILES['attachment']['name'];
$path = $_FILES['attachment']['tmp_name'];
 
// Read the file content
$file = $path;
$file_size = filesize($file);
$handle = fopen($file, "r");
$content = fread($handle, $file_size);
fclose($handle);
$content = chunk_split(base64_encode($content));
 
// Generate a boundary
$boundary = md5(uniqid(time()));
 
// Email header
$header = "From: ".$from_name." <".$from_mail.">\r\n";
$header .= "Reply-To: ".$reply_to."\r\n";
$header .= "MIME-Version: 1.0\r\n";
 
// Multipart wraps the Email Content and Attachment
$header .= "Content-Type: multipart/mixed; boundary=\"".$boundary."\"\r\n";
$header .= "This is a multi-part message in MIME format.\r\n";
$header .= "--".$boundary."\r\n";
 
 
// Content-type can be text/plain or text/html
$header .= "Content-type:text/plain; charset=iso-8859-1\r\n";
$header .= "Content-Transfer-Encoding: 7bit\r\n\r\n";
$header .= "$message\r\n";
$header .= "--".$boundary."\r\n";
 
// Attachment
// Edit content type for different file extensions
$header .= "Content-Type: application/xml; name=\"".$file_name."\"\r\n";
$header .= "Content-Transfer-Encoding: base64\r\n";
$header .= "Content-Disposition: attachment; filename=\"".$file_name."\"\r\n\r\n";
$header .= $content."\r\n";
$header .= "--".$boundary."--";
 
// Send email
if (mail($mail_to, $subject, "", $header)) {
  // Redirect to your thank you page
  $thankyou = "../thankyou.html";
} else {
  echo "Error";
}
 
 

Someone asked me how they can attach files to their Google forms.

1. You can use the CURL solution from my google form customization blog entry
2. Add an additional field to the form called attachment
3. In the googlesandwich.php page add the php code to upload the file. Example php upload tutorial

I decided to use this as an opportunity to walk through how to connect to a google form using the google API instead of the CURL solution. The advantage of the Google API is you do not need to make your form available on the web under the share settings.

I also decided to take advantage of google docs and use it as the location to save my attachment. Unfortunately as of Nov 2011, there is not an easy way to upload arbitrary files. You can only upload csv, txt, doc, xls, ppt files.

Step 1

To get started you will need PHP, Zend and the Gdata Zend Libraries installed on your web server. Google has an excellent tuttorial on how to do it with special scripts to check if your installation was successful.

Google API ZEND PHP Getting Started Tutorial

Now ASSUMING you have zend and php working then congratulations, the difficult part is done!

Step 2

Create your google form and save the form to your desktop or build an html form from scratch.

Your form fields will need to match your column headers in your google spreadsheet BUT it has to be all lower case and no space.

Example: If your column name is "First Name" then your field name needs to be "firstname"

Have your form action do a post to the "googlesandwich.php" page

Step 3

Copy this code and paste into a googlesandwich.php page. Change the variables at the top to match your information.

//googlesandwich.php
//----------------------------------------------------
// Google Spreadsheets API PHP Tutorial
// Created by Jaz Witham (Jazzerup)
// 2011
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
// Script allows you to connect to a google spreadsheet via
// the google php zend api and upload an attachment to google docs
//----------------------------------------------------
 
// Gmail email address and password for google spreadsheet
$user = "
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
 ";
$pass = "your email password";
 
// Google Spreadsheet ID (You can get it from the URL when you view the spreadsheet)
$GSheetID = "0AqPXsH_13gn4dGsxbVZpc1JvYWJZd3JjWGxxbXlSSnc";
 
// od6 is the first worksheet in the spreadsheet
$worksheetID="od6";
//Redirect to your thank you page
$thankyou = "http://www.jazzerup.com/blogexamples/googleform/thankyou.html";
//-------------------You shouldn't have to change anything after this line------------------
// Include the loader and Google API classes for spreadsheets
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Http_Client');
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
Zend_Loader::loadClass('Zend_Gdata_Docs');
//-----------------------------------------------------------
// Part One - Connect to our Google Spreadsheet
//-----------------------------------------------------------
// Authenticate with Google Docs and create a Zend_Gdata_Spreadsheets object.
$authService = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
$httpClient = Zend_Gdata_ClientLogin::getHttpClient($email, $pass, $authService);
$spreadsheetService = new Zend_Gdata_Spreadsheets($httpClient);
foreach ($_POST as $var => $value) {
  //Populate the form values into an array to save to the google spreadsheet
      $FormData[$var] = $value;
} 
// Give your file a unique name
$useruploaded = $FormData["yourname"];
$fileToUpload = $_FILES['attachment']['name'];
$dateuploaded = date("ymd_Hi", time());
// The file a unique name will be the user who uploaded, the file name and the date uploaded.
$filenewname = $useruploaded .  " - " . $fileToUpload . " - " . $dateuploaded;
// push the attachment to the bottom of the array so it shows up in your spreadsheet
$FormData["attachment"] = $filenewname;
// Save your form data to your Google spreadsheet
$insertedListEntry = $spreadsheetService->insertRow($FormData, $spreadsheetKey, $worksheetId);
//-----------------------------------------------------------
// Part Two - Upload Attached File to Google Docs
//-----------------------------------------------------------
$fileToUploadTemp = $_FILES['attachment']['tmp_name'];
$content_type = $_FILES['attachment']['type'];
//-----------------------------------------------
// Upload File
//-----------------------------------------------
// Upload the file and convert it into a Google Document. 
// With this version of the API you can only upload these file types:
// csv, txt, doc, xls, ppt  
$service = Zend_Gdata_Docs::AUTH_SERVICE_NAME;
$client = Zend_Gdata_ClientLogin::getHttpClient($email, $pass, $service);
$docs = new Zend_Gdata_Docs($client);
//Find out the file mimetype
$filenameParts = explode('.', $fileToUpload);
$fileExtension = end($filenameParts);
// Upload the file to google docs
$newDocumentEntry = $docs->uploadFile($fileToUploadTemp, $filenewname, Zend_Gdata_Docs::lookupMimeType($fileExtension), Zend_Gdata_Docs::DOCUMENTS_LIST_FEED_URI);
//Redirect to your thank you page
header( "Location: $thankyou" ) ;
 
 

So you want to customize your google forms and spreadsheet but you do not understand the Google API instructions? Welcome to my club =)

The advantage of using the API instead of PHP CURL is that you do not have to make your spreadhseet data public so it is more secure.

After a few hours I was finally able to piece together everything I needed to get started with the Google API and hopefully I can save you painstaking hours of hair pulling trying to get code that will work on your site.

To get the Google API to work with PHP you need the Zend Framework installed. Don't hypervenilate yet, it's not that difficult.

For detailed instructions on getting the Google API to work with Zend I highly recommend checking out this site.

Google API ZEND PHP Getting Started Tutorial

Now ASSUMING you have zend and php working then congratulations, the difficult part is done!

Let us start with displaying all the data in your spreadsheet

//----------------------------------------------------
// Google Spreadsheets API PHP Tutorial
// Created by Jaz Witham (Jazzerup)
// 2011
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
// Script allows you to connect to a google spreadsheet via
// the google php zend api
//----------------------------------------------------
 
// Gmail email address and password for google spreadsheet
$user = "
 This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
 ";
$pass = "your email password";
 
// Google Spreadsheet ID (You can get it from the URL when you view the spreadsheet)
$GSheetID = "0AqPXsH_13gn4dGsxbVZpc1JvYWJZd3JjWGxxbXlSSnc";
 
// od6 is the first worksheet in the spreadsheet
$worksheetID="od6";
 
// Include the loader and Google API classes for spreadsheets
require_once('Zend/Loader.php');
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
Zend_Loader::loadClass('Zend_Http_Client');
 
// Authenticate on Google Docs and create a Zend_Gdata_Spreadsheets object.            
$service = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
$client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $service);
$spreadsheetService = new Zend_Gdata_Spreadsheets($client);
 
// The function will echo out a list of spreadsheets in your account            
function DisplaySpreadsheets($feed)
{
    $i = 0;
    foreach($feed->entries as $entry) {
        if ($entry instanceof Zend_Gdata_Spreadsheets_CellEntry) {
        echo $entry->title->text .' '. $entry->content->text . "
";
    } else if ($entry instanceof Zend_Gdata_Spreadsheets_ListEntry) {
        echo $i .' '. $entry->title->text .' '. $entry->content->text . "
";
    } else {
        echo $i .' '. $entry->title->text . "
";
    }
    $i++;
    }
}
 
//The function will create a table of the data from your spreadsheet  
function DisplayWorksheetData($feed)
{
    echo ''; $rowData = $feed->entries[0]->getCustom(); echo ""; echo ''; foreach($rowData as $customEntry) { echo ""; } echo ""; $i = 2; // the first row of content is row 2 foreach($feed->entries as $row) { echo ""; $i++; $rowData = $row->getCustom(); foreach($rowData as $customEntry) { echo ""; } echo ""; } echo '
<table style="width: 200px;" border="1">
<tbody>
<tr>
<td>Row Number</td>
<td>" . $customEntry->getColumnName() . "</td>
</tr>
<tr>
<td>" . "Row " . $i .' '. $row->title->text . "</td>
<td>" . $customEntry->getText(). "</td>
</tr>
</tbody>
</table>
';
}
 
// First echo a list of your Google Spreadsheets
 
$feed = $spreadsheetService->getSpreadsheetFeed();
echo "
<h1>List of all your Spreadsheets</h1>
";
DisplaySpreadsheets($feed);
 
// echo the content of a specific Spreadsheet/Worksheet
// set a query to return a worksheet and echo the contents of the worksheet
 
$query = new Zend_Gdata_Spreadsheets_ListQuery();
$query->setSpreadsheetKey($GSheetID);
$query->setWorksheetId($worksheetID);
$listFeed = $spreadsheetService->getListFeed($query);
 
echo "
 
";
echo "
<h1>List of data in your Spreadsheet</h1>
";
DisplayWorksheetData($listFeed);
 

$1.99

Includes working php source code with images, style sheet and javascript.

Thie php script automatically generates a navigation menu based on the pages in the same directory.

The php script does the following:

• Loops through all the files in the directory looking for php, html and htm files
• Uses the PHP Simple HTML DOM Parser to find the page h2 title with id="maintitle"
  Note: you can set it to find any tag on the page
• It stores the page title and the page URL
• It alphabetizes the pages and displays the into a <li> list
• Using jQuery the current <li> item class is set to "active"

Demo uses a modified version of a free template from CSS Heaven

Also made the loopedslider dynamic so it dynamically grabs all the images in the slideshow directory and reads the image metadata for the title and text.

In order for the example to work below you will need to add the following code to each of your web pages. This is what the script looks for and makes it the text part of the sidebar links

 
  <h2 id="maintitle">Your Title</h2>
 

auto_navigation.php
<!--
//----------------------------------------------------
// Auto Navigation Scripts
// Created by Jaz Witham (Jazzerup)
// 2011
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
// Script reads the php, htm and html files in a directory
// and builds a navigation bar.
//----------------------------------------------------
-->
<?php
include 'simple_html_dom.php';
 
//Webite URL to that current directory
$dirURL =  dirname("http://" . $_SERVER['HTTP_HOST']  . $_SERVER['REQUEST_URI']);
 
//get the current folder you are in
$dirpath = getcwd();
 
$folder = opendir($dirpath);
$file_types = array("php", "htm", "html");
$index = array();
$filelist = array();
 
//Loop through the files in the directory
while ($file = readdir ($folder)) {
  if(in_array(substr(strtolower($file), strrpos($file,".") + 1),$file_types))
      {                   
    $html = file_get_html("$dirpath/$file");
  //Checking for a homepage so it always displays first int he list and is not alphabetized with the rest of the files.
  if ($file == "index.php"){
    //$homepgtime = $html->find('h2[id=maintitle]',0)->plaintext;
    $homepgtime = "Home";    
  }else{    
    $filelist[] = array('mytitle' => $html->find('h2[id=maintitle]',0)->plaintext, 'mypath' => $dirURL . "/" . $file);
  }
    }
}
 
//array to sort a 2-dimentional array
function array_qsort2 (&$array, $column=0, $order="ASC") {
  $oper = ($order == "ASC")?">":"<"; 
  if(!is_array($array)) return;
  usort($array, create_function('$a,$b',"return (\$a['$column'] $oper \$b['$column']);")); 
  reset($array);
}
array_qsort2($filelist, "mytitle", "ASC");
 
//Build the <li> list.  The homepage always listed first
echo "<li><a href='index.php' accesskey='1'>$homepgtime</a></li>";
 
$j = 1;
//Loop through the rest of the files
for($i=0; $i<sizeof($filelist); $i++) {
$j = $j + 1;  
  echo "<li><a href='" . $filelist[$i]['mypath'] . "' accesskey='$j'>" .$filelist[$i]['mytitle'] . "</a></li>";
  }
//clean up
closedir($folder);
 
?>
 
 

This jQuery will add the "active" class to the current item in your navigation

 
<script type="text/javascript">
$(document).ready(function(){     
  var str = $("#maintitle").text();    
  $('.nav').children().each(function(){
  if (str == $(this).text()) {
    $(this).addClass('active');
  } else { 
    $(this).removeClass('active') }
  });
});
</script>
 

$1.99

Includes working source code with images, style sheet and javascript.

One of my favorite free jquery slideshow scripts is Jquery Carousel Lite

The major problem I had with the script is everytime I wanted to add another picture to the slideshow, I had to modify the jquery code to include that image. I wrote a script that will do the following:

1) Automatically lists the image files inside a directory and load them into your jquery carousel.

2) Reads the picture metadata and adds it to the jquery carousel script

• Metadata: Title becomes the Image Alt Tag
• Metadata: Subject becomes the Image Link URL
• Metadata: Comments becomes the Caption

carouselexample.php
//----------------------------------------------------
// jQuery Carousel Enhancement
// Created by Jaz Witham (Jazzerup)
// 2011
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
// Script reads the image files and 
// image metadata into the jQuery Carousel Script
//----------------------------------------------------
 
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<head>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js" type="text/javascript"></script> 
<script src="js/jcarousellite_1.js" type="text/javascript"></script>
</head>
<body>
<!-- Carousel -->
<div id="carousel"> <a href="#" title="Previous" class="prev">Previous</a> <a href="#" title="Next" class="next">Next</a>
  <div style="visibility: visible; overflow: hidden; position: relative; z-index: 2; left: 0px; width: 864px;" class="content">
    <ul style="margin: 0pt; padding: 0pt; position: relative; list-style-type: none; z-index: 1; width: 2592px; left: -864px;">
 
<?php 
//Relative path to yout image directory
$dirpath = "../slideshow";
//Website URL to that same image directory
$dirURL = "http://www.jazzerup.com/blogexamples/slideshow/";
 
$folder = opendir($dirpath);
$pic_types = array("jpg", "jpeg");
$alttag = ""; 
$websiteurl= ""; 
$caption = ""; 
$index = array();
 
//Loop through the images in the directory
while ($file = readdir ($folder)) {
  if(in_array(substr(strtolower($file), strrpos($file,".") + 1),$pic_types))
      {                       
      $items[] = $file;            
    }
}
//each time it loads it shuffles the images
shuffle($items);
for($i=0; $i<sizeof($items); $i++) {
  $picpath = $dirpath . "/" . $items[$i];
  $exif = exif_read_data($picpath, 'EXIF');
  $alttag = $exif['Title']; //alt tag
  $websiteurl= $exif['Subject']; //website url
  $caption = $exif['Comments']; //caption
 
  $varimages = $varimages . "<li style='overflow: hidden; float: left; width: 216px; height: 136px;'>";
 
//Build the html code based on the metadata 
  $varimages =  $varimages . " <img src='$picpath' height='120' width='200' style='border:3px solid #FFF;' alt='$alttag' />" . "\n\n" ;
 
  $alttag = ""; 
  $websiteurl= ""; 
  $caption = "";
  $varimages =  $varimages . "</li>";
 }
closedir($folder);
 
echo $varimages;
?>
    </ul>
  </div>
</div>
<!-- [END] Carousel --> 
<script type="text/javascript">
    $(window).load(function() {
 
      $("#carousel .content").jCarouselLite({
          btnNext: ".next",
          btnPrev: ".prev",
          speed: 800,
          visible: 4
      });
 
 
    });
    </script>
</body>
 

$1.99

Includes working source code with images, style sheet and javascript.

One of my favorite free jquery slideshow scripts is Jquery Looped Slider

The major problem I had with the script is everytime I wanted to add another picture to the slideshow, I had to modify the jquery code to include that image. I wrote a script that will do the following:

1) Automatically lists the image files inside a directory and load them into your jquery carousel.

2) Reads the picture metadata and adds it to the jquery carousel script

• Metadata: Title becomes the Image Alt Tag
• Metadata: Subject becomes the Image Link URL
• Metadata: Comments becomes the Caption

loopedslider_example.php
//----------------------------------------------------
// Looped Slider Example
// Created by Jaz Witham (Jazzerup)
// 2011
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
// Script reads the image files and 
// image metadata into a looped jquery gallery script
//----------------------------------------------------
<div id="header">
<div id="slider">  
  <div class="container">
    <ul class="slides">
         <?php 
//Relative path to yout image directory
$dirpath = "slideshow";
//Website URL to that same image directory
$dirURL = "http://www.jazzerup.com/blogexamples/loopedslider/slideshow/";
 
$folder = opendir($dirpath);
$pic_types = array("jpg", "jpeg");
$alttag = ""; 
$websiteurl= ""; 
$caption = ""; 
$index = array();
 
//Loop through the images in the directory
while ($file = readdir ($folder)) {
  if(in_array(substr(strtolower($file), strrpos($file,".") + 1),$pic_types))
      {                       
      $items[] = $file;            
    }
}
//each time it loads it shuffles the images
shuffle($items);
for($i=0; $i<sizeof($items); $i++) {
  $picpath = $dirpath . "/" . $items[$i];
  $exif = exif_read_data($picpath, 'EXIF');
  $alttag = $exif['Title']; //alt tag
  $websiteurl= $exif['Subject']; //website url
  $caption = $exif['Comments']; //caption
    $title = $exif['Title']; //title
  $comments = $exif['Comments']; //comments
 
 $varimages = $varimages . "<li><div class='thumbholder'>";
 
 
//Build the html code based on the metadata 
  if ($caption != "") {
    $caption =  "title='" . $caption  . "'";
    $alt = "alt='" . $caption  . "'";
  }
  if ($alttag != "") {
    $alt =  "alt='" . $alttag . "'";
  }
  if ($websiteurl != "") {
    $varimages =  $varimages . " <a href='$websiteurl'><img src='$picpath' $alt $caption width='625' height='254' /></a>" ;
  } else {
  $varimages =  $varimages . " <img src='$picpath' $alt $caption width='625' height='254'  />";
      }
  $alttag = ""; 
  $websiteurl= ""; 
  $caption = ""; 
  $varimages =  $varimages . "</div><div class='txtholder'>
            <h2>$title</h2>
          <p>$comments </p></div></li>";
}
closedir($folder);
 
echo $varimages;
?>
 
 
    </ul>
  </div>
  <ul class="pagination">
 <?php   
 for($i=0; $i<sizeof($items); $i++) {
  echo "<li><a href='#'>$i</a></li>";
 }
    ?>
    </ul>  
  </div>
</div>
</div>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js" ></script>
<script src="js/loopedslider.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
$(document).ready(function(){     
    $('#slider').loopedSlider({
      autoStart: 8000,
      restart: 0,
      slidespeed: 2000,
      fadespeed: 800
    });  
});
</script>
 
 

$1.99

Includes working source code with images, style sheet and javascript.

One of my favorite free jQuery slideshow scripts is Nivo Slider

The major problem I had with the script is everytime I wanted to add another picture to the slideshow, I had to modify the jquery code to include that image. I wrote a script that will do the following:

1) Automatically lists the image files inside a directory and load them into your nivo slider.

2) Reads the picture metadata and adds it to the Nivo script

• Metadata: Title becomes the Nivo Image Alt Tag
• Metadata: Subject becomes the Nivo Image Link URL
• Metadata: Comments becomes the Nivo Caption
  

nivoexample.php
<!--
//----------------------------------------------------
// Nivo Slider Enhancement
// Created by Jaz Witham (Jazzerup)
// 2011
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
// Script reads the image files and 
// image metadata into the nivo slider script
//----------------------------------------------------
-->
<body>
<div id="wrapper"> 
  <div class="slider-wrapper theme-default">
    <div class="ribbon"></div>
    <div id="slider" class="nivoSlider">
<?php 
//This php code will generate your list of images based on 
//image files in a folder
 
$dirpath = "slideshow";
$dirURL = "http://www.jazzerup.com/blogexamples/slideshow/";
$folder = opendir($dirpath); // Use 'opendir(".")' if the PHP file is in the same folder as your images. Or set a relative path 'opendir("../path/to/folder")'.
$pic_types = array("jpg", "jpeg", "gif", "png");
$alttag = ""; //caption
$websiteurl= ""; //alt tag
$caption = ""; //website url
 
$index = array();
while ($file = readdir ($folder)) {
  if(in_array(substr(strtolower($file), strrpos($file,".") + 1),$pic_types))
      {                       
      $items[] = $file;                                  
      }
}
for($i=0; $i<sizeof($items); $i++) {                  
  $picpath = $dirpath . "/" . $items[$i];
 
  //Get the meta data
  $exif = exif_read_data($picpath, 'EXIF');
  $alttag = $exif['Title']; //alt tag
  $websiteurl= $exif['Subject']; //website url
  $caption = $exif['Comments']; //caption
  if ($caption != "") {
    $caption =  "title='" . $caption  . "'";
    $alt = "alt='" . $caption  . "'";
  }
  if ($alttag != "") {
    $alt =  "alt='" . $alttag . "'";
  }
  if ($websiteurl != "") {
    $varimages =  $varimages . " <a href='$websiteurl'><img src='$picpath' $alt $caption /></a>" . "\n\n" ;
  } else {
  $varimages =  $varimages . " <img src='$picpath' $alt $caption />" . "\n\n" ;
      }
  $alttag = ""; //caption
  $websiteurl= ""; //alt tag
  $caption = ""; //website url
}
closedir($folder);
$varimages = substr_replace($varimages ,"",-1);
echo $varimages;
?>
    </div>
  </div>
</div>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js" type="text/javascript"></script>
<script type="text/javascript" src="js/jquery.nivo.slider.pack.js"></script> 
<script type="text/javascript">
    $(window).load(function() {
        $('#slider').nivoSlider();
    });
    </script>
</body>
 
 
 

Updating Metadata in a file is very easy. On windows:

1. Right click on the file
2. Select Properties
3. Select the "Details" tab
4. Update Title, Subject and Comments and press "Okay"

Romantic ideas for using love coupons:

1. Love coupons make excellent birthday and holiday gifts. Give your partner a romantic card filled with love coupons.
2. Trade your partner for love coupons. Use them as relationship currency.
3. Forget flowers, get your partner a bouquet of love coupons.
4. Use as stocking stuffers
5. Print out several of one coupon and let them redeem them over and over again.

Sample Coupon:

Unique about these love coupons:

• You can set an expiration date
• Funny but useful disclaimer on the bottom of each coupon: "Non-Transferable. Not valid with any other offer. One coupon per
  recipient per day. Coupon must be surrendered at time of use. Not for resale. No cash value. Void where prohibited. "
• Includes several blank templates so you can create your own custom love coupons

In this package you will get 20 love coupons

1. Breakfast in Bed
2. Your Choice of Dinner and Drinks
3. One Kiss Anywhere you Choose
4. Strip Tease
5. A Bubble Bath for Two
6. Evening Together with Electronics Off
7. Get out of One Household Chore
8. A Day to Yoursself to do Whatever you Want
9. 15 Minute Back Massage
10. 1 Hour of Cuddling
11. 24 Hours of no Arguments
12. 15 Minute Erotic (clothing optional)
13. 2 Hours of Alone Time (Just the two of you)
14. 10 Minute Soothing Foot Massage
15. 20 Minute Head and Neck Massage
16. Get out of trouble free pass
17. A free "I'm Sorry"
18. Blank
19. Blank (______ hours of _______)
20. Blank (______ minutes of ______)

Ideas for your Blank Coupons:

• Free Manicure (or pedicure)
• I Grant You 3 Wishes (be careful with this one!)
• Let's Have Alone Time (two hours with just the two of you)
• Hit the Links! (let them play a round of golf even though there are chores to do)
• A Day at the Beach (you'll bring treats!)
• Take the Night Off! (let them go out with friends - you'll watch the kids if have 'em)
• 30 Minutes of Mellow (1/2 hour relaxing together on the couch, on the deck, in bed, in a hammock - their choice)
• Bath Fit for a King/Queen (a long bath while you set the music, bring them wine and snack like grapes or cheese)
• I'll Cook AND Clean! (cook dinner for them and do the dishes)
• Movie Night (or video - whatever they want)
• You Control the Remote (watch the game or tv show of their choice - no complaining!)
• Sweets for My Sweetie? (make homemade cookies, brownies, or whatever for them - or do it together)
• Music and Merry (relax with their favorite music and a glass of wine)
• Hit the Town! (go out for a drink or a night on the town)
• Soak it Up (relax in a hot tub together)
• Get Out of Trouble Free
• Your Favorite Dessert (take them out for their favorite sweet treat)
• Shall We Play a Game? (any game of their choice)
• Yes Boss! (do one chore they hate to do around the house - washing their car or cleaning the interior, cleaning a room/fridge/windows, yard work)
• Candlelit Dinner (you'll cook)
• Romantic Restaurant (their choice)
• Sunday Brunch (their choice)
• Moonlit Walk
• Photo Shoot (let them photograph you however they want)
• Nice Day for a Picnic (romantic picnic at a spot of their choice)
• Let's Watch the Sunset (with a bottle of wine of course)
• Cuddle Next to a Fire (indoor or out)
• Romantic Movie (whatever they want - no complaints)
• Let's Spend the Night Out (spend the night at a hotel)
• May I Have This Dance? (15 minutes of slow dancing to the music of their choice)
• I'm Feeling Bubbly! (candlelit bubble bath together)
• Skinny Dipping
• Hail Caesar! (feed them chocolate, strawberries, grapes, while listen to their favorite music)
• Strip Poker
• Striptease
• Quickie (you don't mind!)
• Dress Me Up (you'll wear sexy lingerie, an outfit, or costume of their choice)
• Ice is Nice (creative use of ice cubes)
• Phone Sex
• Your Wish is My Command (grant 3 intimate wishes - must be cashed in the same night)
• Special Massage (candlelit sensual massage with a happy ending)
• Let My Tongue do the Talking (oral adventures)
• Let's Get Dirty in the Shower!
• The Boobs and Nothing but the Boobs (popular with the guys)
• The Answer is YES (whatever they want, they get)
• Honey, Get the Honey (try sex with whipped cream, strawberries, chocolate, honey, or some other fun food)
• Fantasy Island (fulfill one of their deep, dark fantasies)
• Batteries Not Included (pick out a toy at an adult store)
• Role Play (pretend to be whatever they want for a night)
• It's Good to be the King/Queen (you do whatever they want)
• Tie Me Up Tie Me Down (handcuffs, rope, blindfold, or whatever)
• Almost Famous (watch an adult film and act out the scenes)

(examples from: http://www.hotdateideas.com/love-coupons)