PHP BarSeries Examples

Example #1

File: stackedchart_3.php Project: vintots/smart_k12

    $sitio_male[] = mysql_num_rows($r4);
    $sql5 = "SELECT * from population where sitio ='{$b}' and gender='Female' and classification='{$classification} '";
    $r5 = mysql_query($sql5) or die(mysql_error());
    $sitio_female[] = mysql_num_rows($r5);
}
$chart->PlotArea->YAxis->Title = "Population";
$chart->PlotArea->YAxis->LabelsAppearance->DataFormatString = "{0}";
$series = new BarSeries();
$series->Stacked = TRUE;
$series->Name = "Male";
$series->TooltipsAppearance->DataFormatString = " There is {0} Male Weighing OPT(s) on {1}";
for ($x = 1; $x <= $total_sitio; $x++) {
    $series->ArrayData(array($sitio_male[$x - 1]));
}
$chart->PlotArea->AddSeries($series);
$series = new BarSeries();
$series->Stacked = TRUE;
$series->Name = "Female";
$series->TooltipsAppearance->DataFormatString = " There is {0} Female Weighing OPT(s) on {1}";
for ($x = 1; $x <= $total_sitio; $x++) {
    $series->ArrayData(array($sitio_female[$x - 1]));
}
$chart->PlotArea->AddSeries($series);
echo $chart->Render();
$sql2 = "SELECT * from population where classification='{$classification} '";
$r2 = mysql_query($sql2) or die(mysql_error());
$total_population = mysql_num_rows($r2);
echo "<b style='color:#444'>Total Population of {$classification} is : {$total_population}</b>";
?>

</div>

Example #2

File: example.php Project: skydel/universal-online-exam

$chart->Height = 450;
$chart->Width = 500;
$chart->Title->Text = "Bar Chart with negative values";
$chart->Legend->Appearance->Visible = false;
$chart->PlotArea->XAxis->Title = "";
$chart->PlotArea->XAxis->MajorTickSize = 2;
$chart->PlotArea->YAxis->Title = "";
$chart->PlotArea->YAxis->MaxValue = 50;
$chart->PlotArea->YAxis->MinValue = -30;
$chart->PlotArea->YAxis->MajorStep = 10;
$chart->PlotArea->YAxis->MinorStep = 2;
$series = new BarSeries();
$series->Appearance->BackgroundColor = "#399C48";
$series->ArrayData(array(25, -12, 39));
$chart->PlotArea->AddSeries($series);
$series = new BarSeries();
$series->Appearance->BackgroundColor = "#28A1DA";
$series->ArrayData(array(-15, 38, -11));
$chart->PlotArea->AddSeries($series);
$chart_scatter = new KoolChart("chart_scatter");
$chart_scatter->scriptFolder = $KoolControlsFolder . "/KoolChart";
$chart_scatter->Title->Text = "ScatterLine with negative values";
$chart_scatter->Width = 500;
$chart_scatter->Legend->Appearance->Visible = false;
$chart_scatter->PlotArea->XAxis->Title = "";
$chart_scatter->PlotArea->XAxis->MaxValue = 100;
$chart_scatter->PlotArea->XAxis->MinValue = -60;
$chart_scatter->PlotArea->XAxis->MajorStep = 20;
$chart_scatter->PlotArea->XAxis->MinorStep = 4;
$chart_scatter->PlotArea->YAxis->Title = "";
$chart_scatter->PlotArea->YAxis->MaxValue = 60;

Example #3

File: total_opts_graph.php Project: vintots/smart_k12

$chart->PlotArea->YAxis->Title = "Graph for total Population";
$chart->PlotArea->YAxis->LabelsAppearance->DataFormatString = " {0}";
$series = new BarSeries();
$series->Name = "Male";
$series->TooltipsAppearance->DataFormatString = " {0} Male population(s)";
for ($x = 1; $x <= $total_sitio; $x++) {
    $series->ArrayData(array($sitio_male[$x - 1]));
}
$series->ArrayData(array($total_male));
$chart->PlotArea->AddSeries($series);
$series = new BarSeries();
$series->Name = "Female";
$series->TooltipsAppearance->DataFormatString = " {0} Female population(s)";
for ($x = 1; $x <= $total_sitio; $x++) {
    $series->ArrayData(array($sitio_female[$x - 1]));
}
$series->ArrayData(array($total_female));
$chart->PlotArea->AddSeries($series);
$series = new BarSeries();
$series->Name = "Total";
$series->TooltipsAppearance->DataFormatString = " {0} population(s)";
for ($x = 1; $x <= $total_sitio; $x++) {
    $series->ArrayData(array($sitio_population[$x - 1]));
}
$series->ArrayData(array($total_population));
$chart->PlotArea->AddSeries($series);
echo $chart->Render();
?>
</div>
</body>
</html>

Example #4

