Very Computer

It seems like I am continually in the wilderness with some of my projects,
but was wondering if anyone had done any PHP and DB2 work?

I have a site that uses PHP to do their scripting, and now they need to add
some real function to the site, which will entail storing stuff in a
database that has transactional support.  Hence my suggestion for DB2 on
both the Win2K and Linux versions of their web servers.

I see from the sites I've visited and the books I've picked up that there
are functions for Oracle, Sybase, Informix and PostGress, but no mention of
DB2.  I was thinking that just regular ODBC would be a pain and so I
thought that mebbe some kind soul had been down this path and would be able
to show me how to do the simple SIUD stuff (Select Insert Update Delete).  
Again, a very simple example to start me off would be nice!  *making
praying hands gesture*

Thanks in advance for any help offered.

Mairhtin

irishboy at Imadethis dot com

I guess I answered my own request via the last search I did for Laurence:

http://www7b.boulder.ibm.com/dmdd/library/techarticle/scott/0614
_scott.html

BUT ...

If anyone *HAS* done some development and would not mind a question or
two ...  I'd be happy to say thank you with some fine Ghiridelli
chocolate in return.  :)

Mairhtin

Quote:> Hi,

> It seems like I am continually in the wilderness with some of my
> projects, but was wondering if anyone had done any PHP and DB2 work?

> I have a site that uses PHP to do their scripting, and now they need
> to add some real function to the site, which will entail storing stuff
> in a database that has transactional support.  Hence my suggestion for
> DB2 on both the Win2K and Linux versions of their web servers.

> I see from the sites I've visited and the books I've picked up that
> there are functions for Oracle, Sybase, Informix and PostGress, but no
> mention of DB2.  I was thinking that just regular ODBC would be a pain
> and so I thought that mebbe some kind soul had been down this path and
> would be able to show me how to do the simple SIUD stuff (Select
> Insert Update Delete).  Again, a very simple example to start me off
> would be nice!  *making praying hands gesture*

> Thanks in advance for any help offered.

> Mairhtin

> irishboy at Imadethis dot com

Hi,

I have use the following PHP class to work with Oracle, SQLServer, MySQL
and now they do support DB2, look at the docs they have tips on how to
set up a PHP DB2 connection on Unix.
I know that PHP-CLOB-DB2 support is not that good, but I may be mistaken

http://php.weblogs.com/ADODB

marcos oliva

Originally posted by Mairhtin O'Feannag