<?php
$column = $_REQUEST['column'];
$column = $column +1;
$myArray = google_sheet('put your google sheets URL here');
header('Location: ' . $myArray[$column]['C']);
exit;
function google_sheet($url = NULL) {
$array = array();
if ($url):
// initialize curl
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, $url);
curl_setopt($curl, CURLOPT_HEADER, 0);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, TRUE);
// get the spreadsheet data using curl
$sheet = curl_exec($curl);
curl_close($curl);
// find the table pattern and return the mark-up
preg_match('/(<table[^>]+>)(.+)(<\/table>)/', $sheet, $matches);
$data = $matches['0'];
// convert the HTML (XML) mark-up to JSON
$cells_xml = new SimpleXMLElement($data);
$cells_json = json_encode($cells_xml);
$cells = json_decode($cells_json, TRUE);
endif;
// Convert the JSON array to an array of just the table data
// This will strip out any Google Sheets formatting and identifiers if they exist
if ( is_array($cells) ):
foreach ($cells['tbody']['tr'] as $row => $row_data):
$column = 'A';
foreach ($row_data['td'] as $column_index => $cell):
// Check that the cell is populated and get the value.
if (!is_array($cell)):
$array[($row + 1)][$column++] = $cell;
elseif ($cell['div']):
$array[($row + 1)][$column++] = $cell['div'];
endif;
endforeach;
endforeach;
endif;
return $array;
}
?>
