dbx_connect

Opens a connection to a database.

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"
• DBX_SYBASECT or "sybase_ct"
• DBX_OCI8 or "oci8"
• DBX_SQLITE or "sqlite"

The SQL server host

The database name

The username

The password

The persistent parameter can be set to DBX_PERSISTENT, if so, a persistent connection will be created.

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 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.

Introduced DBX_SQLITE.

Introduced DBX_OCI8.

Introduced DBX_SYBASECT.

Introduced DBX_FBSQL.

Always refer to the module-specific documentation as well.

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
?>

<?php
$link = dbx_connect(DBX_ODBC, "", "db", "username", "password", DBX_PERSISTENT)
    or die("Could not connect");

echo "Connected successfully";
dbx_close($link);
?>

dbx_close() -