<?php echo '<'.'?xml version="1.0" encoding="UTF-8"?'.'>'; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr"
lang="fr">
<head>
<title>i974^6 : Démo</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<style type="text/css">
@import url(style.css);
</style>
</head>
<body>
<?php
/* Constantes à modifier */
define('GOOGLE_ACCT', 'user@gmail.com'); // e-mail
define('GOOGLE_PASS', 'password'); // mot de passe
define('GOOGLE_SPREADSHEET_KEY', 'pNbF52sa_1RqDqKkHnUHbQA'); // clé du document
define('GOOGLE_WORKSHEET_ID', 'od6'); // id de la feuille
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Gdata_Docs');
Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
try {
$service = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
$client = Zend_Gdata_ClientLogin::getHttpClient(GOOGLE_ACCT, GOOGLE_PASS, $service);
} catch (Exception $e) {
$error = '<p><strong>Erreur :</strong> Connexion à Google Spreadsheets.</p>';
}
if ($client) {
$spreadsheetService = new Zend_Gdata_Spreadsheets($client);
try {
/* Insertion des données */
'prenom' => $_POST['prenom'],
'nom' => $_POST['nom'],
'adresse' => $_POST['adresse'],
'codepostal' => $_POST['codepostal'],
'ville' => $_POST['ville'],
'commentaires' => 'Inscription Internet le '.date('d/m/Y')
);
$spreadsheetService->insertRow($data, GOOGLE_SPREADSHEET_KEY, GOOGLE_WORKSHEET_ID);
} catch (Exception $e) {
$error = '<p><strong>Erreur :</strong> Insertion impossible.</p>';
}
}
echo $error;
else
echo '<p>Vos données ont bien été ajoutées.</p>';
} else {
?>
<p>Veuillez remplir le formulaire ci-dessous :</p>
<form method="post" action="index.php">
<p><label>Nom</label> <input type="text" name="nom" /></p>
<p><label>Prénom</label> <input type="text" name="prenom" /></p>
<p><label>Adresse</label> <input type="text" name="adresse" /></p>
<p><label>Code postal</label> <input type="text" name="codepostal" /></p>
<p><label>Ville</label> <input type="text" name="ville" /></p>
<p><input type="submit" value="Enregistrer" /></p>
</form>
<?php } ?>
</body>
</html>