PHP for parsing the JSON output a published Google spreadsheet and displaying columns from each row.

showspreadsheet.php

<?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
?>

Awesome! How do I get data from the other sheets?

Apparently, you can use 1, 2, 3, 4... However, for the first worksheet you would still need to use 'od6'

So when i have it i can reload from google table something to json?

@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