koneksi.php

Connect(false,$user,$password,$login) or die('Koneksi database gagal ......');

?>

awal adodb

sharing konsep adodb(php-oracle) permulaan.
konsep adodb... sama belum lama kenal juga,, selidik2 konsep adodb > konsep php - oracle yang digandrungi untuk client side selain oci.
terserah pake yang mana. Untuk oci banyak referensinya, bisa tanya ke mbah googling.
tapi untuk adodb g sebanyak oci.

sebelum buat koneksi awal. qt setting dulu yoo
- tnsname.ora perlu dibuat, sesuein dengan database server (protokol, host ip, port, + SID)
.....................................................................................
ORC_LOCALHOST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orc)
(SERVER = DEDICATED)
)
)
.....................................................................................

- php/php.ini
- uncomment ;extension=php_oracle.dll jadi extension=php_oracle.dll
;extension=php_oci8.dll jadi extension=php_oci8.dll

- testing database : controlpanel/administrative tools/data source(ODBC) >tab system
DSN(kalo udah ada) > configure > isi username, password > Test Connection


;) sharing sedikit aja

error php..

misal ada masalah "ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries "

download php_oci8.dll php-5.2.1 (5_2) di http://pecl4win.php.net/ext.php/php_oci8.dll copy ke c:\php\ext
ubah extension_dir to c:\php\ext, ganti cgi.force_redirect = 0, ilangin komen extension=php_oci8.dll

seip