| 12345678910111213141516171819202122232425262728293031323334353637 |
- <?php
- declare(strict_types=1);
- ?>
- <!DOCTYPE html><link rel="stylesheet" href="data/style.css">
- <h1>Dumping SQL and Result Set | Dibi</h1>
- <?php
- if (@!include __DIR__ . '/../vendor/autoload.php') {
- die('Install packages using `composer install`');
- }
- $dibi = new Dibi\Connection([
- 'driver' => 'sqlite',
- 'database' => 'data/sample.s3db',
- ]);
- $res = $dibi->query('
- SELECT * FROM products
- INNER JOIN orders USING (product_id)
- INNER JOIN customers USING (customer_id)
- ');
- echo '<h2>dibi::dump()</h2>';
- // dump last query (dibi::$sql)
- dibi::dump();
- // dump result table
- echo '<h2>Dibi\Result::dump()</h2>';
- $res->dump();
|
