ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:session:reference:adodb_sess_conn

$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();
v5/session/reference/adodb_sess_conn.txt · Last modified: 2021/01/23 22:53 by mnewnham