Php/docs/function.dbx-connect
dbx_connect
(PHP 4 >= 4.0.6, PHP 5 < 5.1.0, PECL dbx >= 1.1.0)
dbx_connect — Open a connection/database
说明
dbx_connect
( mixed $module
, string $host
, string $database
, string $username
, string $password
[, int $persistent
] ) : object
Opens a connection to a database.
参数
module
- 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"
-
host
- The SQL server host
database
- The database name
username
- The username
password
- The password
persistent
- The
persistent
parameter can be set toDBX_PERSISTENT
, if so, a persistent connection will be created.
The host
, database
,
username
and password
parameters are expected, but not always used depending on the connect
functions for the abstracted module.
返回值
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.
范例
Example #1 dbx_connect() example
<?php$link = dbx_connect(DBX_ODBC, "", "db", "username", "password", DBX_PERSISTENT) or die("Could not connect");echo "Connected successfully";dbx_close($link);?>
注释
Note:
Always refer to the module-specific documentation as well.