Download the PHP package chengf28/dbquery without Composer
On this page you can find all versions of the php package chengf28/dbquery. 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 dbquery
注意! master或其他分支持续更新中，可能存在bug。请下载 releases 或 composer 安装到您的项目中;
Note! The master or branches are constantly being updated and may be buggy. Download releases or install by composer for your project please;
DBquery
简单的MySql查询构造器
A simple Mysql query builder
BUG反馈及建议
github issues: https://github.com/chengf28/DBquery/issues
添加 Install
- composer:
直接在项目根目录中执行composer require chengf28/dbquery , 即可加载最新版本到本地项目vender/chengf28目录中(如果目录中没有composer.json 会自动生成)
execute composer require chengf28/dbquery command in terminal;
或者在项目中的composer.json 添加
or add configure in composer.json
然后执行 composer update
the execute composer update
- git:
用法 Usage:
配置 Config:
此处仅供参数,具体配置内容以实际需求为准; 全局调用一次即可
- 基本配置 Base Configure
-
读写分离 Reading and writing separation
-
读写分离,部分配置相同
读写分离时 DQL 会直接操作
read库, DML及DDL 会 操作wirte库 可以使用 useWrite() 及 useRead() 强制操作wirte或read库 - 多个数据库
只需要再配置数组中添加key connects 关键字,然后将多个数据库配置(索引数组或者关联数组)为值,默认会使用配置的第一个,可以是用DBquery::connect()进行数据库操作的切换;如果配置填入的是关联数组,则传入connect()你需要切换的配置的key,如果是索引数组则传入索引位置即可;
配置可选参数
默认的数据集格式是PDO::FETCH_OBJ即每个row都是一个object对象,可以通过DBquery::setDataType()方法来修改获取的数据集类型,可以传入DBquery::arr获取DBquery::obj来修改数据集类型,也可以传入PDO::FETCH_*当然,你可以通过在$config中添加datatype在参数配置阶段进行设置;
同样的可以在配置中提前设置表前缀
一般在 config array中添加 prefix 字段 可以自动设置,但是依旧可以强制重写
