Sign in to follow this  
juniordev

Php Sql Server Graph!?

Recommended Posts

Hi i am basically trying to create a simple line graph by gathering data from SQL server, the data itself which i would like to show is, CPU Load percentage which allows me to view over a day what the CPU usage has been like in my webpage. I am using php on wamp server. and i really do not know what i am doing wrong, new to php,new to html, new to most! so would love some help from you veterans!! Really appreciate it.

 

Basically what i am trying to achieve is when you go to task manager, the performance tab shows a CPU line graph, that is all i want! in the most simplest way! In my database i have data for LoadPercentage as you can see below which at the moment is not under any time frame, i am just using any data to have a graph working at first if you know what i mean.

 

CHEERS GUYS

(note i did not include connection inc.php) i think the coding is right but you guys will tell me wrong right!

 

 

 

 

<?php

 

include("\FusionCharts\FusionCharts_PHP\App\Includes\FusionCharts.php");

 

?>

 

<HTML>

<HEAD>

<TITLE>FusionCharts Free - Database Example</TITLE>

<script LANGUAGE="Javascript" SRC="./FusionCharts/Charts/FusionCharts.js"></SCRIPT>

</HEAD>

<BODY>

<CENTER>

<?php

//In this example, we show how to connect FusionCharts to a database.

//For the sake of ease, we've used a MySQL database containing two

//tables.

 

//Connect to the DB

$serverName = "CWIHQLA3FF813J\SQLEXPRESS";

$connectionOptions = array("Database" => "PerfMon");

$conn = sqlsrv_connect( $serverName, $connectionOptions) or die ("<p>Problem on connecting to database</p>");

 

//$strXML will be used to store the entire XML document generated

//Generate the graph element

$strXML = "<graph caption='Factory Output report' subCaption='By Quantity' decimalPrecision='0' showNames='1' numberSuffix=' Units' pieSliceDepth='30' formatNumberScale='0'>";

 

//Fetch all factory records

$queryString = "SELECT TOP 100 LoadPercentage FROM [PerfMon].[dbo].[CPUUsage]";

$result = sqlsrv_query($conn, $queryString) or die ("Problem in executing query");

 

//Iterate through each factory

if ($result) {

while($ors = sqlsrv_fetch_array($result)) {

//Generate <set name='..' value='..'/>

$strXML .= "<set name='CPU Usage' value='" . $ors['LoadPercentage'] . "' />";

 

}

}

sqlsrv_close($conn);

 

//Finally, close <graph> element

$strXML .= "</graph>";

 

//Create the chart - Pie 3D Chart with data from $strXML

echo renderChart("\FusionCharts\Charts\Line.swf", "", $strXML, "LoadPercentage", 650, 450, "", "");

?>

</BODY>

</HTML>

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this