ponup/sql-builders

用于简化PHP中动态构建SQL语句的库

维护者

详细信息

github.com/Ponup/php-sql-builders

源代码

问题

安装数量: 1,031

依赖者: 0

建议者: 0

安全性: 0

星标: 0

关注者: 0

分支: 0

公开问题: 0

1.1.0 2021-12-15 21:54 UTC

Requires (Dev)

LGPL-3.0-or-later b35368fa849dc9a0a0d53f7ea06e64ccddd1501f

  • Santiago Lizardo <santiagolizardo.woop@users.noreply.github.com>

This package is auto-updated.

Last update: 2024-09-16 04:37:03 UTC

README

codecov

PHP SQL builders

一个简单的PHP库，用于动态构建SQL语句。

用法

composer require ponup/sql-builders

示例

插入

$queryBuilder = new InsertQueryBuilder('table');
$queryBuilder->setColumns('foo, bar, baz');

echo $queryBuilder->toSql(); # Prints 'INSERT INTO table (foo, bar, baz) VALUES (?, ?, ?)'

选择

$queryBuilder = new SelectQueryBuilder('foo');
$queryBuilder->setColumns('bar, baz');
$queryBuilder->setLimit('0, 20');
$queryBuilder->setOrderBy('bar DESC');

echo $queryBuilder->toSql(); # Prints 'SELECT bar, baz FROM foo ORDER BY bar DESC LIMIT 0, 20'

更新

$queryBuilder = new UpdateQueryBuilder('person');
$queryBuilder->setColumnValues([
    'email' => 'NULL',
    'age' => 42,
    'weight' => 100,
    'code' => '?'
]);
$queryBuilder->setWhereConditions('id = ?');

echo $queryBuilder->toSql(); # Prints 'UPDATE person SET email = NULL, age = 42, weight = 100, code = ? WHERE id = ?'

删除

$subject = new DeleteQueryBuilder('foo');
echo $subject->toSql(); # Prints 'DELETE FROM foo WHERE id = ?'