File: gradeCount.php Project: skydel/universal-online-exam

 inner join major on (class.major_id = major.major_id)
 inner join department on (major.dept_id = department.dept_id)'
.'where score.s_score >= '.$_GET['min'].'and score.s_score <='.$_GET['max'].
 'group by department.dept_name';
 * */
$query = 'select department.dept_name as name,count(*) as count from
 student inner join class on (student.class_id = class.class_id)
 inner join major on (class.major_id = major.major_id)
 inner join department on (major.dept_id = department.dept_id)' . 'where student.s_score_1 >= ' . $_GET['min'] . 'and student.s_score_1 <=' . $_GET['max'] . 'group by department.dept_name';
if ($stmt = $db->prepare($query)) {
    $stmt->execute();
    $dept = $stmt->fetchAll(PDO::FETCH_NUM | PDO::FETCH_COLUMN, 0);
    $count = $stmt->fetchAll(PDO::FETCH_NUM | PDO::FETCH_COLUMN, 1);
    var_dump($dept);
    var_dump($count);
    $chart = new KoolChart("chart");
    $chart->scriptFolder = $KoolControlsFolder . "/KoolChart";
    $chart->Title->Text = "成绩统计";
    $chart->Width = 680;
    $chart->Height = 480;
    $chart->Legend->Appearance->Position = "top";
    $chart->PlotArea->XAxis->Title = "Quarters";
    $chart->PlotArea->XAxis->Set($dept);
    $chart->PlotArea->YAxis->Title = "Sales (millions)";
    $chart->PlotArea->YAxis->LabelsAppearance->DataFormatString = "\$ {0}";
    $series = new BarSeries();
    $series->Name = $_GET['min'] . "-" . $_GET['max'];
    $series->TooltipsAppearance->DataFormatString = "\$ {0} 人";
    $series->ArrayData($count);
    $chart->PlotArea->AddSeries($series);
}

Example #5

File: example.php Project: skydel/universal-online-exam

$result = mysql_query("select productName, priceEach*quantityOrdered as spent from customers,orders,orderdetails,products where customers.customerNumber=orders.customerNumber and orders.orderNumber=orderdetails.orderNumber and orderdetails.productCode=products.productCode and customers.customerNumber={$customerNumber} group by products.productCode limit 9");
while ($row = mysql_fetch_assoc($result)) {
    array_push($_axis_items, $row["productName"]);
    array_push($_series_items, round($row["spent"]));
}
if (count($_series_items) > 0) {
    $chart = new KoolChart("chart");
    $chart->scriptFolder = $KoolControlsFolder . "/KoolChart";
    $chart->Padding = 30;
    $chart->Height = 360;
    $chart->Width = 800;
    $chart->Legend->Appearance->Visible = false;
    $chart->Title->Text = "Money spent per product";
    $chart->PlotArea->XAxis->Set($_axis_items);
    $chart->PlotArea->YAxis->LabelsAppearance->DataFormatString = "\$ {0}";
    $series = new BarSeries("");
    $series->Appearance->BackgroundColor = "#B94003";
    $series->LabelsAppearance->DataFormatString = "\$ {0}";
    $series->TooltipsAppearance->DataFormatString = "\$ {0}";
    $series->ArrayData($_series_items);
    $chart->PlotArea->AddSeries($series);
}
?>

<form id="form1" method="post">
	<?php 
echo $koolajax->Render();
?>
	
	<div style="padding-top:35px;float:left;">
		<script type="text/javascript">

Example #6

File: example.php Project: skydel/universal-online-exam

$chart->Legend->Appearance->Position = "top";
$chart->PlotArea->XAxis->Title = "Quarters";
$chart->PlotArea->XAxis->Set(array("Q1", "Q2", "Q3", "Q4"));
$chart->PlotArea->YAxis->Title = "Sales (millions)";
$chart->PlotArea->YAxis->LabelsAppearance->DataFormatString = "\$ {0}";
$series = new BarSeries();
$series->Name = "TVs";
$series->TooltipsAppearance->DataFormatString = "\$ {0} millions";
$series->ArrayData(array(20, 30, 40, 70));
$chart->PlotArea->AddSeries($series);
$series = new BarSeries();
$series->Name = "Computers";
$series->TooltipsAppearance->DataFormatString = "\$ {0} millions";
$series->ArrayData(array(34, 55, 10, 40));
$chart->PlotArea->AddSeries($series);
$series = new BarSeries();
$series->Name = "Tablets & e-readers";
$series->TooltipsAppearance->DataFormatString = "\$ {0} millions";
$series->ArrayData(array(56, 23, 56, 80));
$chart->PlotArea->AddSeries($series);
?>

<form id="form1" method="post">

	<?php 
echo $chart->Render();
?>
					
	
	<div><i>* <u>Note</u>:</i>Generate your own chart with <a style="color:#B8305E;" target="_blank" href="http://codegen.koolphp.net/generate_koolchart.php">Code Generator</a></div>