dbx_connect

Description

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

dbx_connect() returns an 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, if so, a persistent connection will be created_

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

DBX_MYSQL or "mysql"
DBX_ODBC or "odbc"
DBX_PGSQL or "pgsql"
DBX_MSSQL or "mssql"
DBX_FBSQL or "fbsql" (available from PHP 4_1_0)
DBX_SYBASECT or "sybase_ct" (available from PHP 4_2_0)
DBX_OCI8 or "oci8" (available from PHP 4_3_0)
DBX_SQLITE or "sqlite" (cvs only)

The host, database, username and password parameters are expected, but not always used depending on the connect functions for the abstracted module_

The returned object has three properties:

database

It is the name of the currently selected database_

handle

It is a valid handle for the connected database, and as such it can be used in module_specific functions (if required)_

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

module

It is used internally by dbx only, and is actually the module number mentioned above_

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

Nota: Always refer to the module_specific documentation as well_