NYCPHP Meetup

NYPHP.org

[nycphp-talk] PHP Question -- SID in Oracle

Julia Sheehy jusheehy at vassar.edu
Tue Dec 4 08:18:47 EST 2007


My question is:  how can I accurately capture and display the name of 
the db to which I am connected?

We use Oracle here.  If you know of a solid online resource for 
PHP/Oracle guidance which I can tap, please redirect.

I'm developing a little application connected to our pre-production 
database.  Once the application is live I'll be pointing it to the live 
database.  In the interim I'd like to note on the screen which database 
the user is connected to so that the folks beta testing are kept aware 
(and don't stress out when they've deleted several things they didn't 
intend to remove).

I am attempting to use the getenv function for this purpose:

$ORACLE_SID = getenv("ORACLE_SID");

  but when I echo it

echo "ORACLE_SID = $ORACLE_SID<br>";

It shows that I am connected to the live database when I am certain (I 
checked both the connection params and all the data after posting 
changes) I am connected to pre-production.



Thanks either way.  I am searching via other sources too.


Julia Sheehy
Vassar College
 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jusheehy.vcf
Type: text/x-vcard
Size: 474 bytes
Desc: not available
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20071204/84692a13/attachment.vcf>


More information about the talk mailing list