Hi Rcrisman,
Can you plz send me the database.Thanks in Advance.
On Friday, October 31, 2008 2:22:44 AM UTC+5:30, rcrisman wrote:
>
> Heres what I did for an Annotated Time Line using MySQL + PHP:
>
> <?php
>
> $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 count(id) AS count, DATE_FORMAT(date, '%Y, %m-1, %d')
> AS date FROM dtt WHERE date NOT LIKE '0000-00-00 00:00:00' AND date
> NOT LIKE '2000-00-00 00:00:00' GROUP BY DATE_FORMAT(date, '%Y, %m,
> %d')";
> $sql = mysql_query($sql);
> $rownum = mysql_num_rows($sql);
>
> ?>
> <html>
> <head>
> <script type="text/javascript" src="http://www.google.com/jsapi";></
> script>
> <script type="text/javascript">
> google.load("visualization", "1", {packages:
> ["annotatedtimeline"]});
> google.setOnLoadCallback(drawData);
> function drawData() {
> var data = new google.visualization.DataTable();
> data.addColumn('date', 'Date');
> data.addColumn('number', 'Repairs');
> <?php
> echo " data.addRows($rownum);\n";
> while($row = mysql_fetch_assoc($sql)) {
>
> $int_y_pos += $int_y_step_small;
>
> echo " data.setValue(" . $int_y_pos . ", 0, new Date(" .
> $row['date'] . "));\n";
> echo " data.setValue(" . $int_y_pos . ", 1," .
> $row['count'] . ");
> \n";
>
> }
> ?>
> var time = new
> google.visualization.AnnotatedTimeLine(document.getElementById('time_div'));
>
> time.draw(data, {displayExactValues:true});
>
> }
> </script>
> </head>
>
> <body>
> <div id="time_div" style="width: 940px; height: 240px;"></div>
> </body>
> </html>
>
> On Oct 17, 5:19 am, VizGuy <[email protected]> wrote:
> > In our examples there is no such an example, because they only web
> pages.
> > What you want to do, is to generate on your server, where you create the
> > dynamic html page, a javascript code which is similar to the pages we
> have
> > in our docs (for instance:
> http://code.google.com/apis/visualization/documentation/gallery/inten...
> > )
> >
> > Hope this helps.
> >
> > Vizguy
> >
> > On Thu, Oct 16, 2008 at 10:55 PM, Newbie
> > <[email protected]>wrote:
>
> >
> >
> >
> > > Can you point us to a specific example here ?
> > > Say, the data is in a flat file and we want to populate a data table.
> >
> > > Thanks.
> >
> > > On Oct 15, 3:45 pm, VizGuy <[email protected]> wrote:
> > > > Hi,
> > > > I am not sure I follow what is the exact question here.
> > > > Anyway - the main challenge is to create a data table from the MySql
> > > query
> > > > data.
> > > > The only way to do it today, is to generate the html page with the
> > > > javascript code that generates the data table object, and populates
> it
> > > with
> > > > cols, rows, and cells, and then using it as any data table.
> >
> > > > Please have a look at our docs athttp://
> > > code.google.com/apis/visualization
> >
> > > > VizGuy
> >
> > > > On Tue, Oct 14, 2008 at 3:30 PM, Jud <[email protected]> wrote:
> >
> > > > > Good morning -
> > > > > I just yesterday started digging in to this Google Visualization
> API,
> > > > > so needless to say, I'm not too fluent yet.
> >
> > > > > But, before I begin really learning I have a simple question that
> > > > > might kill it all.
> >
> > > > > What I am hoping to do with Google Visualization is to use an
> MySQL
> > > > > database to populate data to make the charts. For instance - the
> MySQL
> > > > > database has 10 fields, I will use an email of 10 most populated
> > > > > cities. So I have a row for 'cities' and I have a row for
> > > > > 'citypopulation'.
> >
> > > > > 1) Is that possible?
> >
> > > > > 2) HOW?
> >
> > > > > 3) Any other 'best practices' or 'ideas'?
> >
> > > > > Thanks!
>
--
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/groups/opt_out.
