[PHP-DEV] Bug #2045: I can't use PHP3 with informix IDS7.3UC5 From: musica98 <email protected>
Date: 08/12/99

From: musica98 <email protected>
Operating system: Redhat5.2(2.0.36)
PHP version: 3.0.12
PHP Bug Type: Other
Bug description: I can't use PHP3 with informix IDS7.3UC5

I'm user of Redhat5.2(2.0.36) + IDS7.3-UC5 + MYSQL + PHP3.0.12

I want use PHP3 with IDS7.3.
but, I have error using PHP3 with IDS7.3.
first, my install method is following
---------------------------------------------
My informixuser & root's .bash_profile
---------------------------------------------
export USERNAME ENV PATH
export PATH=/usr/local/jdk1.2/bin:$PATH
export PATH=/home/informix/bin:$PATH:$HOME/bin
export INFORMIXDIR=/home/informix
export INFORMIXSERVER=linux
export LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$LD_LIBRARY_PATH
export TERMCAP=$INFORMIXDIR/etc/termcap
export DBLANG=ko_Kr.ksc
-----------------------------------------------
My install command (and I'm use IMAP function)
-----------------------------------------------
php & apache's source extract into /usr/local
1. cd apache1.3.6
2. ./configue --prefix=/www
3. cd ../php-3.0.12
4. ./configure --with-mysql=/usr/local/mysql --with-informix=yes --with-apache=../apache1.3.6 --with-imap=yes --enable-track-vars
5. make
6. make install
7. cd ../apache_1.3.6
8. ./configure --prefix=/www --activate-module=src/modules/php3/libphp3.a
9. make
10. make install
11. Configuration httpd.conf php3.ini
12. Starting IDS7.3 (oninit)
13. Starting Apache

I have no error.
-----------------------------------------------
I checked following source
-----------------------------------------------
<?
        echo(phpinfo());
?>

1. I checked INFORMIX section.
-----------------------------------------------------|
| | |
| |Allow persistent links: Yes |
| |Persistent links: 0/Unlimited |
| informix |Total links: 0/Unlimited |
| |Client API version: 7.20 |
| |Compilation definitions: IFX_INCLUDE= |
| | IFX_LFLAGS= |
| | IFX_LIBS= |
------------------------------------------------------

2. I checked stores7 Database following source.
   (My informix servername = linux)
<?
$connect=ifx_connect( "stores7 <email protected>", "informix", "*******");

$res_id = ifx_query("
select o.order_num, i.total_price
from orders o, items i
where o.order_num = i.order_num
", $connect);

if (!$res_id) {
printf("Can't select orders : %s\n<br>%s<br>\n",
ifx_error(),
ifx_errormsg()) ;
die;
}

ifx_htmltbl_result($res_id, "border=1");
ifx_free_result($res_id);
ifx_close($connect);
?>

but I get follow result.
--------------------------------------------
Warning: ifx_pconnect : E [SQLSTATE=IX 000 SQLCODE=-922] in /home/musica/www/index.html on line 3

Warning: ifx_query : 0 (type -1) is not a Informix link index in /home/musica/www/index.html on line 9
Can't select orders : E [SQLSTATE=IX 000 SQLCODE=-922]
Cannot get name of current working directory.
--------------------------------------------

I don't know my mistake.

I used informix+php3 at home(Redhat 6.0(2.2.5)+IDS7.3-UC7 + MYSQL + PHP3.0.11)
It's good.
But at school Redhat5.2(2.0.36) + IDS7.3-UC5 + MYSQL + PHP3.0.12
It's don't run.

Please help me.
Thanks your try. 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>