-
-
Save pamelafox/770584 to your computer and use it in GitHub Desktop.
<?php | |
// Parsing this spreadsheet: https://spreadsheets.google.com/pub?key=0Ah0xU81penP1dFNLWk5YMW41dkcwa1JNQXk3YUJoOXc&hl=en&output=html | |
$url = 'http://spreadsheets.google.com/feeds/list/0Ah0xU81penP1dFNLWk5YMW41dkcwa1JNQXk3YUJoOXc/od6/public/values?alt=json'; | |
$file= file_get_contents($url); | |
$json = json_decode($file); | |
$rows = $json->{'feed'}->{'entry'}; | |
foreach($rows as $row) { | |
echo '<p>'; | |
$title = $row->{'gsx$title'}->{'$t'}; | |
$author = $row->{'gsx$author'}->{'$t'}; | |
$review = $row->{'gsx$review'}->{'$t'}; | |
echo $title . ' by ' . $author . '<br>' . $review; | |
echo '</p>'; | |
} | |
// See this here: http://imagine-it.org/google/spreadsheets/showspreadsheet.php | |
?> |
@danylokiz @LucAwater
for getting data from other sheets u can use
For sheet 2
https://spreadsheets.google.com/feeds/list/1ppywkX1g_0ynTIs6qQvCMzsandxLqMUHFDR0SQyjvtA/2/public/values?alt=json
For sheet 3
https://spreadsheets.google.com/feeds/list/1ppywkX1g_0ynTIs6qQvCMzsandxLqMUHFDR0SQyjvtA/3/public/values?alt=json
[ Original Spreadsheet
https://docs.google.com/spreadsheets/d/1ppywkX1g_0ynTIs6qQvCMzsandxLqMUHFDR0SQyjvtA/edit#gid=1
]
When i run this program it give me an error, can you please tell me any solution
Error are:
Notice: Trying to get property 'feed' of non-object in D:\xampp\htdocs\spreadsheet\test.php on line 5
Notice: Trying to get property 'entry' of non-object in D:\xampp\htdocs\spreadsheet\test.php on line 5
Warning: Invalid argument supplied for foreach() in D:\xampp\htdocs\spreadsheet\test.php on line 6
hey there,
just came across this feature i want to experiment with myself.
could you perhaps show how you would add a 4th entry, for example $genre = $row->{'gsx$genre'}->{'$t'};
and group the rows by genre?
(so they would all sit in the same div from the echo)
thank you!
V3 of the API will go away later this year, V4 is much easier to use, but needs an API Key
<?php
$url = 'https://sheets.googleapis.com/v4/spreadsheets/{sheetId}/values/{sheetName}?key={API_KEY}';
$json = json_decode(file_get_contents($url));
$rows = $json->values;
foreach($rows as $row) {
var_dump($row);
}
https://gist.github.com/marcus-at-localhost/1886c1f35647ff682752c19880bd9dd1
So when i have it i can reload from google table something to json?