//// index.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<script src="//code.jquery.com/jquery-1.11.2.min.js"></script>
<script src="http://code.highcharts.com/highcharts.js"></script>
<script src="http://code.highcharts.com/modules/exporting.js"></script>
<div id="container" style="min-width: 310px; height: 400px; max-width: 600px; margin: 0 auto"></div>
<script>
$(function () {
//-------------------------------------------
jQuery.extend({
getValues: function(url) {
var result = null;
$.ajax({
url: url,
type: 'get',
dataType: 'json',
async: false,
success: function(data) {
alert(data);
result = data;
}
});
return result;
}
});
var myServerData = $.getValues("data.php"); //direct this to your PHP script and make sure that right JSON is returned
//--------------------------------------------
$('#container').highcharts({
//------------------------------------
chart: {
type: 'column'
},
title: {
text: 'Chanel share title'
},
subtitle: {
text: 'percent of channel share'
},
xAxis: {
type: 'category',
labels: {
rotation: -45,
align: 'right',
style: {
fontSize: '13px',
fontFamily: 'Verdana, sans-serif'
}
}
},
yAxis: {
min: 0,
title: {
text: 'Monthly share of channel'
}
},
legend: {
enabled: false
},
tooltip: {
pointFormat: 'Monthly income: <b>{point.y:.1f} USD</b>',
},
//---------------------------------------
series: [{
name: 'Monthly Income',
data: myServerData,
dataLabels: {
enabled: true,
rotation: -90,
color: '#FFFFFF',
align: 'right',
x: 4,
y: 10,
style: {
fontSize: '13px',
fontFamily: 'Verdana, sans-serif',
textShadow: '0 0 3px black'
}
}
}]
});
});
</script>
///////////////////////////////////////////////////////////////////////////////////////////////////
//// End index.php
///////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////
//// db.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<?php
///////////////////////////////////////////////////////////////////////////////////////////////////
//// Muna Database Function Library
///////////////////////////////////////////////////////////////////////////////////////////////////
//// Database Functions
///////////////////////////////////////////////////////////////////////////////////////////////////
////
//// Usage:
//// $db = new DB(); //instantiate using default read-only connection
//// $db = new DB($user,$pass); //instantiate using a specific login/pass
////
///////////////////////////////////////////////////////////////////////////////////////////////////
$showsql = true;
//$db = new DB();
class DB {
private $dbhost = "localhost";
private $dbuser = "root";
private $dbpass = "";
private $dbname = "charts";
public $error = "";
function __construct()
{
}
//---------------
//foreach ($customers as $customer) {
// $row[0]=$customer->cust_name;
// $row[1]=$customer->monthly_income;
// array_push($rows,$row);
//}
//print json_encode($rows, JSON_NUMERIC_CHECK);
//---------------
public function ReportError ($sql, $message) {
//echo "SQL ERROR:\nMessage: $message\nSQL: $sql\n";
$this->error = $message;
}
//highchart
public function GetChart ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
$rows = Array();
while ($res = mysql_fetch_object($result)) //will ignore anything that comes after
{
$row[0]=$res->year;
$row[1]=$res->amount;
//$row[1]=$channel->Date;
array_push($rows,$row); //array_push(array,value1,value2...)
}
mysql_close($con);
//print_r($rows);
print_r(json_encode($rows, JSON_NUMERIC_CHECK));
}
//delete by muna
public function deleteRow($sql) {
$con = mysql_connect($this->dbhost,$this->dbuser,$this->dbpass);
if (!$con) {
die("Could not connect to database!");
}
mysql_select_db($this->dbname, $con);
//mysql_select_db("esigns_prod", $con);
$result = mysql_query($sql, $con);
mysql_close($con);
return $result;
}
//returns a 1d list of results (using the first column returned)
public function GetList2 ($sql) {
$con = mysql_connect($this->dbhost,$this->dbuser,$this->dbpass);
if (!$con) {
die("Could not connect to database!");
}
//mysql_select_db("esigns_prod", $con);
$result = mysql_query($sql, $con);
while ($row = mysql_fetch_array($result)) {
$results[] = $row[0];
}
mysql_close($con);
return $results;
}
public function GetRow2 ($sql) {
$con = mysql_connect($this->dbhost,$this->dbuser,$this->dbpass);
if (!$con) {
die("Could not connect to database!");
}
//mysql_select_db($this->dbname, $con);
mysql_select_db("esigns_prod", $con);
$result = mysql_query($sql, $con);
//echo $sql;
//var_dump($result);
//echo mysql_error($con);
//mysql_close($con);
return mysql_fetch_assoc($result);
}
public function GetDB ()
{
$con = mysql_connect($this->dbhost,$this->dbuser,$this->dbpass);
if (!$con)
{
die("Could not connect to database!");
}
mysql_select_db($this->dbname, $con);
return $con;
}
public function Clean($sql)
{
return mysql_real_escape_string($sql, $this->GetDB());
}
public function Query ($sql)
{
$output=0;
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if (!isset($result))
{
return 0;
}
if (!$result) {return 0;}
if ($row = mysql_fetch_row($result))
{
$output = $row[0];
}
mysql_close($con);
return $output;
}
//returns the first two columns in an sql query as a keyed array
public function GetArray ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
while ($row = mysql_fetch_row($result))
{
//verify there are two rows of data, otherwise return an indexed list of the first
$output[$row[0]] = $row[1];
}
mysql_close($con);
return $output;
}
//returns the first column of each row returned
public function GetList ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
while ($row = mysql_fetch_row($result))
{
array_push($output, $row[0]);
}
mysql_close($con);
return $output;
}
public function GetResult ($sql)
{
$con = $this->GetDB();
if (!$con) {return 0;}
$result = mysql_query($sql, $con);
//mysql_close($con);
return $result;
}
public function GetJSON ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
while ($row = mysql_fetch_row($result)) //will ignore anything that comes after
{
$data = Array();
for ($i=0; $i<mysql_num_fields($result); $i++) {
$data[mysql_fetch_field($result, $i)->name] = $row[$i];
}
array_push($output, $data);
}
mysql_close($con);
return json_encode($output);
}
public function GetTable ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
while ($row = mysql_fetch_row($result)) //will ignore anything that comes after
{
$data = Array();
for ($i=0; $i<mysql_num_fields($result); $i++) {
$data[mysql_fetch_field($result, $i)->name] = $row[$i];
}
array_push($output, $data);
}
mysql_close($con);
return $output;
}
public function InsertSql ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result) {$output= 1;}
else $output= 0;
mysql_close($con);
return $output;
}
public function GetRow ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
if ($row = mysql_fetch_row($result)) //will ignore anything that comes after
{
$output = $row;
}
mysql_close($con);
return $output;
}
public function GetRowObject ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
if ($row = mysql_fetch_assoc($result)) //will ignore anything that comes after
{
$output = $row;
}
mysql_close($con);
return $output;
}
public function GetRows ($sql)
{
$output = Array();
$con = $this->GetDB();
if (!$con) {return -1;}
$result = mysql_query($sql, $con);
if ($result == 0) {return 0;}
while ($row = mysql_fetch_row($result)) //will ignore anything that comes after
{
array_push($output, $row);
}
mysql_close($con);
return $output;
}
public function Command ($sql)
{
global $showsql;
$this->error = "";
//if ($showsql) {echo "SQL: $sql\n";}
$con = $this->GetDB();
if (!$con) {return 0;}
$result = mysql_query($sql, $con);
$rows = mysql_affected_rows($con);
if ($rows < 1)
{
$this->error = mysql_error($con);
//$this->ReportError($sql, mysql_error($con));
//echo "DB ERROR: " . mysql_error($con) . "\n";
}
mysql_close($con);
return $rows;
}
}
?>
//// End db.php
///////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////
//// data.php
///////////////////////////////////////////////////////////////////////////////////////////////////
<?php
include("db.php");
$dbObj=new DB;
$selSql="select * from turnover";
$results=$dbObj->GetChart($selSql);
?>
///////////////////////////////////////////////////////////////////////////////////////////////////
//// End data.php
///////////////////////////////////////////////////////////////////////////////////////////////////
