[insert_php]
$url = ‘https://docs.google.com/spreadsheets/d/1VvEoW8dXscbIHhvFWwnU-jWlgCHALVaoQgy3QMGblc8/gviz/tq?tq=select%20B%2CC%2CI%2CAI%20’;
$json = file_get_contents($url); //enhavo de la dosiero
$pos = strpos($json, ‘({‘); //posicio de la komenco de la gravaj informoj
$json = substr($json, $pos+1, strlen($json)-$pos-3); //forigo de la neutilaj informoj
$obj = json_decode($json, true); //objektivigo de la JSON dosiero
echo ‘
Prénom | Nom de famille | Pays |
---|---|---|
‘ . $row[‘c’][0][‘v’] . ‘ | ‘. $row[‘c’][1][‘v’]. ‘ | ‘ . $row[‘c’][2][‘v’]. ‘ |
— | — | ‘ . $row[‘c’][2][‘v’] . ‘ |
‘;
[/insert_php]