PHPackages                             aweitian/sql-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. aweitian/sql-builder

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

aweitian/sql-builder
====================

SQL QUERY BUILDER

v3.0.2(7y ago)01722MITPHPPHP >=5.3.0

Since Sep 25Pushed 7y ago1 watchersCompare

[ Source](https://github.com/aweitian/sql-builder)[ Packagist](https://packagist.org/packages/aweitian/sql-builder)[ Docs](https://github.com/aweitian/sql-builder)[ RSS](/packages/aweitian-sql-builder/feed)WikiDiscussions master Synced 2d ago

READMEChangelog (10)Dependencies (1)Versions (12)Used By (2)

开始使用
----

[](#开始使用)

#### 安装组件

[](#安装组件)

使用 composer 命令进行安装或下载源代码使用。

> composer require aweitian/sql-builder

### select :

[](#select-)

```

$demo = new Crud ( 'tablename' );
$demo->bindField ( "id" );
$demo->bindField ( "concat('%',:lol,'%')" );
$demo->bindField ( "name as n" );
//SELECT id,concat('%',:lol,'%'),name as n FROM tablename

$demo = new Crud ( 'tablename' );
$demo->bindField ( "id" );
$demo->bindField ( "concat('%',:lol,'%')" );
$demo->bindField ( "name as n" );
$demo->bindJoin ( 'left join tba on tba.sid = tablename.hid' );
$demo->bindJoin ( 'left join tbb on tba.sid = tbb.sid' );
$demo->bindWhere ( 'tablename.sid > 100' );
$demo->bindWhere ( 'tablename.name = \'55\'' );
//SELECT id,concat('%',:lol,'%'),name as n FROM tablename
//left join tba on tba.sid = tablename.hid left join tbb on tba.sid = tbb.sid
//WHERE tablename.sid > 100 AND tablename.name = '55'

$demo = new Crud ( 'tablename' );
$demo->bindField ( "id" );
$demo->bindField ( "concat('%',:lol,'%')" );
$demo->bindField ( "count(tablename.name) as cc" );
$demo->bindJoin ( 'left join tba on tba.sid = tablename.hid' );
$demo->bindJoin ( 'left join tbb on tba.sid = tbb.sid' );
$demo->bindWhere ( 'tablename.sid > 100' );
$demo->bindWhere ( 'tablename.name = \'55\'' );
$demo->bindGroupBy ( 'tablename.name' );
$demo->bindHaving ( 'cc > 1' );
$demo->bindLimit ( '0,100' );
//SELECT id,concat('%',:lol,'%'),count(tablename.name) as cc
//FROM tablename left join tba on tba.sid = tablename.hid
//left join tbb on tba.sid = tbb.sid WHERE tablename.sid > 100 AND tablename.name = '55'
//GROUP BY tablename.name HAVING cc > 1 LIMIT 0,100

```

### INSERT:

[](#insert)

``

```
$demo = new Crud ('tablename');
$demo->bindField('aaa');
$demo->bindField('bbb', 'bbb');
$demo->bindValues("concat('aa>',:bbb,'',:bbb,'',:bbb,'',:bbb,'',:bbb,'100' );
$demo->bindOrderBy ( 'name desc' );
$demo->bindLimit ( '2' );
//UPDATE tablename SET aaa=:aaa,bbb=concat('aa>',:bbb,'100' );
$demo->bindOrderBy ( 'name desc' );
$demo->bindLimit ( '2' );
//DELETE FROM tablename WHERE sid>100 ORDER BY name desc LIMIT 2

```$demo = new \Tian\SqlBuild\MysqlDeleteBuild ( 'tablename,tb2' );
$demo->bindUsing ( 'tb2' );
$demo->bindWhere ( 'tablename.sid>100' );
$demo->bindWhere ( 'tablename.sid = tb2.tb1id' );
$demo->bindOrderBy ( 'name desc' ); // 多表删除中无效
$demo->bindLimit ( '2' ); // 多表删除中无效
//DELETE FROM tablename,tb2 USING tb2 WHERE tablename.sid>100 AND tablename.sid = tb2.tb1id

```

###  Health Score

29

—

LowBetter than 59% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity10

Limited adoption so far

Community11

Small or concentrated contributor base

Maturity65

Established project with proven stability

 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 ~6 days

Recently: every ~14 days

Total

10

Last Release

2911d ago

Major Versions

v2.1.7 → v3.0.02018-05-07

### Community

Maintainers

![](https://www.gravatar.com/avatar/2f29043b8f5aebb2d7a34302c1bc1626bd711398bb0c5387cd8630b45057a4c9?d=identicon)[awei.tian](/maintainers/awei.tian)

---

Top Contributors

[![aweitian](https://avatars.githubusercontent.com/u/6269615?v=4)](https://github.com/aweitian "aweitian (26 commits)")

---

Tags

SQL Builderaweitiantiananwei

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/aweitian-sql-builder/health.svg)

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

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[mongodb/mongodb

MongoDB driver library

1.6k64.0M546](/packages/mongodb-mongodb)[tommyknocker/pdo-database-class

Framework-agnostic PHP database library with unified API for MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, and Oracle. Query Builder, caching, sharding, window functions, CTEs, JSON, migrations, ActiveRecord, CLI tools, AI-powered analysis. Zero external dependencies.

845.7k](/packages/tommyknocker-pdo-database-class)[orchestra/database

Database Component for Orchestra Platform

201.4M578](/packages/orchestra-database)[popphp/pop-db

Pop Db Component for Pop PHP Framework

1814.6k11](/packages/popphp-pop-db)[hemiframe/php-query-builder

Powerful and lightweight PHP SQL Query Builder

1018.2k](/packages/hemiframe-php-query-builder)

PHPackages © 2026

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