RE: Simple PHP+MySQL charts

b471code3 — Mon, 25 Jun 2007 09:14:04 GMT

Here are a sample of code I have written to get my charts to populate.

This is a simple 2D pie chart with v3 charts. There are two seperate files, one is a data file and the other displays the chart and other html items on the viewable page. What this code is from is the data file. Hope it helps you out.

[code]

<?php

session_start(); // used to start a session for security reasons

include ('login.php'); // security files

include ('names.php'); //misc files

include './includes/Connection_'.$conn.'.php'; // connection file with functions

include './includes/chart_colors.php';

// get the variables posted in the page form; prepend 'r_' to them

import_request_variables("gp", "r_");

$date = date("m/d/y");

// get the customer data

// query the MySQL database
$query = "SELECT SUM((qty_ord - qty_ship) * line_price) as sales, reason_code, reason_group,
reason_name FROM sales_late_orders WHERE closed = 'no' GROUP BY reason_group, reason_name";

// result of the query
$result = db_query($query, $DBLink) or die ('Error: Cannot get Data!');

// generate the XML for the chart

$strXML = "<graph caption='Late Orders by Reason ".$date."' useRoundEdges='1' chartLeftMargin='0'
chartRightMargin='5' chartTopMargin='0' chartBottomMargin='0' decimalPrecision='0'
showPercentageValues='0' showNames='1' rotateNames='1' numberPrefix='".$symbol."'
showPercentageInLabel='0' canvasBgColor='FFFFFF,".$_GET["daColor"]."' canvasBgAngle='270'
canvasBgAlpha='90' bgColor='".$strColor[10]."' showAlternateHGridColor='0' showBorder='0'
baseFontSize='12' baseFontColor='".$strColor[8]."'>";

// connection settings for other servers
if ($hostname == "192.168.5.50") {
switch ($cCo) {

case "csgc":

$file = "csgc/";

break;

case "ucl":

$file = "csgw/";

break;

}

// as long as there is a result in the row (function called out in the connection file) it will keep doing the loop

while ($row = db_fetch_assoc($result)){

// append the data

if ($row["reason_code"] == 0){

$reason = "Unassigned";

}

else {

if ($row["reason_group"] == $row["reason_name"]) {

$reason = $row["reason_group"];

}

else {

$reason = $row["reason_group"]." - ".$row["reason_name"];

}

$htmlLink = "[url]http://".$hostname."/cgi-bin/wspd_cgi.sh/WService=ws".$broker."/dash/".$file."reason1.html?cReason=".$row["reason_code"][/url];

$strXML = $strXML."<set value='".$row["sales"]."' name='".$reason."' link='".$htmlLink."' />"; }

// close tags

// concatenate to form the whole XML document

$strXML = $strXML;

$strXML = $strXML."</graph>";

// output the data

echo($strXML);

[/code]

RE: Simple PHP+MySQL charts

Pallav — Tue, 06 Feb 2007 12:52:32 GMT

You can see the Array or Form examples. Those are simple examples.

I'm afraid we do NOT have anything simpler than that.

RE: Simple PHP+MySQL charts

CJL999 — Mon, 05 Feb 2007 11:15:20 GMT

That's why I ask for more simple examples the existed on document is too complicated for me :crying: PLEASE show me some SIMPLE-1-table database chart plotting.:D

RE: Simple PHP+MySQL charts

Pallav — Mon, 05 Feb 2007 06:37:07 GMT

You may please see http://www.fusioncharts.com/FusionCharts/Docs > Guide for Web Developers > FusionCharts and PHP. We've lot of simple and easy-to-grasp examples with documentation.

Simple PHP+MySQL charts

CJL999 — Sun, 04 Feb 2007 12:13:40 GMT

Hi there, I'm new using FusionCharts with mysql database. I've seen an example on the document but I still confuse fetching data from mysql to the chart. Can anyone give me some basic database example using php+mysql? I just want to learn how to plot a simple pie chart or bar chart with couple of data.

best regards.;)

FusionCharts Forum / FusionCharts v3 / Using FusionCharts / FusionCharts and PHP / Simple PHP+MySQL charts / Latest Posts

RE: Simple PHP+MySQL charts

RE: Simple PHP+MySQL charts

RE: Simple PHP+MySQL charts

RE: Simple PHP+MySQL charts

Simple PHP+MySQL charts