PHP code example of metarush / data-access

    
        
<?php
require_once('vendor/autoload.php');

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

    

metarush / data-access example snippets

$builder = (new \MetaRush\DataAccess\Builder)
    ->setDsn('mysql:host=localhost;dbname=example') // PDO DSN
    ->setDbUser('foo')
    ->setDbPass('bar');

// or just

    ->setPdo($your_own_pdo);

$dal = $builder->build();

// insert 'foo' in column 'col1' and 'bar' in column 'col2'
$data = [
    'col1' => 'foo',
    'col2' => 'bar'
];
$lastInsertId = $dal->create('table', $data);

// find value of column 'col2' where 'col1' == 'foo'
$column = $dal->findColumn('table', ['col1' => 'foo'], 'col2');
\print_r($column); // bar

// find row where column 'col1' == 'foo'
$row = $dal->findOne('table', ['col1' => 'foo']);
\print_r($row);

// find all rows
$rows = $dal->findAll('table');
\print_r($rows);

// find rows where column 'col1' = 'foo'
$rows = $dal->findAll('table', ['col1' => 'foo']);
\print_r($rows);

// find rows where column 'col1' = 'foo', order by col1 DESC
$rows = $dal->findAll('table', ['col1' => 'foo'], 'col1 DESC');
\print_r($rows);

// find rows where column 'col1' = 'foo', order by col2 DESC, limit 2, offset 3
$rows = $dal->findAll('table', ['col1' => 'foo'], 'col2 DESC', 2, 3);
\print_r($rows);

// find rows grouped by column 'col1'
$dal->groupBy('col1');
$rows = $dal->findAll('table');
\print_r($rows);

$data = ['col1' => 'bar'];
$where = ['col2' => 'foo'];
$dal->update('table', $data, $where);

$where = ['col1' => 'foo'];
$dal->delete('table', $where);

$where = [
    'foo' => ['a', 'b', 'c'],
    'bar' => null,
    'baz' => 'dib',
    'zim = NOW()'
];

$where = [
    'foo > 20',
    'bar <= 30',
    'baz BETWEEN 5 AND 10',
    "firstName LIKE 'test%'"
];

$dal->beginTransaction();
$dal->commit();
$dal->rollBack();

$preparedStatement = 'SELECT * FROM table WHERE x = ? AND y = ?';
$bindParams = ['foo', 'bar'];
$fetchStyle = \PDO::FETCH_BOTH; // See https://www.php.net/manual/en/pdostatement.fetch.php for options. Default: \PDO::FETCH_BOTH
$rows = $dal->query($preparedStatement, $bindParams, $fetchStyle);
\print_r($rows);

$preparedStatement = "INSERT INTO table (firstName, lastName, age) VALUES (?, ?, ?)";
$bindParams = ['Mark', 'Calaway', '18'];
$numberOfAffectedRows = $dal->exec($preparedStatement, $bindParams); // returns 1
$lastInsertID = $dal->getLastInsertId();

$preparedStatement = "INSERT INTO table (firstName, lastName, age) VALUES (?, ?, ?), (?, ?, ?)";
$bindParams = ['Mark', 'Calaway', '18', 'Dwayne', 'Johnson', '17'];
$numberOfAffectedRows = $dal->exec($preparedStatement, $bindParams); // returns 2
$lastInsertID = $dal->getLastInsertId();

$preparedStatement = "UPDATE table SET age = ? WHERE lastName = 'Doe'";
$bindParams = ['18'];
$numberOfAffectedRows = $dal->exec($preparedStatement, $bindParams);

$preparedStatement = "DELETE FROM table WHERE lastName = ?";
$bindParams = ['Doe'];
$numberOfAffectedRows = $dal->exec($preparedStatement, $bindParams);

->setStripMissingColumns(true);

->setTablesDefinition(array $tablesDefinition);

$tablesDefinition = [
    'UsersTable' => [ // table name
        'id', 'firstName', 'lastName' // column names
    ],
    'PostsTable' => [ // table name
        'id', 'subject', 'message' // columns names
    ]
];

->setLogger(use Psr\Log\LoggerInterface $logger);

->setStripMissingColumns(bool);

->getLastInsertId();