PHP code example of eril / crud

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

eril / crud example snippets




ril\QCrud\CRUD;

$pdo = new PDO(
    'mysql:host=localhost;dbname=myapp;charset=utf8mb4',
    'username',
    'password',
    [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
);

CRUD::registerConnection($pdo);


$id = CRUD::table('users')->create([
    'name' => 'Ana Silva',
    'email' => '[email protected]',
]);

$user = CRUD::table('users')->read($id);
$users = CRUD::table('users')->read(null, 'id, name, email');

$changed = CRUD::table('users')->update($id, ['name' => 'Ana Santos']);
$deleted = CRUD::table('users')->delete($id);

$activeUsers = CRUD::table('users')->select(
    'status = ? AND age >= ?',
    ['active', 18],
    'id, name, email'
);


$users = CRUD::query('users', 'u')
    ->select('u.id, u.name, p.bio')
    ->joinLeft(['profiles', 'p'], 'p.user_id = u.id')
    ->where('u.status', 'active')
    ->where('u.age', '>=', 18)
    ->orderByDesc('u.name')
    ->limit(20)
    ->get();


CRUD::transaction(function (PDO $pdo): void {
    CRUD::table('users')->create(['name' => 'Ana']);
    CRUD::table('profiles')->create(['user_id' => 1, 'bio' => 'Developer']);
});


CRUD::prepareTransactions();
CRUD::table('users')->create(['name' => 'Ana']);
CRUD::table('profiles')->create(['user_id' => 1, 'bio' => 'Developer']);

$exception = null;
$success = CRUD::executeTransactions($exception);


CRUD::configureCache([
    'driver' => 'file',
    'directory' => __DIR__ . '/storage/cache',
    'ttl' => 300,
    'namespace' => 'my-app:production',
]);

$users = CRUD::query('users')
    ->where('status', 'active')
    ->useCache()
    ->get();


CRUD::clearCache();


$user = crud('users')->read(1);
$activeUsers = query('users')->where('status', 'active')->get();