ttskch / pheetsu
PHP library to CRUDify Google Spreadsheets like sheetsu.com
dev-master / 1.0.x-dev
2018-11-16 00:47 UTC
Requires
- php: >=5.6.0
- symfony/http-foundation: ^3.4|^4.1
- ttskch/google-sheets-api-php-client: @dev
Requires (Dev)
- friendsofphp/php-cs-fixer: ^2.3
- phpmd/phpmd: ^2.6
- phpunit/phpunit: ^5.7 || ^6.0
- squizlabs/php_codesniffer: ^2.8
This package is not auto-updated.
Last update: 2024-11-10 02:53:33 UTC
README
PHP library to CRUDify Google Spreadsheets like sheetsu.com.
Requirements
- PHP 5.6+
Installations
$ composer require ttskch/pheetsu:@dev
Usage
If you have a Google Spreadsheet like this,
You can CRUD the spreadsheet via pheetsu so easily like below.
Initializing with OAuth2
$pheetsu = \Ttskch\Pheetsu\Factory\PheetsuFactory::createOAuth( 'google_oauth2_client_id', 'google_oauth2_client_secret', 'google_oauth2_redirect_uri', 'google_oauth2_javascript_origin', '1JQkfd3dlyxFRuxIwGPnBnrxS-l-bLVw_BbHskxT9Nj4', // spreadsheet id 'demo' // sheet name ); // authenticate and be authorized with Google OAuth2. $pheetsu->authenticate();
Initializing with Service Account
$pheetsu = \Ttskch\Pheetsu\Factory\PheetsuFactory::createServiceAccount( '/path/to/your/service-account-credentials.json', '1JQkfd3dlyxFRuxIwGPnBnrxS-l-bLVw_BbHskxT9Nj4', // spreadsheet id 'demo' // sheet name );
Using
$rows = $pheetsu->read();
var_dump($rows);
// array (size=3)
// 0 =>
// array (size=3)
// 'id' => string '1' (length=1)
// 'name' => string 'Alice' (length=5)
// 'age' => string '20' (length=2)
// 1 =>
// array (size=3)
// 'id' => string '2' (length=1)
// 'name' => string 'Bob' (length=3)
// 'age' => string '25' (length=2)
// 2 =>
// array (size=3)
// 'id' => string '3' (length=1)
// 'name' => string 'Charlie' (length=7)
// 'age' => string '18' (length=2)
See also demo.