cakephp with oracle 9i

Untuk dapat berkomunikasi dengan oracle maka dibutuhkan oracle instant client, versi dari oracle instant client ini disesuaikan dengan versi dari oracle dan jenis operating systemnya.

lakukan instruksi instalasi dari oracle instant client tersebut antara lain sebagai berikut :

1. unpack package yang telah didownload.

2. setting environment variable PATH(refered to unpack package).

3. configure php.ini file untuk aktivasi php_oci8 dengan cara menghilangkan karakter “;” pada : extension=php_oracle.dll
extension=php_oci8.dll

4. restart server apache.

jika terdapat error message, copy file “oci.dll” ke WINDOWS/system32/

untuk configurasi cakephp dapat dilakukan pada file “config/database.php”

buat variable koneksi, contoh :

var $default = array(
‘driver’ => ‘oracle’,
‘connect’ => ‘oci_connect’,
‘persistent’ => false,
‘host’ => ‘oracleHost’,
‘login’ => ‘username’,
‘password’ => ‘password’,
‘database’ => ‘oralceHost:1521/schemaName’,
‘prefix’ => ”,
);

Selamat mencoba….. :)

running sql file for oracle

use an sql plus from commend prompt :
=> open your directory for file .sql
=> type sqlplus
=> type username
=> type password
=> oracle will send a message connection
=> type @FileName.sql

this is done now…..

Deleted windows services

sometime we don’t need any service, and we need to deleted it. we just need to stop the service first and we go to the edited registry(run->regedit). and search the name of service who we want to deleted locate at :

HKEY_LOCAL_MECHINE -> SYSTEM -> CurrentControlSet -> Services

change file root with application ubuntu

gksu + comment_application

this is for change user accsess for an application. ubuntu default for an application is an account, if you want to edit/delete file root with an application you must type that.

sample i want to edit an file in /var/www with netbeans 6.5
alt+f2 and than you go to System->Main Menu->Programming->netbeans and click Properties button.
copy from Command field.

and type :
gksu bin/sh “/home/dian/netbeans-6.5m1/bin/netbeans”

and run…..ok gluck guys….

query update field table mysql

Dari pada lupa mending di catet….

UPDATE member SET member.status = ‘ganteng’ WHERE member.username = ‘dianpurnomo’;

desc : ubah status dari member yang usernamenya ‘dianpurnomo’ menjadi ‘ganteng’. (narsis ttp :D )

*NB : member = nama table, status = nama field yg akan diubah, dan username adalah nama field yg dipake buat syarat.

« Entri lama