dbx_connect

PHP Manual
Prev		Next

Description

dbx_link_object dbx_connect (string module, string host, string database, string username, string password [, int persistent])

Returns: a dbx_link_object on success, FALSE on error. If a connection can be made but the database could not be selected, the function still returns a dbx_link_object. The 'persistent' parameter can be set to DBX_PERSISTENT so a persistent connection will be created.

The module parameter can be either a string or a constant. The possible values are given below, but keep in mind that they only work if the module is actually loaded.

module DBX_MYSQL : "mysql"
module DBX_ODBC : "odbc"
module DBX_PGSQL : "pgsql"
module DBX_MSSQL : "mssql"

The dbx_link_object has three members, a 'handle', a 'module' and a 'database'. The 'database' member is the name of the currently selected database. The 'module' member is for internal use by dbx only, and is actually the module number mentioned above. The 'handle' member is a valid handle for the connected database, and as such can be used in module-specific functions (if required), e.g.

<?php
$link = dbx_connect ("mysql", "localhost", "db", "username", "password");
mysql_close ($link->handle); // dbx_close($link) would be better here
?>

Host, database, username and password parameters are expected, but not always used, depending on the connect-functions for the abstracted module.

Example 1. dbx_connect() example
<?php $link = dbx_connect ("odbc", "", "db", "username", "password", DBX_PERSISTENT) or die ("Could not connect"); print ("Connected successfully"); dbx_close ($link); ?>

Note: Always refer to the module-specific documentation as well.