Follow the configuration instructions here.
Once DBAL component configured properly, you can access your databases in controllers and services multiple ways:
declare(strict_types=1);
require_once "vendor/autoload.php";
use Cycle\Database\Config\DatabaseConfig;
use Cycle\Database\DatabaseManager;
use Cycle\Database\Driver\SQLite\SQLiteDriver;
$dbal = new DatabaseManager(new DatabaseConfig(...));
//Default database
print_r($dbal->database());
//Using alias default which points to primary database
print_r($dbal->database('default'));
//Secondary
print_r($dbal->database('secondary'));
To run the database query use method query:
$db = $dbal->database();
print_r(
$db->query(
'SELECT * FROM users WHERE id > ?',
[
1
]
)->fetchAll()
);
To execute update or delete statement use the alternative method execute:
$db = $dbal->database();
print_r(
$db->execute(
'DELETE FROM users WHERE id > ?',
[
1
]
) // number of affected rows
);
Read how to use query builders here.