GeezerVison

The World Wide Web, restored to 800 pixels of glory.

GeezerVison is showing cycle-orm.dev — Cycle ORM: Databases - Access Database

Revision: Wed, 04 Nov 2026 16:26:00 GMT

Database - Access Database

Access the Database
Run Queries

Follow the configuration instructions here.

#Access the Database

Once DBAL component configured properly, you can access your databases in controllers and services multiple ways:

php

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'));

#Run Queries

To run the database query use method query:

php

$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:

php

$db = $dbal->database();

print_r(
    $db->execute(
        'DELETE FROM users WHERE id > ?',
        [
            1
        ]
    ) // number of affected rows 
);

Read how to use query builders here.

← PREVIOUS Connect to Database

NEXT → Profiling and Logging

2.x

1.x

Edit this page

You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.