dbx_connect

PHP Manual
Prev		Next

Description

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

Warning

This function is EXPERIMENTAL. The behaviour of this function, the name of this function, and anything else documented about this function may change in a future release of PHP without notice. Be warned and use this function at your own risk.

Returns: a dbx_link_object on success, FALSE on error. If a connection has been made but the database could not be selected, the connection is closed and FALSE is returned. 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"
module DBX_FBSQL : "fbsql" (CVS only)

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.