ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:session:reference:adodb_sess_conn

This is an old revision of the document!


$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 useful if you want session manager to use connection that relies on complex connection parameters, such a MySQL SSL certificates (see the second example). 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.1611438688.txt.gz · Last modified: 2021/01/23 22:51 by mnewnham