PHP code example of elbucho / database

1. Go to this page and download the library: Download elbucho/database 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/ */

    

elbucho / database example snippets


$database = new Database($config);

$results = $database->query('SELECT * FROM users`, [], 'prod');

foreach ($results as $user) {
    ...
}

$lastId = $database->getLastInsertId('prod');

var_dump($lastId);

// int(12345)

$rowCount = $database->getRows('prod');

var_dump($rowCount);

// int(23456)

$attribute = \PDO::ATTR_ERRMODE;
$value = \PDO::ERRMODE_EXCEPTION;
$handle = 'default';

$database->setAttribute($attribute, $value, $handle)