Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <script type="text/javascript" src="http://www.google.com/jsapi"></script>
- <script type="text/javascript">
- google.load('visualization', '1', {packages: ['table']});
- </script>
- <script type="text/javascript">
- 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("%<?php global $current_user;
- get_currentuserinfo();
- echo 'User email: ' . $current_user->user_email . "\n";
- ?>%") or upper(B) like upper("%<?php global $current_user;
- get_currentuserinfo();
- echo 'User email: ' . $current_user->user_email . "\n";
- ?>%")');
- 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);
- </script>
- <div id="table"></div>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement