2017 © Pedro Peláez
 

library googlecms

A PHP class that uses Google Spreadsheets as CMS.

image

mcsodbrenner/googlecms

A PHP class that uses Google Spreadsheets as CMS.

  • Thursday, January 21, 2016
  • by McSodbrenner
  • Repository
  • 1 Watchers
  • 0 Stars
  • 22 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 0 Forks
  • 0 Open issues
  • 3 Versions
  • 0 % Grown

The README.md

GoogleCMS

A PHP class that uses Google Spreadsheets as CMS., (*1)

Use this spreadsheet as an example on how to construct a spreadsheet: https://docs.google.com/spreadsheets/d/1LNvJWag9RNHiF6dtKSFVgYhbK_y7jFa4C3UTI-RUiO0/edit#gid=0, (*2)

Take a look at the example that show the parsed result of the example sheet above., (*3)

Usage

// Extract this id from the URL of your spreadsheet
$spreadsheet_id = '1LNvJWag9RNHiF6dtKSFVgYhbK_y7jFa4C3UTI-RUiO0';

// With the Google Data API it is only possible to get one spreadsheet per request
// So we request all sheets in parallel
// Because Google prevents request flooding we build blocks of 10 requests that are excecuted in parallel.
// This parameter is optional (default = 10)
$request_block_size = 10;

include('src/GoogleCMS.php');
$cms = new McSodbrenner\GoogleCMS\GoogleCMS($spreadsheet_id, $request_block_size);


// Now we get the data. It is possible to build keys like "content1.subkey1" or "content1|subkey1" that are transformed into an array.
// This parameter is optional (default = '.')
$array_divider = '.';

$data = $cms->getData($array_divider);

print_r($data);

Hints

  • If you have to content ids with the same name, the content is put into an array.
  • Use [IGNORE] in front of a sheet name to ignore the sheet in the results.

The Versions

21/01 2016

dev-master

9999999-dev

A PHP class that uses Google Spreadsheets as CMS.

  Sources   Download

MIT

The Requires

  • ext-curl *

 

20/01 2016

1.0.1

1.0.1.0

A PHP class that uses Google Spreadsheets as CMS.

  Sources   Download

MIT

The Requires

  • ext-curl *

 

20/01 2016

1.0.0

1.0.0.0

A PHP class that uses Google Spreadsheets as CMS.

  Sources   Download

MIT