We can't test your PHP code, can you post the javascript output by the PHP? Open the page in a browser, view the page source, and paste it here.
On Friday, March 22, 2013 10:18:29 AM UTC-4, Mike Sherman wrote: > > > <https://lh6.googleusercontent.com/-d1H3MkG3qv4/UUxn2kxTR3I/AAAAAAAABEU/lYPz0hJxLHg/s1600/Capture2.JPG> > I am trying to show both a map with coordinates and a table of data for a > specific page and I am trying to add dropdowns to filter both the map and > the table. > I was able to draw the map and table with no problems, but then I tried to > use a dashboard for the first time. The table come up just fine, but the > map will not show anymore. I set the view options to what I believe are the > proper settings. > Here is my code: > <script type="text/javascript"> > google.load('visualization', '1.0', {packages: ['controls']}); > > </script> > <script type="text/javascript"> > > google.setOnLoadCallback(drawVisualization); > function drawVisualization(){ > > <?php > //echo "var geoData = google.visualization.arrayToDataTable([['Lat', > 'Lon', 'Value', 'Name','Date','Event'],"; > echo "var geoData = new google.visualization.DataTable();"; > echo"geoData.addColumn('number', 'Lat');"; > echo"geoData.addColumn('number', 'Lon');"; > echo"geoData.addColumn('string', 'Value');"; > echo"geoData.addColumn('number', 'Name');"; > echo"geoData.addColumn('string', 'Date');"; > echo"geoData.addColumn('number', 'Event');"; > for($f = 0; $f < $count; $f++) > { > $var0 = mysql_result($result2,$f,'xcoor'); > $var1 = mysql_result($result2,$f,'ycoor'); > $var2 = mysql_result($result2,$f,'hh_number'); > $var3 = mysql_result($result2,$f,'icemr_site'); > $var4 = mysql_result($result2,$f,'hh_type'); > $var5 = mysql_result($result2,$f,'hh_number'); > $var6 = mysql_result($result2,$f,'today'); > $var7 = mysql_result($result2,$f,'event_id'); > switch ($var3) { > case '1': > $var3 = "Choma"; > break; > case '2': > $var3 = "Nchelenge"; > break; > case '3': > $var3 = "Mutasa"; > break; > default: > $var3 = "unknown"; > } > switch ($var4) { > case '1': > $var4 = "Cross-Sectional"; > break; > case '2': > $var4 = "Longitudinal"; > break; > default: > $var3 = "unknown"; > } > echo"geoData.addRow([".$var0.",".$var1.",'".$var2." - > ".$var3." - ".$var4."',".$var5.",'".$var6."',".$var7."]);"; > } > //echo"]);";?> > > > var eventPicker = new google.visualization.ControlWrapper({ > 'controlType': 'CategoryFilter', > 'containerId': 'control1', > 'options': { > 'filterColumnLabel': 'Event', > 'ui': { > 'labelStacking': 'vertical', > 'allowTyping': false, > 'allowMultiple': false > } > } > }); > > var namePicker = new google.visualization.ControlWrapper({ > 'controlType': 'CategoryFilter', > 'containerId': 'control2', > 'options': { > 'filterColumnLabel': 'Name', > 'ui': { > 'labelStacking': 'vertical', > 'allowTyping': false, > 'allowMultiple': false > } > } > }); > > var table = new google.visualization.ChartWrapper({ > 'chartType': 'Table', > 'containerId': 'table_div', > 'options': { > 'alternatingRowStyle': true, > 'allowHtml': true, > 'page': 'enable', > 'pageSize': 15 > } > }); > > > var map = new google.visualization.ChartWrapper({ > 'chartType': 'Map', > 'containerId': 'map_div', > 'options': { > 'mapType': 'normal', > 'showTip': true, > 'useMapTypeControl': true, > 'enableScrollWheel': true > > }, > 'view': {'columns': [ 0, 1, 2 ]} > }); > > var dashboard = new > google.visualization.Dashboard(document.getElementById('dash_div')); > > dashboard.bind(namePicker, map); > dashboard.bind(eventPicker, map); > dashboard.bind(namePicker, table); > dashboard.bind(eventPicker, table); > > dashboard.draw(geoData); > } > > </script> > > <?php > echo"</head>"; > echo"<div id=\"dash_div\" style=\"width:100%; height: 100%;\">"; > echo"<table>"; > echo"<tr><td><div id=\"control1\"></div><div > id=\"control2\"></div></td></tr>"; > echo"<tr><td><div id=\"map_div\" style=\"width:50%; height: > 50%;\"></div></td></tr>"; > echo"<tr><td ><div id=\"table_div\"></div></td></tr>"; > echo"</table>"; > echo"</div>"; > echo"</html>"; > ?> > > Thanks for any help, just not too sure what is wrong. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
