inanepain / db
数据库任务和查询构建的一些辅助工具。
0.1.0
2022-07-26 17:09 UTC
Requires
- php: >=8.1
- inanepain/stdlib: * || dev-master || dev-develop
This package is auto-updated.
Last update: 2024-09-17 15:44:17 UTC
README
()
数据库任务和查询构建的一些辅助工具。
内容
- Parser\ObjectParser
- ArrayUtil
- 高亮
- 图标
- 选项
安装
composer require inanepain/db
用法
$qb = new SQLQueryBuilder(); $query = $qb ->select('users', ['name', 'email', 'password']) ->where('age', 18, '>') ->where('age', 30, '<') ->limit(10, 20); echo "-- Testing MySQL query builder:\n"; echo $qb->getSQLFor(new MysqlQueryBuilder()); echo "\n\n"; echo "-- Testing PostgresSQL query builder:\n"; echo $qb->getSQLFor(new PostgresQueryBuilder());
这将为您提供
-- Testing MySQL query builder: SELECT name, email, password FROM users WHERE age > 18 AND age < 30 LIMIT 10, 20; -- Testing PostgresSQL query builder: SELECT name, email, password FROM users WHERE age > 18 AND age < 30 LIMIT 10 OFFSET 20;