StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><strong>Update:</strong></p> <p>Have a look at how you can add data to the chart. You have the possibility to <a href="http://code.google.com/apis/visualization/documentation/reference.html#DataTable_literal_constructor_example" rel="nofollow noreferrer">add data in JSON</a>.</p> <p>The only thing you have to do is to prepare a corresponding PHP array. Then you can serialize this array and set the data. E.g.</p> <pre><code><?php // $data is an array and already has the correct structure... $jdata = json_encode($data); ?>  <script type='text/javascript'> google.load('visualization', '1', {'packages': ['geomap']}); google.setOnLoadCallback(drawMap); function drawMap() { var data = new google.visualization.DataTable(<?php echo $jdata ?>); var options = {}; options['dataMode'] = 'regions'; var container = document.getElementById('map_canvas'); var geomap = new google.visualization.GeoMap(container); geomap.draw(data, options); }; </script> </code></pre> <p>I recommend to read the documentation / <a href="http://code.google.com/apis/visualization/documentation/reference.html" rel="nofollow noreferrer">API reference</a>. I basically found this just by searching...</p> <hr> <p>Without further information we cannot give a specific answer but a general approach is:</p> <p>Assuming that you already fetched the records from your DB in a result set <code>$results</code> than you can just loop over it:</p> <pre><code><?php foreach($results as $row): ?> data.setValue(<?php echo $row['column1']; ?>, <?php echo $row['column2']; ?>); // depends on what type of char you want to create, on your actual data etc. <?php endforeach; ?> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload