thiiagoms/tbuilder

PHP Query Builder

dev-main 2023-02-20 21:43 UTC

Requires

• ext-pdo: *

Requires (Dev)

• fakerphp/faker: ^1.21
• squizlabs/php_codesniffer: ^3.7

MIT

• Thiago Silva AKA thiiagoms

README

TBuilder - Database querybuilder 🧑‍🎓

Simple database querybuilder

• Dependencies
• Install
• Use

Dependencies

• +PHP8.2
• Composer

Install 📦

01 - Install package with composer

$ composer require thiiagoms/tbuilder

Use

01 - Call TBuilder\QueryBuilder and pass your database credentials

<?php

declare(strict_types=1);

if (php_sapi_name() !== 'cli') {
    echo '<h1>Only in CLI mode</h1>';
    exit;
}

require_once __DIR__ . '/vendor/autoload.php';

use TBuilder\Database\QueryBuilder;

$queryBuilder = new QueryBuilder('localhost', 3306, 'tbuilder', 'root', '');

// Select
$result = $queryBuilder->select('user', 'id, name, email');
foreach ($result as $person) {
    echo "\nId: {$person['id']}\nName: {$person['name']}\nE-mail: {$person['email']}\n";
}

// Insert
$payload = ['name' => 'Person example', 'email' => '[e-mail]'];
$id = $queryBuilder->insert('user', $payload);

echo "\nLast insert id {$id} \n";

// Update
$result = $queryBuilder->update('user', 'id = 1', ['name' => "TBuilder Test"]);
print_r($result); // true or false

// Delete
$result = $queryBuilder->delete('user', 'id = 1');
print_r($result); // true or false