Portfolio | Joshua de la Bruere

setApplicationName('PortfolioContentmangaer'); $client->setScopes([\Google_Service_Sheets::SPREADSHEETS]); $client->setAccessType('offline'); $client->setAuthConfig(__DIR__ . '/servicekey.json'); $service = new Google_Service_Sheets($client); $spreadsheetId = "1TuJ_Md4u0EuVW9010NcIJj2tNzI1F0Wz200OErR0ZK0"; echo '

'; $range = 'portArt!A2:E30'; $response = $service->spreadsheets_values->get($spreadsheetId, $range); $values = $response->getValues(); if (empty($values)) { print 'No data found. /n'; } else { foreach ($values as $row) { echo '

'; echo $row[0].'

'; echo ' Avatar

'; echo $row[4].'

'; } } echo '

'; ?>