PHP Test
”) $search = $search; else $search = ”; ?>
google.load('visualization', '1', packages: ['table']); var visualization;
function drawVisualization()
var query = new google.visualization.Query( 'http://spreadsheets.google.com/tq?key=0Au0WkOi_oKm0dDNwYkUxRkRqUzVKa1ZEWnFyYXpnaWc&hl=en_GB');
query.setQuery('SELECT A, B, C where upper(A) like upper("%%") or upper(B) like upper("%%") order by A asc label A "Type", B "Title", C "Date added"');
query.send(handleQueryResponse);
function handleQueryResponse(response) if (response.isError()) alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return;
var data = response.getDataTable();
visualization = new google.visualization.Table(document.getElementById('table')); visualization.draw(data, legend: 'bottom');
google.setOnLoadCallback(drawVisualization);