PHP 5.2.1+ Informix is no longer bundled with PHP
Gary asked how to get the old ifx_* Informix functions working with PHP 5.2.2 after they were dropped from the PHP tarball and supposedly moved to PECL, which his search didn't find. Responses: the Windows PECL package for 5.2.3 included ifx drivers, and PDO_INFORMIX is available in PECL (findable via Google), but that's PDO, not the legacy ifx_* API, which no one could locate in PECL. Advice was to port the apps to PDO (parameter binding, less SQL injection risk) or, as a quick hack, compile the ifx module as a shared library from the last PHP source that contained it. No confirmed resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Does anyone have details on how to get Informix to work with PHP 5.2.2 since they moved support to PECL? The PECL search shows no Informix support. Here is the link: http://us.php.net/manual/en/ref.ifx.php Thanks Gary Quiring
Ifx drivers were in php/windows 5.2.3 pecl package. What r u using? Linux? Windows? Functions? Pdo? > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Gary Quiring > Sent: Wednesday, September 19, 2007 21:26 > To: informix-list@iiug.org > Subject: PHP 5.2.1+ Informix is no longer bundled with PHP > > Does anyone have details on how to get Informix to work with PHP 5.2.2 > since they moved support to PECL? The PECL search shows no Informix > support. > > Here is the link: > http://us.php.net/manual/en/ref.ifx.php > > Thanks > Gary Quiring > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list
On Sep 19, 4:06 pm, "Jean Georges Perrin" <j...@jgp.net> wrote: > Ifx drivers were in php/windows 5.2.3 pecl package. > > What r u using? Linux? Windows? Functions? Pdo? > We are using Solaris 9 with Apache 2 connecting to an IDS 9.4 DB. I just found the PDO stuff on IBM's site. But this is not going to be backward compatible with our current PHP apps calling Informix? I will download tomorrow and see how much work is involved in getting it to work. I still don't get why the PHP dev group pulled the existing IFX commands. Gary
On Wed, 2007-09-19 at 15:50 -0700, Gary Quiring wrote: > On Sep 19, 4:06 pm, "Jean Georges Perrin" <j...@jgp.net> wrote: > > Ifx drivers were in php/windows 5.2.3 pecl package. > > > > What r u using? Linux? Windows? Functions? Pdo? > > > We are using Solaris 9 with Apache 2 connecting to an IDS 9.4 DB. I > just found the PDO stuff on IBM's site. But this is not going to be > backward compatible with our current PHP apps calling Informix? I > will download tomorrow and see how much work is involved in getting it > to work. I still don't get why the PHP dev group pulled the existing > IFX commands. The old IFX module, just like all other DB access modules in PHP before PDO, was rooted in the basic principles of "Who needs parameter binding when we have magic quotes?", "What's a namespace, is that like a function name prefix?", and "Who need a unified cross-database API, isn't everybody using MySQL?" If you can afford to port your code to PDO, you should do so. The ability to do parameter binding alone (Goodbye, SQL Injection Attacks, Hello, Improved Performance) is worth the price of admission. I'd take it a step further and port the code to Python, but that's just me... If you just need a quick and dirty fix, you could try grabbing the latest PHP source that did include the ifx_* stuff and attempt to compile the ifx module as a shared library for your version of PHP. That may or may not work, but it's worth a try if you're desperate. HTH, -- Carsten Haese http://informixdb.sourceforge.net
Gary Quiring wrote: > Does anyone have details on how to get Informix to work with PHP 5.2.2 > since they moved support to PECL? The PECL search shows no Informix > support. > > Here is the link: > http://us.php.net/manual/en/ref.ifx.php Google search for pdo_informix pulls up pecl.php.org as the first reference? If the PECL search didn't find it, it wouldn't be the first web site to be indexed better by Google than by its own search functionality. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0914 -- http://dbi.perl.org/ publictimestamp.org/ptb/PTB-1341 ripemd160 2007-09-20 03:00:06 5E305D533FBC0E2434487ADD46E276A2E47A52AF
On Wed, 2007-09-19 at 21:26 -0700, Jonathan Leffler wrote: > Gary Quiring wrote: > > Does anyone have details on how to get Informix to work with PHP 5.2.2 > > since they moved support to PECL? The PECL search shows no Informix > > support. > > > > Here is the link: > > http://us.php.net/manual/en/ref.ifx.php > > Google search for pdo_informix pulls up pecl.php.org as the first reference? > > If the PECL search didn't find it, it wouldn't be the first web site to > be indexed better by Google than by its own search functionality. PDO_INFORMIX is in PECL, but the OP was looking for the old "ifx_connect and co" stuff. That is not in the PHP tarball (at least as of 5.2.4), and it does not seem to be in PECL, or it is hidden somewhere where it eludes my search-fu. -- Carsten Haese http://informixdb.sourceforge.net