ansaurus

Question

Answer 1

A:

Thank you for your great script, whoever it did not work for me ...

I changed it to look like this.

    $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname);
$int_y_pos = -1; 
$int_y_step_small = 1;
$sql = "SELECT * from cache"; 
$sql = mysql_query($sql);
$rownum = mysql_num_rows($sql);
?> 
<html xmlns="http://www.w3.org/1999/xhtml"&gt;
  <head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
    <title>
      Google Visualization API Sample
    </title>
    <script type="text/javascript" src="http://www.google.com/jsapi"&gt;&lt;/script&gt;
    <script type="text/javascript">
      google.load('visualization', '1', {packages: ['table']});
    </script>
    <script type="text/javascript">
    function drawVisualization() {
      // Create and populate the data table.
      var data = new google.visualization.DataTable();
        data.addColumn('string', 'col1');
        data.addColumn('string', 'col2');
<?php
echo "     data.addRows($rownum);\n";
while($row = mysql_fetch_assoc($sql)) {
        $int_y_pos += $int_y_step_small; 
        echo "     data.setCell(" . $int_y_pos . ", 0,'". $row['col1']  . "');\n"; 
        echo "     data.setCell(" . $int_y_pos . ", 1,'" . $row['col2']  . "');\n"; 
} 

?> 
 // Create and draw the visualization.
      visualization = new google.visualization.Table(document.getElementById('table'));
      visualization.draw(data, null);
    }


    google.setOnLoadCallback(drawVisualization);
    </script>
  </head>
  <body style="font-family: Arial;border: 0 none;">
    <div id="table"></div>                  
  </body>
</html>

kithros 2010-08-26 17:45:51

ansaurus

tags:

views:

answers:

Google Visualization Api + SQL

related questions