Lots of oracle users

Anon

It looks like a lot of people are using Oracle.

Anyone know enough about it that they can write up a decent how-to?

Anon

That would be a good idea. But what specifically would it cover, as there are many aspects to consider?

Anon

Whatever you can write about. One thing I'd like to see is an oracle version of that database abstraction library that I put in the snippet library under 'databases'.

http://www.phpbuilder.com/snippet/detail.php?type=snippet&id=13

That alone would help newbies see the differences between mysql and oracle.

Umm - things like selecting our records and/or using the limit/offset syntax in those selects.

Inserting images into the db, similar to the article here about doing that with MySQL.

Or a page like my "get started with databases", only done right with Oracle in mind.

Copying data into an oracle table (so you can migrate from

Just general stuff will help people out.

Anon

I am willing to at least contribute to this effort, as I use PHP with Oracle at work and MySQL for my own site.

Anon

Great - could you start with a port of this file? Try to mix in LIMIT/OFFSET syntax.

http://www.phpbuilder.com/getit/databases.php3

Anon

I got started using PHP and Oracle from this site:

http://www.phpworld.com/articles/2000.03/oracle_000.html

Anon

Sure thing!

I can mix in my updated version of Rod's limit/offset here at phpbuilder.com(http://www.phpbuilder.com/columns/rod20000221.php3) which you can find as a whole at http://php.socket7.net/

Anon

Cool domain name too.

Anon

BTW, I am talking Oracle8i

Anon

That's fine - maybe you should explain the differences, if any??

Anon

I LOVE this database!!!!

Anon

What about the phplib oci8 abstraction .inc file... I've been using that a hell of a lot and it's saved me hours and hours...

Anon

Hi,

I run into a post of yours into the forum that you wanted to someone to port your database abstraction layer into oracle, is it was pretty small I thought to give it a try. Unfortunate some of the functions don't work and I have 2Q for you. For the db_result function the only way to do this in oracle is to get the whole record set from the database and count it, not a very efficient practice I’m sure you'll agree. For the db_result function, there is a way to implement this but, it would mean to move the cursor to the row needed and this means that you cannot go back in the record set, or you fall back to getting the whole record set again. And for the db_inserted function, you see oracle handles random id’s with sequences and in order for this to work, you must know the sequence name, so I’m making a new function like that which takes the sequence name as a second parameter. This would destroy reusability of the functions but still it’s the easiest way it can be done (and the only one I know right now, there is something with the %rowid, any help here).
Any tips go ahead.

yavo
I make spelling mistakes thank god for word processors…