PHPackages                             melnyin/sql-query-builder-adapter - 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. melnyin/sql-query-builder-adapter

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

melnyin/sql-query-builder-adapter
=================================

SQL Query Builder Adapter (php5.5+, mysql)

1.0(10y ago)126PHPPHP >=5.5.0

Since Dec 16Pushed 10y ago1 watchersCompare

[ Source](https://github.com/melnyin/sql-query-builder-adapter)[ Packagist](https://packagist.org/packages/melnyin/sql-query-builder-adapter)[ RSS](/packages/melnyin-sql-query-builder-adapter/feed)WikiDiscussions master Synced 4w ago

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

SQL Query Builder Adapter
=========================

[](#sql-query-builder-adapter)

support:

- mysql

require:

- php5.5+
- php-pdo

composer install:

```
php composer.phar require melnyin/sql-query-builder-adapter

```

packagist link:

Cookbook:
---------

[](#cookbook)

#### \\MI\\SQL\\QB\\Adapter

[](#misqlqbadapter)

```
$config = [
    'adapter'     => 'mysql',
    'unix_socket' => 'path/to/unix',
    'host'        => 'localhost(127.0.0.1)',
    'username'    => 'root',
    'password'    => 'root',
    'dbname'      => 'root',
    'charset'     => 'utf8',
];

$qbAdapter = new \MI\SQL\QB\Adapter($config);

```

#### \\MI\\SQL\\QB\\Query

[](#misqlqbquery)

```
$qbAdapter = new \MI\SQL\QB\Adapter($config);

$qbAdapter->query("SELECT `foo` FROM `bar`");
$qbAdapter->query("DELETE FROM `foo`");

```

#### \\MI\\SQL\\QB\\Select

[](#misqlqbselect)

Simple example:

```
$qbAdapter = new \MI\SQL\QB\Adapter($config);

$select = $qbAdapter
  ->select()
  ->from('foo')
  ->query();

  SELECT * FROM foo

```

Full example

```
$qbAdapter = new \MI\SQL\QB\Adapter($config);

$select = $qbAdapter
  ->select('f.id', 'f.title', 'b.date', 'b.phone', 'fb.status')
  ->from('foo', 'f')
  ->join('bar', 'b', ['b.id' => 'f.bar_id'], 'INNER')
  ->join('foobar', 'fb', ['fb.id' => 'b.foobar_id'], 'LEFT')
  ->where('fb.status', ':status')
  ->where([
    'f.id  :id',
    'f.title LIKE :title",
  ])
  ->param('status', 'open')
  ->param([
    'id'    => 3,
    'title' => 'happyChild',
  ])
  ->order('f.id', 'DESC')
  ->limit(10)
  ->offset(5)
  ->query();

  SELECT f.id, f.title, b.date, b.phone, fb.status
  FROM foo AS f
  INNER JOIN bar AS b ON b.id = f.bar_id
  LEFT JOIN foobar AS fb ON fb.id = b.foobar_id
  WHERE fb.status = 'open'
    AND f.id  3
    AND f.title LIKE '%happyChild%'
  ORDER BY f.id DESC
  LIMIT 10
  OFFSET 5

```

Select ARRAY Result

```
  $select->toArray();

```

Select OBJECT Result

```
  $select->toObject();

```

Select COUNT Result

```
  $select->count();

```

#### \\MI\\SQL\\QB\\Insert

[](#misqlqbinsert)

```
$qbAdapter = new \MI\SQL\QB\Adapter($config);

$insert = $qbAdapter
  ->insert('foo')
  ->values('status', 'create')
  ->values([
    'title' => 'bar',
    'date' => '2015-12-06',
  ])
  ->query();

  INSERT INTO foo (status, title, date) VALUES ('create', 'bar', '2015-12-06')

```

#### \\MI\\SQL\\QB\\Update

[](#misqlqbupdate)

```
$qbAdapter = new \MI\SQL\QB\Adapter($config);

$update = $qbAdapter
  ->update('foo')
  ->set('title', 'bar')
  ->set([
    'date'    => '2015-12-06',
    'status'  => 'create',
  ])
  ->where('id', 5)
  ->query();

  UPDATE foo SET title = 'bar', date = '2015-12-06', status = 'create' WHERE id = 5

```

#### \\MI\\SQL\\QB\\Delete

[](#misqlqbdelete)

```
$qbAdapter = new \MI\SQL\QB\Adapter($config);

$delete = $qbAdapter
  ->delete()
  ->from('foo')
  ->where('id', 3)
  ->query();

  DELETE FROM foo WHERE id = 3

```

###  Health Score

26

—

LowBetter than 41% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity58

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

Unknown

Total

1

Last Release

3850d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/8bb23b83e22750e3a338b1259153f2ab7e5f111c924c92bbe90a1e1ddc7d0b7d?d=identicon)[emelnychenko](/maintainers/emelnychenko)

---

Top Contributors

[![emelnychenko](https://avatars.githubusercontent.com/u/16197097?v=4)](https://github.com/emelnychenko "emelnychenko (1 commits)")

### Embed Badge

![Health badge](/badges/melnyin-sql-query-builder-adapter/health.svg)

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

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k117.2M117](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

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