Differences

This shows you the differences between two versions of the page.

--- reference:connect [2015/07/26 01:05] – mnewnham
+++ v5:reference:connection:connect [2022/02/12 18:14] – [Description] use of setConnectionParameter() dregad
@@ Line 1: / Line 1: @@
 ====== connect ======
+~~NOTOC~~
 <WRAP right box>
 == See Also ==
-[[database:connection_matrix|The Connection Matrix]]
+[[v5:database:connection_matrix|The Connection Matrix]]
 == Syntax ==
    mixed connect(
@@ Line 14: / Line 15: @@
 </WRAP>
 ===== Description =====
-The essential function ''connect()'' establishes a connection to a database using the provided parameters. The traditional description of the connection parameters is as follows:
+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 [[v5:reference:connection:setconnectionparameter|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 [[database:connection_matrix|Connection Matrix]] for assistance.
+However the actual values of the parameters for some databases are such that the actual requirements can be confusing. See the [[v5:database:connection_matrix|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 =====
+<code php>
+/*
+ *  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');
+</code>