Open the page, enter 2013 into the date field, and click the submit button. When the page reloads, view the page source, copy it, and paste it here so I can see what your server is rendering.
On Wednesday, July 9, 2014 12:32:04 PM UTC-4, khalil negron wrote: > > Here is my code for some reason I am not getting my chart to load under > the table when the year 2013 is entered. > > <!doctype html> > <html> > <head> > <!-- links to scripit for jquery drop down calendar --> > <script src="//code.jquery.com/jquery-1.10.2.js"></script> > <script src= "//code.jquery.com/ui/1.10.4/jquery-ui.js"></script> > > <!-- links to CSS style sheets --> > <link href="styles/main.css" rel="stylesheet" type="text/css"> > <link href="styles/date.css" rel="stylesheet" type="text/css"> > <link href="styles/date2.css" rel="stylesheet" type="text/css"> > > > > <meta charset="utf-8"> > > > <title>Cartridge Details</title> > <!--The following script tag downloads a font from the Adobe Edge Web > Fonts server for use within the web page. We recommend that you do not > modify it.--> > <script>var __adobewebfontsappname__="dreamweaver"</script> > <script src=" > http://use.edgefonts.net/short-stack:n4:default;abel:n4:default;annie-use-your-telescope:n4:default.js"; > > type="text/javascript"></script> > </head> > > > > <!-- php connection to database to query table for Cartridge Details --> > <?php > $username = "root"; > $password = "kclaye1234"; > $hostname = "localhost"; > $my_db = "print_consump"; > > //connection to the database > $dbhandle = mysqli_connect($hostname, $username, $password, $my_db) > or die("Unable to connect to MySQL"); > echo "cond"; > > ?> > > <body> > <div class="divH"> > <header id="heading1">Cartridge Details</heade> > </div> > > <div class="LinkedPages"> > <form method="post" action="cartridgedetails.php" name="frm1"> > <div> > Date:<input type="text" name="YEAR" value="Enter Year (i.e '2013')"> > <input type="submit" value="submit"> > </div> > </form> > <span></span> > > <?php > > //formula for toner usage total pages/35000 = #toner used for month > > if(isset($_POST["YEAR"])) { > $year = $_POST['YEAR']; > $result = mysqli_query($dbhandle,"SELECT `Servers`, `Total Pages` / > 35000 FROM summaryofserver WHERE > RIGHT(Servers,4) = '$year'"); > $data = array(array('Server, Month, Year', 'Number of Toner Cartridges > Used')); > while($row = mysqli_fetch_array($result)) { > echo "<tr>"; > echo "<td>" . $row[0] . "</td>"; > echo "<td>" . $row[1] . "</td>"; > echo "</tr>"; > $data[] = array($row[0], $row[1]); > } > > } > > ?> > <script> > function drawChart () { > var data = google.visualization.arrayToDataTable(<?php echo > json_encode($data, JSON_NUMERIC_CHECK); ?>); > // draw a ColumnChart > // you can change this to whatever chart type you need > var chart = new > google.visualization.ColumnChart(document.querySelector('#myChart')); > chart.draw(data, { > // chart options, eg: > height: 400, > width: 600 > }); > } > google.load('visualization', '1', {packages: ['corechart'], callback: > drawChart}); > </script> > > <div id="myChart"></div> > > </div> > > > > > </body> > </html> > -- 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. For more options, visit https://groups.google.com/d/optout.
