[trick] Membuat Aplikasi Sederhana Dengan PHP dan ORACLE Bag-3

Bismillah…

sekarang membuat grafik dengan php dan ORACLE y >>

Ok langsung saja, siapkan databases >>

data_oci

masuk ke kodingnya >>


<?php
$c=oci_connect("root","12345","XE");

include"FusionCharts/FC_Colors.php";
include"FusionCharts/FusionCharts_Gen.php";
include"FusionCharts/FusionCharts.php";

echo"<div><SCRIPT LANGUAGE='Javascript' SRC='FusionCharts/FusionCharts.js'></SCRIPT>";

$FC = new FusionCharts("Column3D","500","300");
$FC->setSWFPath("FusionCharts/");

$strParam="caption=Grafik Penjualan ; subcaption=PerTahun; xAxisName=Produk & tahun ; yAxisName=Jumlah; numberPrefix=; decimalPrecision=0";

$FC->setChartParams($strParam);
$query="select * from grafik";
$statmen=oci_parse($c,$query);
oci_execute($statmen,OCI_DEFAULT);

while($data=oci_fetch_array($statmen,OCI_BOTH)){
$FC->addChartData("$data[JUMLAH]","name=$data[NAMA]");
}

$FC->renderChart();

echo"</div>";

?>



 

dan hasilnya >>

hasil_oci

ok selesai..

source code >> http://www.4shared.com/rar/gz0QSNhl/oracle.html

Leave a comment

1 Comment

  1. mangtaps uda, udah gw coba, haa… keren, terus uda yang oracle aja, gw tunggu…

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: