PHP :: Oracle 10g, And IIS 6

PHP & Oracle
I just got a VM box. 2.6.9-22.ELsmp, Oracle 10gr2_client
This works: # sqlplus user/pw@machine connects right up.

But this doesn't:
putenv ("ORACLE_PATH=/opt/oracle/10gr2_client/bin");
putenv ("ORACLE_HOME=/opt/oracle/10gr2_client");
putenv ("PATH=$PATH;/opt/oracle/10gr2_client/bin");

$conn = ora_logon ("user@machine", "passwd");
$cur = ora_open($conn);

Gives: PHP Fatal error: Call to undefined function: ora_logon() in
/var/www/html/tst.php I've been searching the web - nothing, well
nothing that fits my case. On the old machine oci8 was in /etc/php.ini.

phpinfo says oci8 is supported. /etc/php.d doesn't have a oci8.ini and
web searching doesn't return anything (that exists). So what am I
missing? doing wrong?

View Replies !

Use Of Oracle With PHP
Just a query about the use of Oracle with PHP. I see PHP has a list of functions built in to deal with Oracle and I was wondering if anybody out there had used this combination of technologies and what their experience with them was?

Obviously MySQL and PHP work together well, but as we all know if you get up to 300 concurrent users (which is a hell of a lot) you need something a little stronger. Options I see are Oracle and Sybase (MS is never an option for me, no matter what ).

View Replies !

Oracle With Php
this is not working Code:

