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