setSpreadsheetKey("0AuPh9cI948YxdGFTcG0tNEZQdExtQkVxUlZyQW5tbkE");
$query->setWorksheetId("od6");
} catch (Exception $e) {
die('ERROR: ' . $e->getMessage());
}
// Get a list of the 2nd, 3rd, and 4th row (glossary_media, glossary_name, glossary_definition) and put into an array
$query->setReturnEmpty(true);
$query->setMinCol(2);
$query->setMaxCol(4);
$query->setMinRow(2);
$cellFeed = $service->getCellFeed($query);
// Populate the data_arrays
$array_counter = 1;
foreach ($cellFeed as $cellEntry) {
if ($array_counter == 1) {
$glossary_medias[] = str_replace(" ", "", $cellEntry->getCell()->getText());
} elseif ($array_counter == 2) {
$glossary_names[] = $cellEntry->getCell()->getText();
} elseif ($array_counter == 3) {
$glossary_definitions[] = str_replace("\n", " ", $cellEntry->getCell()->getText());
}
// Reset array counter when all of row data is entered
$array_counter < 3 ? $array_counter++ : $array_counter = 1;
}
// Show specific glossary_name when link is clicked
/*
if ($heme_glossary_name) {
if (array_search($heme_glossary_name, $glossary_names)) {
echo "
\n";
print_footer();
exit;
} else {
echo "Glossary term not found.";
}
}
*/
// Show list of terms for comparison and put them in a table
if ($checkedname) {
echo "
\n";
// Get all images
for ($i = 0; $i < count($checkedname); $i++) {
$media_string = '';
if ($glossary_medias[array_search($checkedname[$i], $glossary_names)]) { // Check to see if any media links are associated with glossary name
unset($media_list);
$media_list = explode(",", $glossary_medias[array_search($checkedname[$i], $glossary_names)]);
for ($z = 0; $z < count($media_list); $z++) {
$media_string .= "