$test=཈-03-2007'
insert into DBtest(startdate,customerid) values('TO_DATE('$test','DD-MM-YYYY'),123); i need to insert to this data to oracle database.

View Replies !

Oracle TAF And Php
Just wondering if anyone has got Transparent Application Failover to
work with PHP. I've compiled the php using --with-oci8-instant-client
and the TNS_NAMES environment variable is has been set to the path of
my tnsnames.ora. I've also installed sqlplus.

This works as I am able to connect using names given in the
tnsnames.ora file.

Using sqlplus I connect and do a
SELECT host_name from v$instance;
this returns
node1

i then shutdown the database on node 1 from a remote host and execute
the query the result is now
node2

I'm also able to shutdown the dbmid query and the correct result is
returned.

This is all handled by OCI8

When i try to replicate this in php I get an end of communication
channel which is correct really, but Oracle TAF should handle this for
me.

As it does in SQL plus is this correct ?

View Replies !

Oracle
I have SuSE 9.1, Apache2 and PHP installed. I want to use it against an
existing Oracle database on the same server, but when SuSE installs PHP, it
is only with mysql support.

I am reading that I need to recomplile PHP with "--with-oci8" option. SuSE
does not have the PHP source on their website, just the binaries. Does this
mean that I have to wipe clean my PHP and Apache install, download the
source, and recompile it?

I am not an advanced Linux user so this sounds daunting to me. Is there
another way around it? I was reading that I might just be able to put a
line for Oracle similar to "extension=mysql.so" in my /etc/php.ini file. Of
course I would need the Oracle .so from somewhere.

View Replies !

PHP & Oracle DB
I'm an italian programmer and i have a very big problem: i must connect to Oracle DB. The error log is:

Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory in /var/www/phpnuke/html/modules/FAQ/index.php on line 266 Code:

View Replies !

PHP 5.2.4 With Oracle 10g.
I installed PHP 5.2.4, Apache 2.2 and Oracle XE 10g today. I've set it up, and PHP is working fine on my server. However i'm having a bit of trouble with Oracle. I've pointed php.ini to the correct ext directory, and i've 'uncommented' the line "extension = php_oci8.dll". Code:

View Replies !

& Oracle
mysql_connect goes as oci_connect while connecting to Oracle. Do the rest of the functions hold the same naming format? Code:

View Replies !

Oracle
i want to implememt private area(authorized users)in the internet main
page. Our Backend Database Server running Oracle 9i on AIX

I am looking for a solution to pull up live data form Backend Database
Server to the web server.

What would be best approach for connecting to the Oracle Database?
would php a good integration tools to retrieve data in flexible and
secure way?

I would appreciate any help in this case such as tips/links/docs
success story... etc. what about MySQL do I need it to place in between php and oracle ?

View Replies !

PHP 5.1.1 And Oracle 10
I can't connect to it using PHP and get the following:

Warning: ociplogon() [function.ociplogon]: _oci_open_server: Error while
trying to retrieve text for error ORA-12170

Sqlplus and Tnsping work fine.

View Replies !

How To Connect To Oracle?
Ok so I config PHP with:

./configure --prefix=/usr/orion/php/php --with-mysql --with-apxs=/usr/orion/php/apache/bin/apxs --with-oci8=/d0/app/oracle/product/8.1.6 --with-oracle=/d0/app/oracle/product/8.1.6

However in my httpd.conf I do not have a place to change my SID (instance) or ORACLE HOME

Anyone know why and maybe post the lines to add that to httpd.conf

View Replies !

Help!!! Oracle Database
i'm very new in using php with oracle database. Right now, I'm using the php with oracle database to do my assignment. After i install oracle into my local PC, may i know what type of changes in oracle database that i need to do in in order to make my php script runable with oracle database? Also, i always see that many people using username and password when logon to the database (eg $connection=OCILogon("username", "password"). may i know where i can refer to this identifier? thanks for your help.

View Replies !

PHP/Oracle Reference
Does anyone have a good ressource (example code) using php with oracle 8?

View Replies !

Compiliing PHP For Oracle
I'm trying to get PHP 4.2.2 connected to Oracle 8.1.7 in Linux RedHat 9. I had the apache server alredy installed, so I installed Oracle supposing that the apache was ready to handle oracle.

When I try the aplication it gives me an error saying that it don't have the osilogon() function. So I start to read in PHP.net.
I learnt that the osilogon() is part of the Oracle Call Interface (OCI8) and that I need to recompile apache with the --with-oci8 option (I've checked with phpinfo() and it says that php is running without-oci8.

I've tried this in the phpxxx directory as root:

./configure --with-oci8
make
make install

I had several warnings in the ./configure phase and then i get this errors in the make phase:

View Replies !

PHP Oracle Tutorials?
Anyone know of some good PHP / Oracle tutorials and or books? I am very familiar with PHP / MySQL but I have been pushed into oracle at work so I need to brush up a bit.

View Replies !

Connectivity To Oracle
Can anyone suggest me what configurations should be done to connect Oracle with PHP4.0b?

View Replies !

OCI8 On PHP With Oracle 9i
I have been developing some applications on suse 9 / apache 1.37 / php
4.3.4 / Oracle 9i / OCI8. We recently moved servers, apache works
fine, php works fine, oracle works fine... however, trying to connect
to oracle from php it dies with the following error :

Warning: ocilogon(): _oci_open_session: OCIHandleAlloc
OCI_HTYPE_SVCCTX: OCI_INVALID_HANDLE

Using SQL plus I can connect just fine. The variables are all set in
apache and the connection string... the permissions on the oracle
folder are all correct.

View Replies !

Apache Php And Oracle
I am trying to get php to work with oracle and apache.

when I execute a script with ph that connects to an oracle database it
seems to work.

php without "oracle stuff" in apache seems to work.

However when I try the script that connects to the database via the web
I get messages like:
OCISessionBegin: ORA-03106: fatal two-task communication protocol error in

any ideas ? (does php not see the ORACLE_HOME and ORACLE_BIN
environment variables ?)

View Replies !

QB 2006 Oracle DB
Is anyone or has anyone been able to connect to the Oracle DB in Quickbooks
2006? Just looking for a little direction and or example here. My
undertsanding is Intuit offers an SDK but that only allows read-only access
to the database (? )

View Replies !

SmartyPaginate And Oracle
Has anyone used those two together that can give me a quick script on
how it was done?

View Replies !

Installing Php With Oracle
I'm having a problem making php with oracle. I downloaded all the
needed modules and unzipped them to the specified folder. I configure
php with amongst others: --with-oci8=[dir] The header files (such as
oci.h) are in the installation directory. I come with an error:
OCI_NLS_CHARSET_ID undeclared used in oci8.c 2181. It tries to create
oci8.lo.

View Replies !

Oracle->not Same Result From Php And From Sql*plus
Here is my query, ran from oracle sql*plus:

SELECT mrbs_room.id, start_time, end_time, name, mrbs_entry.id, type
FROM mrbs_entry, mrbs_room
WHERE mrbs_entry.room_id = mrbs_room.id
AND area_id = 101
AND start_time <= 1076068800
AND end_time > 1076065200

Here is the correct result :
SQL> Connected.

ID START_TIME END_TIME NAME ID T
---------- ---------- ---------- ---- -- -
82 1076065200 1076068800 test 41 I

Ran from php, I got this :

ID START_TIME END_TIME NAME T
---------- ---------- ---------- ---- -- -
41 1076065200 1076068800 test I

the two ID fields are named with their table name, but php keep the second
value and display it as the first one.

View Replies !

PHP Mysql & Oracle
I am migrating a php / mysql website to php / oracle. our user authentication system uses the mysql encrypt function to store passwords, without specifying a salt.

Does anyone know how to encrypt the a php variable in the same way that mysql encrypt function does so that i can compare the password stored in the db & the user entered one. the php crypt function seems to take a salt as a argument but i dont know the salt that mysql uses.

View Replies !

Oracle Installation
I have install the Oracle on remote machine and write a simple code to connect with remote machine...but i 'm not able to get wht setting we have to do in php to run for Oracle..i got some drafts from internet...i uncomment the extension in php.ini (php_oci8.dll)

then copy this .dll to extension_dir path of php.ini...and then copy the oci.dll and php_oci8.dll to windows/system...when i run apache shows warning...
"Unable to load dynamic library ‘D:PHPextensions/php_oci8.dll’ – The specified procedure could not be found."

View Replies !

Apache Oracle
I am running PHP with the apache server on Win98, I am working offline using localhost, so PHP is working, now I am trying to connect to my Personal Oracle 8 database on my computer. I am a bit confused in how to set up Net8 for localhost? I have set the php.ini file by uncommenting the extension=php_oci8.dll, and setting the path to this dll. Code I use in my Login.php file

PutEnv("ORACLE_SID=ORCL");
PutEnv("ORACLE_HOME=C:ORAWIN98");

// to log into the database
$conn = OCILogon("scott","tiger");

but just comes up with an error from the $conn line. I have looked through the PHP4 Manual but most oracle functions wont be of any good until I can log in.

View Replies !

PHP - ORACLE - VARRAY
I need to know how to get a collection (varray), basically it's an
array of chars with size of 9999 positions, from oracle so I can use
it as an array with php. There's very little documentation about it.
The only thing I found was
http://conf.php.net/pres/slides/oci/paper.txt , but only talks about
putting an array on the database, not getting it.

I tried this:
$arr = OCINewCollection($db,'VARCHAR2_V','SCHEMA');
$stmt=ociparse($db,$query_sql);
OCIDefineByName($stmt,'VFIELD',$arr);
OCIExecute($stmt);

But no luck.
VARCHAR2_V is the varray type.
The variable $query_sql is a simple SELECT of the VARRAY, and in SQL
Navigator works just fine.

print $arr->size()."
";
Just says that the size is 0.

Is there a way to get the array, with php commands or sql?

View Replies !

Oracle Mystery
I have a few apps written in PHP, running on Fedora Core. After porting
these applications from PostgreSQL to Oracle a bug appeared: sometimes,
not in a reproducable manner, the web page does not appear in the
browser and after examining the html source in the browser I notice
that the code is cut in half, somewhere after about the first 3-4
kbytes.

It happens quite often, once in every two minutes. The problem was not
there when I used PostgreSQL. PHP is compiled from source against the
Oracle 10 client downloaded from technet.

ps: I tried to migrate to the integrated zend instant client solution,
but then the letters with accents ceased to appear. Instant client does
not use nls_lang, which was set to american_america.ee8iso8859p2. I
would really appreciate any ideas how to get my special letters appear
again with instant client.

View Replies !

PHP And Oracle Support
I need to access an Oracle DB from some PHP pages, so I need to compile my
PHP with Oracle support. So, the point is:

Do I have to download the whole 1.7GB stuff? Is there anything containing
only headers ald libs needed to compile? Any other solution? Or am I just
on the wrong path?

View Replies !

Php Oracle Problem
I am trying to use oracle with php

i have configured the php & oracle on my window-xp system .
i have all the necussary changes that need be done.
i have uncomment the code , in php.ini
php_oci8.dll
php_orale.dll

i am able to see the oracle & oci8 section on php.ini file

but sill when i ren test probram i am getting below error
Fatal error: Call to undefined function: oci_connect() in c:Inetpub
wwwrootori.php

$db="hidden";
$c1 = oci_connect("scott", "tiger", $db);

When i run this file i get one alert also for php.ext. That says

---------------------------
php.exe - Application Error
---------------------------
The instruction at "0x7c9144a7" referenced memory at "0x00000010". The
memory could not be "read".

Click on OK to terminate the program
Click on CANCEL to debug the program
---------------------------
OK Cancel
---------------------------

View Replies !

PHP And Oracle OCI Interface
I have a simple application which accepts some search criteria, and then displays all of the data results in table format. I would like to have a [PREV] and [NEXT] buttons, but I cannot see a way to jump to a particular record. So that I can limit the number of records displayed on the screen. I'd like a way to say:

startpostion( pageNo * recordsSet )
while (read record() and rec++ < recordSet)
print data;

Can I do this anyway?

View Replies !

Oracle With PHP In Liux
i'm running php 5 on a redhat server (9.0) and connecting to an oracle 8 database (on a windows) using OCI 8. Randomly, before that am i install the oracle client in to the linux machine ????? or what should i doooo ?

View Replies !

Oracle Tutorial
Are there any tutorials on linking Oracle 10g and PHP? I currently have a PHP application that uses MySQL, but our database folks want to use Oracle.

I've read http://php.net/oracle and the basics seem to be there. But are there any sample scripts or anything that might help me get started?

View Replies !

Oracle Extension
I'm trying to enable the Oracle Oci8 extension. I've got the ming extension loading so I know its not an extensions_dir problem. I'm using Oracle 10g so I have installed the OraClient on the web server to get the needed Oracle dlls. It is still giving me 'unable to load'. Do I need to copy the oracle dlls any other place or am I missing something?

View Replies !

Oracle On Apache
I'm using PHP to connect Oracle with OCI . But a serious problem ocurred. If the network error happened that I cannot connect to Oracle DB , and then I fixed the network problem, but I also cannot connect to Oracle DB until I restarted the Apache server.

View Replies !

Oracle - Run A Procedure
I'm new to Oracle and I want to run a procedure from my php script. The procedure have 5 IN variables and 1 out variable. My script is like this: Code:

View Replies !

Oracle And Encryption
I am running an oracle database with the application written in PHP. I would like to be able to have the option to encrypt data residing in certain columns in certain tables i.e. encrypt the SSNO column but not he Fname column. I would like to keep it in its encrypted form in the database but I would like to be able to show it to certain privileged people based on a password.

Can public key encryption be incorporated here in the php application such that if I can encrypt the data based on a key that in it self can be encrypted in a way that you can revoke certain passwords if the employee leaves - much that same way you have revocation lists management in PGP.

View Replies !

Oracle Error
PHP Warning: ocilogon(): _oci_open_server: Error while trying to retrieve
text for error ORA-12154 Anyone get this error before?

View Replies !

5.03 IIS 6 Oracle 9i Connection
I set up PHP 4.xx using Apache 1.3 on Windows XP to begin a
project. The project now needs to be moved to a real test box.

Admittedly, I am not quite sure how I was able to access Oracle on my
machine, but I know I have the Oracle client installed, have two odbc
DSNs (CAI/PT Oracle 8) installed and uncommented php_oci8.dll and
php_oracle.dll. Other than that, I kind of just played around until it
worked. Code:

View Replies !

Oracle Connection
I am having a bad time with connection of php and oracle. I m using PEAR for the same. OCI8 extension have been enabled and it shows in phpinfo();

but when i use DB/MDB2 to connect it simply returns with wierd errors. While i was browsing, i found this script. Code:

View Replies !

Oracle Function
I use php with oracle database and i need function like mysql_data_seek i need to set the result pointer to the row number I need.

View Replies !

Oracle Into An Array
I have 300 data's in my oralce database, which has 22 fields. 300*22 = 6600 datas all together. What I want do is I want to retreive those values from the database and stored in array, then sorted. For example, If I click on the first field then it will sort by that, then if I click on the second field then it will sort by that...etc. I basically i want to retreive all the data's from my database, whihc I know how to do that, I jsut want to know how to stored in array all the datas.

View Replies !

JSP Or For Connecting To Oracle
My client is very pro JSP; however, I would prefer to use PHP to connect to an Oracle DB, as I am more familiar with it. What advantages, if any, does JSP offer over PHP, specifically with regard to connecting to an Oracle DB?

View Replies !

ODBC, Oracle
does anyone know the reason of displaying this error message: 'Specified
driver could not be loaded due to system error 126 (Oracle73)?'

The Oracle client is installed on the same machine as the Apache with
PHP and the ODBC sources are configured properly. The ODBC source works
with MS Access and SQL Server but does not want to work with the PHP
script. Any ideas?

View Replies !

Calling Oracle Procedures From PHP
Is there any way to call Oracle Stored Procedures from PHP?

View Replies !

Bulletin Board With PHP/Oracle
We want to build a bulletin board for our intranet and it has been decreed by the high and mighty leaders that if we use a database it must be Oracle. I want to use PhpBB or vBulletin. Has anybody out there done anything like converting stuff built for PHP/MySQL to PHP/Oracle?

View Replies !

Accessing Remote Oracle 8 With PHP
Hello, I am quite familiar with MySQL and MsSQL and accessing them with PHP, but my boss needs the ability to access a remote Oracle 8 database. I have never used Oracle before and I am having a hard time finding any helpful documentation and examples for connecting to the database and querying it. I have looked at most everything at php.net and tried their examples, but I have not been able to bring up any data from the remote database. I keep getting errors like:

Warning: Supplied argument is not a valid Oracle-Cursor resource in /home/httpd/html/oracle-view.php on line 47
ORA-00000: normal, successful completion
(Line 47 Marked below)

Code:
putenv("ORACLE_HOME=/usr/oracle");
putenv("ORACLE_SID=my_database");

$handle = Ora_Logon("user@xxx.xxx.xxx.xxx", "pass") or
$cursor = Ora_Open($handle);
Ora_Commitoff($handle);

$query = "SELECT * FROM my_table";

Line 47: Ora_Parse($cursor, $query) or
die (Ora_Error());
Ora_Exec($cursor);

Can anyone see anything that I am doing wrong? Or know of any good sites with Oracle/PHP examples?

View Replies !

Connect To Oracle Database
I am running a PHP script on unix. I am trying to connect to Oracle database. Before i start using the functions like Ora_Logon etc, what steps do i have to take in order to make PHP talk to Oracle database?

View Replies !

Trying To Connect PHP4 To Oracle 9.i
I am trying to get PHP4 to work with Oracle 9.i on Suse Linux

I have the DSO version of Apache version 1.3.27 and PHP 4.3.1 Running. I have this setup running successfully with mysql, however I am trying to get it to connect to a Oracle 9.i database.

PHP and Apache came pre-installed with Suse Linux 8.2. When I look at <? Phpinfo ?> I do not see the –with oci8 module installed. Since php came installed with my version of Linux, I do not have the source. I tried downloading the php source and ./configure –with oci8, however , after “make install” it does not show the new module.

Also it appears to be installing some of PHP in different directories from the ones the linux install used.

Is there any other way to get the Oracle module installed without running ./configure? Such as a RPM to install that module? If not what parameters do I need to use with the ./configure?

View Replies !