FusionCharts Forum / FusionCharts v3 / Using FusionCharts / FusionCharts and PHP / Request for simple PHP/MySQL example / Latest Posts

RE: Request for simple PHP/MySQL example

Sudipto Choudhury — Thu, 10 Jan 2008 04:22:37 GMT

Hi,

try this:

//Before this insert your code to connect to database (MySQL) = $link
$strQuery = "SELECT COUNT(evt_time_generated) as Count, evt_computer FROM eventlog.log_alerts group by evt_computer";
$result = mysql_query($strQuery) or die(mysql_error());

//generating XML for Chart
$strXML = "<graph>";

if ($result) {
while($ors = mysql_fetch_array($result)) {
$strXML .= "<set name='" . $ors['evt_computer'] . "' value='" . $ors['Count'] . "' />";
}
mysql_close($link);

$strXML .= "</graph>";

//Create the chart
echo renderChart("Column3D.swf", "", $strXML, "ChartId", 650, 450, false, false);

Request for simple PHP/MySQL example

jimmydean25 — Wed, 09 Jan 2008 08:33:40 GMT

Hello,

I am having difficulties using my mysql/php database with your charts. I just need a very simple (no drill down) example so I can start somewhere. Your "Basic" PHP DB example does not seem that simple to me and I keep getting either blank datasets or mysql errors.

Can someone please generate a simple bar chart for the following query?

Query = SELECT COUNT(evt_time_generated) as Count, evt_computer FROM eventlog.log_alerts group by evt_computer;

This will get me a good starting point.

Thanks,