ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== $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 =====
<code php>

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......
*/
</code>

===== Using An Existing Connection =====
<code php>

$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();
</code>