Download the PHP package dongm2ez/general-db without Composer
On this page you can find all versions of the php package dongm2ez/general-db. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package general-db
Laravel general-db
:heart: This package helps you smiple CRUD
Requirement
- PHP >= 7.0
Installation
After installing the library, register the Dongm2ez\Db\DbServiceProvider in your config/app.php file:
As optional if you want to modify the default configuration, you can publish the configuration file:
Usage
传值格式
字段{条件}=值
条件不传默认为 = 查询
例子：
id{!}=1,意思为取 id 不等于1的所有
支持查询条件
一元查询
{>} 大于，?pay_money{>}=100
{ge} 大于等于, ?pay_money{ge}=100
{<} 小于, ?pay_money{<}=100
{le} 小于等于, ?pay_money{le}=100
{!} 不等于, ?pay_money{!}=100
{~} like 查询, ?pay_money{~}=100
{!~} not like 查询, ?pay_money{!~}=100
{#} is null 查询, ?delete_at{#}=null,表示delete_at is null
{!#} is not null 查询, ?delete_at{!#}=null,表示delete_at is not null)
二元查询
{<>} between 查询, ?create_date{<>}=2017-10-01,2017-10-02,表示create_date between(2017-10-01,2017-10-02)
{><} not between 查询, ?create_date{><}=2017-10-01,2017-10-02,表示create_date not between(2017-10-01,2017-10-02)
多元查询
订单合单类型在做 {@}、{!@} 查询时使用 ** 表示中间连接符，如 goods,event**goods 表示查询商品与活动和商品合单
{@} in 查询, ?id{@}=1,2,3,4,表示id IN(1,2,3,4)
{!@} not in 查询, ?id{!@}=1,2,3,4,表示id IN(1,2,3,4)
扩展条件
_page 页码，默认1
_limit 分页大小，默认15
_sort 排序字段，默认id
_order 排序方式，默认DESC
_group 分组字段，默认空
_fields 查询字段，默认 *
_type 查询类型，列表默认 page 分页，可选 offset 方式
_version 版本，默认 V1
用法：
?_type=offset&_page=200&_limit=10 偏移量模式，_page 是偏移量，_limit 是取多少
License
MIT
