[insert_php]
$url = “https://spreadsheets.google.com/feeds/list/1i6klGu7VdHp3S5iXB7gtiC57u_Ad9r8vN9zFkZL5MUA/default/public/values?alt=json”;
$json = file_get_contents($url);
$data = json_decode($json, TRUE);
//$updated = $data[‘feed’][‘entry’][0][‘updated’][‘$t’];
//echo ‘Laatst bijgewerkt op: ‘.date(‘d-m-Y H:i’, strtotime($updated));
$array = $data[‘feed’][‘entry’];
$i = 0;
[/insert_php]
[insert_php]
foreach ($array as $value) {
if (!empty($data[‘feed’][‘entry’][$i][‘gsx$baannr’][‘$t’]))
{
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
}
else
{
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
}
$i++;
}
[/insert_php]
‘.$data[‘feed’][‘entry’][$i][‘gsx$baannr’][‘$t’].’ | ||
‘.$data[‘feed’][‘entry’][$i][‘gsx$datum’][‘$t’].’ | ‘.$data[‘feed’][‘entry’][$i][‘gsx$naam’][‘$t’].’ | ‘.$data[‘feed’][‘entry’][$i][‘gsx$score’][‘$t’].’ |
‘.$data[‘feed’][‘entry’][$i][‘gsx$datum’][‘$t’].’ | ‘.$data[‘feed’][‘entry’][$i][‘gsx$naam’][‘$t’].’ | ‘.$data[‘feed’][‘entry’][$i][‘gsx$score’][‘$t’].’ |