ifx_connect

Description

int ifx_connect ( [string database [, string userid [, string password]]] )

Returns a connection identifier on success, or FALSE on error.

ifx_connect() establishes a connection to an Informix server. All of the arguments are optional, and if they're missing, defaults are taken from values supplied in configuration file (ifx.default_host for the host (Informix libraries will use INFORMIXSERVER environment value if not defined), ifx.default_user for user, ifx.default_password for the password (none if not defined).

In case a second call is made to ifx_connect() with the same arguments, no new link will be established, but instead, the link identifier of the already opened link will be returned.

The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling ifx_close().

例子 1. Connect to a Informix database
<?php $conn_id = ifx_connect ("mydb@ol_srv1", "imyself", "mypassword"); ?>

See also ifx_pconnect() and ifx_close().

add a note User Contributed Notes

bernd dot newman at t-online dot de
11-Apr-2003 06:00


Problem with INFORMIX-Access with PHP4, WIN NT 4.0?



1. php.ini: extension=php_ifx.dll

2. Path: Informix/BIN

3. httpd.conf: PassEnv INFORMIXSERVER

                    PassEnv INFORMIXDIR

4. use the Informix-tool regcopy.exe to copy the registry settings in the system-account.



good luck!

twins3n at yahoo dot com
27-Jan-2003 09:51


Informix is a real dog to figure out because of the stupid names used for variables. After struggling for ages I figured it out....



I was connecting to an Informix SE 5.07 db.



INFORMIXSERVER is the first column of the entry in the sqlhosts file NOT the IP or name of the server.

INFORMIXHOME is the base directory of the client installation eg. /opt/informix

Set these variables in /etc/profile and PassEnv them in your Apache httpd.conf file to php.



My connect string is like this:

ifx_connect("/home/cserver/cdb/csdb@local_se, "user", "pass")



The /home/cserver/cdb/csdb is the path to the db file.

local_se is the same as INFORMIXSERVER



I hope this helps some people since the Informix documentation really sucks.

add a note