====== $ADODB_SESS_CONN ======
This variable holds an instance of the database connection and can be used as required. The connection is itself an instance of a standard ADOdb connections, and all available functionality may be used.
The feature is also useful if you want session manager to use a connection that relies on complex connection parameters, such a MySQL SSL certificates (see the second example) which cannot be achieved using the normal session connection. This is done by telling the session manager to use an already instantiated connection.
===== Usage =====
include_once 'adodb/adodb.inc.php';
include_once "adodb/session/adodb-session2.php";
$driver = 'mysqli';
$host = '127.0.0.1';
$user = 'user';
$pass = 'pass';
$database = 'adodb-sess';
ADODB_session::config($driver,$host,$user,$pass,$database);
session_start();
$_SESSION['page'] = 'page1';
/*
* Who else is connected?
*/
$SQL = "SELECT * FROM session2";
$result = $ADODB_SESS_CONN->execute($SQL);
/*
* etc etc etc......
*/
===== Using An Existing Connection =====
$dbtype="mysqli";
$dbhost="some.server";
$dbusername="some.user";
$dbpassword="some.password";
$dbname="some.db";
$dbconn=NewADOConnection($dbtype);
$dbconn->ssl_capath="";
$dbconn->clientFlags=MYSQLI_CLIENT_SSL;
$dbconn->Connect($dbhost,$dbusername,$dbpassword,$dbname);
$GLOBALS['ADODB_SESS_CONN'] = $dbconn;
ADOdb_Session::config($dbtype, $dbhost, $dbusername, $dbpassword, $dbname, $options=false);
session_start();