connect
See Also
Syntax
mixed connect( optional string $parameter1 = '', optional string $parameter2 = '', optional string $parameter3 = '', optional string $parameter4 = '', optional bool $forceNewConnection=false )
Description
The essential function connect()
establishes a connection to a database using the provided parameters.
Since ADOdb 5.21,0, some database drivers support the use of setConnectionParameter(), which should be called before connect() to pass extra, database-specific parameters to the connect statement.
The traditional description of the connection parameters is as follows:
Parameter 1 | Parameter 2 | Parameter 3 | Parameter 4 |
---|---|---|---|
$hostName | $userId | $password | $database |
However the actual values of the parameters for some databases are such that the actual requirements can be confusing. See the Connection Matrix for assistance.
If the connection is made, $db becomes a database connection object that can be used until the script ends. If the connection fails, the value is set to false.
To debug the connection, set the value $db→debug = true;
before calling the $db→connect
statement
Usage
/* * Example using MySQL */ include 'adodb.inc.php'; /* * This is not a class below */ $db = newADOConnection('mysqli'); /* * Make a connection to a database on the local machine */ $db->connect('', 'user', 'password', 'employees');