PHPackages                             nvh/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. nvh/simple\_query\_builder

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

nvh/simple\_query\_builder
==========================

simple query builder

00PHP

Since Nov 2Pushed 3y ago1 watchersCompare

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

READMEChangelogDependenciesVersions (1)Used By (0)

Create Query Builder is a simple, methods-chaining dependency-free library to create SQL Queries simple. Supports databases which are supported by PDO -> có thể hiểu là phần Model trong mô hình MVC
========================================================================================================================================================================================================

[](#create-query-builder-is-a-simple-methods-chaining-dependency-free-library-to-create-sql-queries-simple-supports-databases-which-are-supported-by-pdo---có-thể-hiểu-là-phần-model-trong-mô-hình-mvc)

by: Nhữ Việt Hoàng

method chaining sẽ trả về một object (thường là chính object Class chứa method đó) khiến ta có thể gọi method nối tiếp mà không cần phải xuống dòng
---------------------------------------------------------------------------------------------------------------------------------------------------

[](#method-chaining-sẽ-trả-về-một-object-thường-là-chính-object-class-chứa-method-đó-khiến-ta-có-thể-gọi-method-nối-tiếp-mà-không-cần-phải-xuống-dòng)

composer require nvh/simple\_query\_builder
-------------------------------------------

[](#composer-require-nvhsimple_query_builder)

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

```
$config = [
    'driver'=>'mysql',
    'host'=>'localhost',
    'dbname'=>'kinh.mat',
    'username'=>'root',
    'password'=>'12345',
];
```

```
Connection::$config = $config;

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

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

    Trong thư mục test thêm các file model có cấu trúc như sau: