PHP code example of kristoreed / laminas-db-manager

1. Go to this page and download the library: Download kristoreed/laminas-db-manager library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

kristoreed / laminas-db-manager example snippets


use Laminas\Db\Adapter\Adapter;
use Kristoreed\Laminas\DbManager\Query\Builder\FileBuilder as QueryFileBuilder;
use Kristoreed\Laminas\DbManager\Query\Builder\StringBuilder as QueryStringBuilder;
use Kristoreed\Laminas\DbManager\Query\Executor\Executor as QueryExecutor;

$dbAdapter = new Adapter([
    'driver'    => 'pdo',
    'dsn'       => 'mysql:dbname=test;host=localhost',
    'username'  => 'admin',
    'password'  => 'admin',
]);

$queryExecutor = new QueryExecutor($dbAdapter);

# ------------ sql query object ---------------

$select = new Select();
$select->from(['u' => 'user'])
    ->columns(['*'])
    ->where(['id' => 404]);

$user = $queryExecutor->getRow($select);

# --------- sql query from file ---------------

$queryFileBuilder = new QueryFileBuilder($dbAdapter);
$queryFileBuilderResult = $queryFileBuilder->create('user.getUserById', [
    'id' => 404,
]);

$user = $queryExecutor->getRow($queryFileBuilderResult);

# --------- sql query from string -------------

$queryStringBuilder = new QueryStringBuilder($dbAdapter);
$queryStringBuilderResult = $queryStringBuilder->create('SELECT * FROM users AS u WHERE u.id=:id', [
    'id' => 404,
]);

$user = $queryExecutor->getRow($querStringBuilderResult);



$queryFileBuilder = new QueryFileBuilder($dbAdapter);
$queryFileBuilder->setRootPath(['slq', 'storage']);
$queryFileBuilderResult = $queryFileBuilder->create('user.getUserById', [
    'id' => 404,
]);

// in above example getUserById is equivalent of getUserById.sql file and the file should be located inside project in directory: sql/storage/user/