ifx_connect
(PHP 4, PHP <=5.2.0)
ifx_connect — Open Informix server connection
Description
$database
[, string $userid
[, string $password
]]] )ifx_connect() establishes a connection to an Informix server.
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().
Parameters
All of the arguments are optional, and if they're missing, defaults are taken from values supplied in php.ini (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).
-
database -
The database name, as a string.
-
userid -
The username, as a string.
-
password -
The password, as a string.
Return Values
Returns a connection identifier on success, or FALSE on error.
Examples
Example #1 Connect to a Informix database
<?php
$conn_id = ifx_connect ("mydb@ol_srv1", "imyself", "mypassword");
?>
See Also
- ifx_pconnect() - Open persistent Informix connection
- ifx_close() - Close Informix connection
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- Informix
- ifx_affected_rows
- ifx_blobinfile_mode
- ifx_byteasvarchar
- ifx_close
- ifx_connect
- ifx_copy_blob
- ifx_create_blob
- ifx_create_char
- ifx_do
- ifx_error
- ifx_errormsg
- ifx_fetch_row
- ifx_fieldproperties
- ifx_fieldtypes
- ifx_free_blob
- ifx_free_char
- ifx_free_result
- ifx_get_blob
- ifx_get_char
- ifx_getsqlca
- ifx_htmltbl_result
- ifx_nullformat
- ifx_num_fields
- ifx_num_rows
- ifx_pconnect
- ifx_prepare
- ifx_query
- ifx_textasvarchar
- ifx_update_blob
- ifx_update_char
- ifxus_close_slob
- ifxus_create_slob
- ifxus_free_slob
- ifxus_open_slob
- ifxus_read_slob
- ifxus_seek_slob
- ifxus_tell_slob
- ifxus_write_slob
Коментарии
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!
Here's a tip :
When i first installed the informix through the removing the ; at php_ifx.dll and then restarted apache
then checking the phpinfo(); the connection wasn't established and i had this error that i have to set the INFORMIXSERVER.
Work Frame : Windows XP,Apache 2.2.1 php 5.3 The ODBC was working fine and i could connect to the informix server using the odbc connection
The problem is that the sql engine was on another machine with different platform.
[SOLUTION]
add an environmental variable called INFORMIXSERVER with the value of the server e.g myInformixServer which itself has an ip 192.x.x.x
You can do that on windows by right click on my computer advanced >> environmental variables >> add new System variable >> variable name = INFORMIXSERVER
variable value = myInformixServer
it worked like a charm