Inscrits

[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 ‘

‘; //kreado de la tabelo
foreach ($obj[‘table’][‘rows’] as $row) {
echo ”;
if($row[‘c’][3][‘v’] == ‘x’) {
echo ‘

‘;
}
else {
echo ‘

‘;
}
}

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]