Php+oracle

Any advice would be fine please

[AndreJul]

I am planning to build a large scale information system on payroll in my company using oracle, why do i choose oracle?
1.because we are planning to integrate it with SAP applications (it uses oracle database as back end).
2.because like i said, i am going to make a large scale system which means that I must use database with excellent traits, especially in storage and performance

Any of you guys who have any experience in PHP + Oracle please reply and give me some advice, because, frankly speaking, I am still a newbie in PHP oracle integration

[fintan]

Hi AndreJul, all I'd say is make sure you have the oci client libraries installed and your tns_names setup properly. Also if your messing around with dates this sql might come in handy.

ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

Just change it to your date format. Also the adodb library comes in handy. Besides that it's fairly bog standard stuff. Happy scripting!

fintan.

[jatar_k]

I have worked with php & oracle

what specifically were you looking for?

you also might want to look at this
[zend.com...]

[AndreJul]

I was searching for two stuffs for now:
1. How to process queries like CREATE USER, because when i tried to use the same method as the way i used to process INSERT,SELECT(Such as oci_parse or oci_exec), it didn't work. Do I have to make use of stored_procedure?

2. How can I limit the search result like the way I use LIMIT on MySQL, cause, a friend of mine told me that if I tried to retrieve large amount of data from database directly, it would cause bottleneck to the bandwidth.

Thanks In Advance.

Regards

AndreJul