thiiagoms/tbuilder

PHP 查询构建器

维护者

详细信息

github.com/thiiagoms/tbuilder

源代码

问题

安装: 0

依赖: 0

建议者: 0

安全性: 0

星标: 0

关注者: 1

分支: 0

开放问题: 1

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

Requires

  • ext-pdo: *

Requires (Dev)

MIT 6963e625159e9f6f0be620538fe946f6fb1ecc41

This package is auto-updated.

Last update: 2024-09-21 21:34:51 UTC

README

Logo

TBuilder - 数据库查询构建器 🧑‍🎓

简单数据库查询构建器

依赖关系

  • +PHP8.2
  • Composer

安装 📦

01 - 使用 Composer 安装包

$ composer require thiiagoms/tbuilder

使用

01 - 调用 TBuilder\QueryBuilder 并传递您的数据库凭据

<?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' => 'person.per@example.com'];
$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