PHPackages                             vannghia/simple\_query\_builder - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. vannghia/simple\_query\_builder

ActiveLibrary[Database & ORM](/categories/database)

vannghia/simple\_query\_builder
===============================

simple query builder

v1.0.0(3y ago)019proprietaryPHP

Since Oct 4Pushed 3y ago1 watchersCompare

[ Source](https://github.com/vn0202/demo_simple_query_builder)[ Packagist](https://packagist.org/packages/vannghia/simple_query_builder)[ RSS](/packages/vannghia-simple-query-builder/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependenciesVersions (3)Used By (0)

Design pattern phần 3
=====================

[](#design-pattern-phần-3)

Đề bài: Create Query Builder is a simple, methods-chaining dependency-free library to create SQL Queries simple. Supports databases which are supported by PDO

**Người thực hiện** : Vu Van Nghia

**Download và run code** tại đường dẫn [https://github.com/vn0202/demo\_simple\_query\_builder](https://github.com/vn0202/demo_simple_query_builder)

#### install

[](#install)

```
composer require vannghia/simple_query_builder
```

#### Sử dụng

[](#sử-dụng)

- Sử dụng autoload composer
- Cấu hình thông tin database trong `$config`

```
$config = [
    'driver'=>'mysql',
    'host'=>'localhost',
    'dbname'=>'app',
    'username'=>'root',
    'password'=>'root',
];
Connection::$config = $config;
```

**Có thể sử dụng trực tiếp QueryBuilder**

```
 DB::table('tbl_admin')->where(['id','=',20])->get();
```

- Trong thư mục `src\Model`, thêm các file model có cấu trúc như sau:

```