Mudahnya Setting Koneksi PHP dengan Oracle menggunakan WAMP server

Mudahnya Setting Koneksi PHP Oracle dengan WAMP server.

Setelah installasi oracle berhasil, Untuk setting koneksi PHP ke Oracle, kita install dulu wampserver yang softwarenya dapat kita download secara gratis di website resminya [DISINI]. Setelah selesai proses  installasinya kita jalankan wampservernya  ->  klik icon wampserver -> arahkan ke php -> PHP extensions -> aktifkan php_oci8.

Hasilnya dapat dilihat di phpinfo()

Kita coba dengan script php. Buat file php baru yang isinya seperti dibawah ini.

<?php

$sid = "orcl";  

$user = "scott";

$pass = "tiger";

$con = ocilogon($user,$pass,$sid);

if($con)

echo "Koneksi PHP ORACLE Berhasil";

else

echo "Koneksi PHP ORACLE Gagal";

?>

Simpan dengan nama cobaKoneksi.php dan letakkan di folder c:\wamp\www.

Jalankan dengan browser, ketikan http://localhost/cobaKoneksi.php jika berhasil maka akan muncul “Koneksi PHP ORACLE Berhasil” dan jika gagal akan muncul “Koneksi PHP ORACLE Gagal”. Jika ada masalah silahkan membuat komen di bawah ini.

Read More

Setting up Exporting Module on Highchart using Apache’s Batik converter

EXPORTING MODULE

From version 2.3.5  an exporting module is available for Highcharts, which allows users to download images or PDF's of your charts. This module consists of an extra JavaScript file, exporting.js, and a web service or server module written in PHP. Highslide Software offers the exporting web service free of charge. If you include the exporting module in your charts, two buttons will appear in the upper right. One button prints the chart, which is done on the client side only. The other button handles exporting. By default, an SVG representation of the chart is sent by POST to http://export.highcharts.com, where it is converted using Apache's Batik converter to PDF, PNG or JPEG.

See the navigation and exporting reference items for a full documentation for the options available. Also see under "Methods and Properties" in the reference for members releated to exporting.

6.1 Client side setup

Add the exporting module JavaScript file after your highcharts.js file.

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" type="text/javascript"></script>
<script src="/js/highcharts.js" type="text/javascript"></script>
<script src="/js/modules/exporting.js" type="text/javascript"></script>

6.2 Server module setup

If you want to set up this web service on your own server, the index.php file that handles the POST is supplied in the download package inside the/exporting-server directory.

1. Make sure that PHP and Java is installed on your server.
2. Upload the index.php file from the /exporting-server directory in the download package to your server.
3. In your FTP program, create directory called temp in the same directory as index.php and chmod this new directory to 777 (Linux/Unix servers only).
4. Download Batik from http://xmlgraphics.apache.org/batik/#download. Find the binary distribution for your version of jre
5. Upload batik-rasterizer.jar and the entire lib directory to a location on your web server.
6. In the options in the top of the index.php file, set the path to batik-rasterier.jar.
7. In your chart options, set the exporting.url option to match your PHP file location.

As an ASP.NET alternative to our Java/PHP based server module, Clément Agarini has kindly shared his export module for ASP.NET.

Source : http://docs.highcharts.com/

Read More