Advertisement
Guest User

Untitled

a guest
Apr 13th, 2013
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <script type="text/javascript" src="http://www.google.com/jsapi"></script>
  2. <script type="text/javascript">
  3. google.load('visualization', '1', {packages: ['table']});
  4. </script>
  5. <script type="text/javascript">
  6. var visualization;
  7.  
  8. function drawVisualization() {
  9.  
  10. var query = new google.visualization.Query(
  11. 'http://spreadsheets.google.com/tq?key=0Au0WkOi_oKm0dDNwYkUxRkRqUzVKa1ZEWnFyYXpnaWc&hl=en_GB');
  12.  
  13. query.setQuery('SELECT A, B, C where upper(A) like upper("%<?php global $current_user;
  14. get_currentuserinfo();
  15. echo 'User email: ' . $current_user->user_email . "\n";
  16. ?>%") or upper(B) like upper("%<?php global $current_user;
  17. get_currentuserinfo();
  18. echo 'User email: ' . $current_user->user_email . "\n";
  19. ?>%")');
  20.  
  21. query.send(handleQueryResponse);
  22. }
  23.  
  24. function handleQueryResponse(response) {
  25. if (response.isError()) {
  26. alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
  27. return;
  28. }
  29.  
  30. var data = response.getDataTable();
  31.  
  32. visualization = new google.visualization.Table(document.getElementById('table'));
  33. visualization.draw(data, {legend: 'bottom'});
  34.  
  35. }
  36.  
  37. google.setOnLoadCallback(drawVisualization);
  38. </script>
  39.  
  40. <div id="table"></div>
  41.  
  42. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement