PHP code example of roolith / database

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

roolith / database example snippets


use Roolith\Store\Database;

$db = new Database();
$db->connect([
    'host' => 'host',
    'name' => 'dbname',
    'user' => 'username',
    'pass' => 'password',
]);

// Get all users
$users = $db->query("SELECT * FROM users")->get();
print_r($users);

// Get all usernames
$usernames = $db->table('users')->select([
    'field' => 'name',
])->get();
print_r($usernames);

// Disconnect
$db->disconnect();


$db->query("SELECT * FROM users")->get();


$db->table('users')->select([
    'field' => ['name', 'email'],
    'condition' => 'WHERE id > 0',
    'limit' => '0, 10',
    'orderBy' => 'name',
    'groupBy' => 'name',
])->get();


$result = $db->table('users')->insert(
    ['name' => 'Brannon Bruen', 'email' => '[email protected]']
);

print_r($result->success());


$result = $db->table('users')->insert(
    ['name' => 'John doe', 'email' => '[email protected]'],
    ['email']
);


$result->affectedRow();
$result->insertedId();
$result->isDuplicate();
$result->success();


$result = $db->table('users')->update(
    ['name' => 'Habib Hadi', 'email' => '[email protected]'],
    ['id' => 1]
);


$result = $db->table('users')->update(
    ['name' => 'Habib Hadi', 'email' => '[email protected]'],
    'id = 1'
);


$result = $db->table('users')->update(
    ['username' => 'johndoe'],
    ['id' => 4],
    ['username']
);


$result->affectedRow();
$result->isDuplicate();
$result->success();


$result = $db->table('users')->delete(['id' => 4]);


$result->affectedRow();
$result->success();


$db = new Database();
$db->connect([
    'host' => 'host',
    'name' => 'dbname',
    'user' => 'username',
    'pass' => 'password',
]);


$db = new Database([
   'host' => 'host',
   'name' => 'dbname',
   'user' => 'username',
   'pass' => 'password',
]);


$db->disconnect();


$db->table('users')->where('name', '%Hadi%', 'LIKE')->get();


$db->table('users')->find(1);


$db->table('users')->pluck(['name', 'email']);


$db->query("SELECT id FROM users")->count();


$total = $db->query("SELECT id FROM users")->count();
$result = $db->query("SELECT * FROM users")->paginate([
    'perPage' => 5,
    'pageUrl' => 'http://domain.com',
    'primaryColumn' => 'id',
    'pageParam' => 'page',
    'total' => $total,
]);


$total = $db->query("SELECT id FROM users")->count();
$result = $db->query("SELECT * FROM users")->paginate([
    'perPage' => 5, // default 20
    'total' => $total,
]);


print_r($result->getDetails());


$db->debugMode()->table('users')->find(1);