duc/query-builder

此软件包最新版本（dev-main）无可用许可证信息。

简单的查询构建器 composer 包

维护者

详细信息

github.com/MinhDuc2k03/query-builder

源代码

问题

安装: 2

依赖项: 0

建议者: 0

安全: 0

星标: 0

关注者: 1

分支: 0

公开问题: 0

dev-main 2024-02-27 06:27 UTC

Requires

  • php: >=7.0
  • ext-pdo: *

Unknown License b7cfcdc180bed29f28dd7ce733dc4a5e4bd8818e

  • duc

This package is auto-updated.

Last update: 2024-09-27 07:45:54 UTC

README

安装

composer require duc/query-builder:dev-main

如何使用

使用 Composer 自动加载器

require_once __DIR__ . '/vendor/autoload.php';
use Duc\QueryBuilder\QueryBuilder;

更改 $config 的信息

$servername = "localhost";
$dbname = "query_builder_test";
$username = "root";
$password = "12345678";

$config = [
    'host' => $servername,
    'dbname' => $dbname,
    'username' => $username,
    'password' => $password
];

初始化 QueryBuilder

$db = new QueryBuilder($config);

用法

选择

// Trả về dữ liệu từ CSDL
$data = $db->select('id', 'name')->from('users')->get();
print_r($data);     //Dữ liệu lấy được

// Chạy query rồi trả về query đó
$query = $db->select('id', 'name')->from('users')->execute();
print_r($query);     //SELECT id, name FROM users

插入

//INSERT INTO users (id, name) VALUES (2, 'duc'), (3, 'hoa')
$query = $db->insert('users', array('id', 'name'), 'VALUES', array(2, 'duc'), array(3, 'hoa'))->execute();

删除

//DELETE FROM users WHERE id=4
$query = $db->delete('users', 'id', 4)->execute();

更新

//UPDATE users SET name = 'trung' WHERE id = 1
$query1 = $db->update('users', array('name' => 'trung'), array('id', '=', 1))->execute();

//UPDATE users SET name = 'trung', age = 1 WHERE id = 1
$query2 = $db->update('users', array('name' => 'trung', 'age' => 1), array('id', '=', 1))->execute();