Re: [PHP] PHP and Oracle resources

2001-01-29 Thread Markus Fischer

On Sun, Jan 28, 2001 at 12:46:37AM -0500, Kristofer Widholm wrote : 
 Well, I've been given the joyous task of implementing the DaveTV 
 project at CBS via PHP, using Oracle as a database.
 
 I've never used Oracle before.
 
 Looking at the PHP functions for Oracle, and having heard about it in 
 the past, it seems like quite a different approach than any SQL 
 database I've ever used.  I still don't get the whole point of cursor 
 objects, etc. :-)

It's ain't that hard. Just use OCILogon to connect, then
OCIParse to parse the sql statement and finally OCIExecute it.
Loop through your result data with OCIFetchInto.

The Shitload of possible errors should be abstracted into
a class.

m.

-- 
Markus Fischer,  http://josefine.ben.tuwien.ac.at/~mfischer/
EMail: [EMAIL PROTECTED]
PGP Public  Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc
PGP Fingerprint: D3B0 DD4F E12B F911 3CE1  C2B5 D674 B445 C227 2BD0

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] PHP and Oracle resources

2001-01-27 Thread Kristofer Widholm

Well, I've been given the joyous task of implementing the DaveTV 
project at CBS via PHP, using Oracle as a database.

I've never used Oracle before.

Looking at the PHP functions for Oracle, and having heard about it in 
the past, it seems like quite a different approach than any SQL 
database I've ever used.  I still don't get the whole point of cursor 
objects, etc. :-)

It would all be pretty hilarious if it weren't so real, and with a 
big fat deadline looming smack for the end of February.

To get to the point: Anyone have any good PHP  Oracle tutorials, 
resources, books, etc, to point me to?  EVERYTHING I see is MySQL, 
MySQL, MySQL, and all I get for Oracle are lists of unexplained PHP 
function calls.

Just point me in the right direction. I can walk there myself.

Thanks for the help.

Kristofer
-- 
__

Kristofer Widholm
Web Pharmacy
[EMAIL PROTECTED]
191 Grand Street, Brooklyn  NY  11211
718.599.4893
__

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]