Exemplo n.º 1
0
<?php

include 'database.php';
$query = new \DBAL\SQL\Query();
$query->build()->select('*')->from($database->Models['Control']);
$results = $query($database);
foreach ($results as $item) {
    var_dump($item);
}
Exemplo n.º 2
0
<?php

include 'database.php';
$query = new \DBAL\SQL\Query();
$query->build()->models();
$tables = $query($database);
foreach ($tables as $table) {
    var_dump($table);
}
Exemplo n.º 3
0
<?php

$query = new \DBAL\SQL\Query();
$query->build()->insert('table')->set('field', 'value')->set('field2', 2);
echo (string) $query;
Exemplo n.º 4
0
<?php

include 'database.php';
$query = new \DBAL\SQL\Query();
$query->build()->tables();
$tables = $query($database);
foreach ($tables as $table) {
    var_dump($table);
    $query = new \DBAL\SQL\Query();
    $query->build()->columns()->from($table);
    $columns = $query($database);
    var_dump($columns);
}