PHPackages                             suvarivaza/easy-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. suvarivaza/easy-query-builder

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

suvarivaza/easy-query-builder
=============================

It is a easy query builder that includes basic methods for working with a database

1.1.0(5y ago)16MITPHP

Since Aug 13Pushed 5y ago1 watchersCompare

[ Source](https://github.com/suvarivaza/easy-query-builder)[ Packagist](https://packagist.org/packages/suvarivaza/easy-query-builder)[ Docs](https://github.com/suvarivaza/easy-query-builder)[ RSS](/packages/suvarivaza-easy-query-builder/feed)WikiDiscussions master Synced yesterday

READMEChangelog (1)DependenciesVersions (3)Used By (0)

EasyQueryBuilder
================

[](#easyquerybuilder)

**About**

It is a easy query builder that includes basic methods for working with a database: SELECT, INSERT, UPDATE, DELETE. If you need a simple query builder to safely work with a database, then this component is what you need.

**Dependencies:**

This Query Builder has no dependencies except PHP 5.6, \\MySQLi extension and PDO.

**Safety:**

In all requests used by PDO API and prepared queries.

**Installation**

This is a Composer package. You can install this package with the following command: **composer require suvarivaza/easy-query-builder**

**Usage**

```
use Suvarivaza\QB\EasyQueryBuilder;

```

**Connection**

The connection to the database occurs automatically when a new object of the EasyQueryBuilder class is created. Just pass an array with your database connection data to the EasyQueryBuilder class constructor when creating a new object.

Example:

```
$config = ['driver' => 'mysql', // Db driver
'host' => 'localhost',
'db_name' => 'your-database',
'db_user' => 'root',
'db_password' => 'your-password',
'charset' => 'utf8', // Optional
'prefix' => 'cb_', // Table prefix, optional
'options' => [ // PDO constructor options, optional
PDO::ATTR_TIMEOUT => 5,
PDO::ATTR_EMULATE_PREPARES => false,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
],
];

```

```
$db = new EasyQueryBuilder($config); // Create a connection

```

**SELECT**

```
$select = $db->select('column_one', 'colume_two')->from('table')->where('username', '=', 'anna');

```

Method SELECT gets the arguments passed as $db->select('one', 'two') Using it without arguments equals to having '\*' as argument Using it with array maps values as column names

Examples:

```
$db->select();
// SELECT *

$db->select('title');
// SELECT title

$db->select('title', 'author', 'date');
// SELECT title, author, date

$db->select(['id', 'title']);
// SELECT id, title

```

The **FROM method** takes a table name as a parameter.

The **WHERE method** takes three parameters: key, operator and value. Gets the arguments passed as $query->where('column', 'operator', 'value') Used in: SELECT, UPDATE, DELETE

Examples:

```
$query->where('name', '=', 'Jacob');
// WHERE 'name' = 'Jacob'

$query->where('id', '>=', '2')
// WHERE id >= 2

```

Operator supports: '=', '<', '>', '<=', '>='

Methods **RESULT** and **RESULTS** gets the argument fatch data type. You can take data in format as supports PDO:

```
'assoc' = PDO::FETCH_ASSOC
'obj' = PDO::FETCH_OBJ
'both' = PDO::FETCH_BOTH
'num' = PDO::FETCH_NUM

```

Examples:

```
$result = $select->getResult('assoc'); // one result as an associative array
$results = $select->getResults('obj'); // all results as an object

```

**INSERT**

```
$db->insert('table')->set([
        'column1' => 'value',
        'column2' => 'value'
    ]);

```

The INSERT method takes a table name as a parameter.

The SET method takes as a parameter an associative array with keys as columns and values as the value for the corresponding column. Used in: INSERT, UPDATE

**UPDATE**

The UPDATE method takes a table name as a parameter.

```
$db->update('table')->set([
       'column1' => 'value',
       'column2' => 'value'
    ])->where('id', '=', '1');

```

**DELETE**

The DELETE method takes a table name as a parameter.

```
$db->delete('table')->where('id', '=', '1');

```

###  Health Score

25

—

LowBetter than 37% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity6

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity56

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~0 days

Total

2

Last Release

2098d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/86c1deb65852e768ca5dbfca38ff99f2f23f1d0ea215a460a5444e13368e9c2b?d=identicon)[suvarivaza](/maintainers/suvarivaza)

---

Top Contributors

[![suvarivaza](https://avatars.githubusercontent.com/u/60654614?v=4)](https://github.com/suvarivaza "suvarivaza (16 commits)")

---

Tags

databasesqlquery builder

### Embed Badge

![Health badge](/badges/suvarivaza-easy-query-builder/health.svg)

```
[![Health](https://phpackages.com/badges/suvarivaza-easy-query-builder/health.svg)](https://phpackages.com/packages/suvarivaza-easy-query-builder)
```

###  Alternatives

[usmanhalalit/pixie

A lightweight, expressive, framework agnostic query builder for PHP.

6872.2M15](/packages/usmanhalalit-pixie)[foolz/sphinxql-query-builder

A PHP query builder for SphinxQL and ManticoreQL with MySQLi and PDO drivers.

3232.2M32](/packages/foolz-sphinxql-query-builder)[cycle/database

DBAL, schema introspection, migration and pagination

64690.9k31](/packages/cycle-database)[opis/database

A database abstraction layer over PDO, that provides a powerful and intuitive query builder, bundled with an easy to use schema builder

10184.2k3](/packages/opis-database)[jasny/persist-sql-query

SQL Query builder and parser

33486.0k4](/packages/jasny-persist-sql-query)[mrjgreen/database

Expressive Database Layer for PHP - Based on Illuminate/Database

5347.8k10](/packages/mrjgreen-database)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)