PHP Prime : Doc : System : Database

Database

First, you need to set the connection config:

$config['db.host'] = 'localhost';
$config['db.name'] = 's-craig-framework';
$config['db.user'] = 'stage';
$config_encrypted[SERVER]['db.pass'] = 'XXX';

$config['db.prefix'] = 'tpl_';

You can get access to the database object though the helper function:

$db = db_get();

Alternative connections

If you need to connect to a different database, use the configuration:

$config['db.old.host'] = 'localhost';
$config['db.old.name'] = 's-craig-framework';
$config['db.old.user'] = 'stage';
$config_encrypted[SERVER]['db.old.pass'] = 'password';

Then access the database object via:

$db_old = db_get('old');