AgelxNash / modx-evo-database

example.php

<?php

include_once 'vendor/autoload.php';

$DB = new AgelxNash\Modx\Evo\Database\Database(
    'localhost',
    'modx',
    'homestead',
    'secret',
    'modx_',
    'utf8mb4',
    'SET NAMES'
);
$DB->setDebug(true);

try {
    $DB->connect();
    echo ' [ CONNECTION TIME ] ' . $DB->getConnectionTime(true) . ' s. ' . PHP_EOL;
    echo ' [ VERSION ] ' . $DB->getVersion() . PHP_EOL;

    $table = $DB->getFullTableName('site_content');

    echo ' [ METHOD ] query' . PHP_EOL;
    $result = $DB->query('SELECT * FROM ' . $table . ' WHERE parent = 0 ORDER BY pagetitle DESC LIMIT 10');
    foreach ($DB->makeArray($result) as $item) {

It seems like $result can also be of type boolean; however, parameter $result of AgelxNash\Modx\Evo\Database\Database::makeArray() does only seem to accept mysqli_result, maybe add an additional type check?

        echo "\t [ DOCUMENT #ID " . $item['id'] . ' ] ' . $item['pagetitle'] . PHP_EOL;
    }

    echo ' [ METHOD ] select with string' . PHP_EOL;
    $result = $DB->select('*', $table, 'parent = 0', 'pagetitle DESC', '10');
    foreach ($DB->makeArray($result) as $item) {
        echo "\t [ DOCUMENT #ID " . $item['id'] . ' ] ' . $item['pagetitle'] . PHP_EOL;
    }

    echo ' [ METHOD ] select with array' . PHP_EOL;
    $result = $DB->select(
        ['id', 'pagetitle', 'title' => 'longtitle'],
        ['c' => $table],
        ['parent = 0'],
        'ORDER BY pagetitle DESC',
        'LIMIT 10'
    );
    foreach ($DB->makeArray($result) as $item) {
        echo "\t [ DOCUMENT #ID " . $item['id'] . ' ] ' . $item['pagetitle'] . PHP_EOL;
    }

    foreach ($DB->getAllExecutedQuery() as $id => $query) {
        echo ' [ QUERY #' . $id . ' ] ' . PHP_EOL;
        foreach ($query as $key => $data) {
            echo "\t [" . $key . '] ' . $data . PHP_EOL;
        }
    }
    echo ' [ DONE ] ' . PHP_EOL;
} catch (Exception $exception) {
    echo get_class($exception) . PHP_EOL;
    echo "\t" . $exception->getMessage() . PHP_EOL;
    echo $exception->getTraceAsString() . PHP_EOL;
    exit(1);
}