$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> </body> </html>
$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; $chart_scatter->PlotArea->YAxis->MinValue = -60; $chart_scatter->PlotArea->YAxis->MajorStep = 10;
$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>
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); }
} 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"> function Handle_OnRowSelect(sender,args) { var _row = args["Row"]; chart_panel.attachData("customerNumber",_row.getDataItem()["customerNumber"]);
$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> </form>