Download the PHP package hehex/hehep-horm without Composer

On this page you can find all versions of the php package hehex/hehep-horm. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

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 PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • 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.
Please rate this library. Is it a good library?

Example code of hehex/hehep-horm

Informations about the package hehep-horm

hehep-horm

介绍

安装

基础配置

数据库

基本示例

CURD 操作

常规查询操作

执行原始命令

预定义功能(scope)

其他设置方法

asQuery 方法

asId 方法

setLimit,setOffset

setDistinct

setParam 设置预定义参数

设置方法

方法 说明
setWhere 设置查询条件
setAndWhere 设置查询and条件
setOrWhere 设置查询and条件
setScope 设置scope作用域
asArray 查询以数组形式返回
asQuery 返回Query对象
asId 返回自增id
setTable 设置表名
setJoin 设置连表
setLeftJoin 设置Left连表
setInnerJoin 设置Inner连表
setWith 设置关系
setLeftWith 设置Left关系
setInnerWith 设置Inner关系
setOrder 设置查询排序
setParam 设置参数
setField 设置查询读取字段
setAlias 设置当前表别名
setUnion 设置联合查询
setLimit 设置影响条数
setDistinct 取消重复行
setGroup 设置分组查询
setHaving 设置分组查询条件
setAndHaving 设置分组查询and条件
setOrHaving 设置分组查询or条件

表达式表

表达式 说明 示例
eq =,等于 $where = ['id'=>['eq',9]]
neq !=,不等于 $where = ['id'=>['neq',9]]
gt >,大于 $where = ['id'=>['gt',9]]
egt >=,大于等于 $where = ['id'=>['egt',9]]
lt <,小于 $where = ['id'=>['lt',9]]
elt <=,小于等于 $where = ['id'=>['elt',9]]
like like 模糊查询 $where = ['tel'=>['like','%135%']]
notlike not like 模糊查询 $where = ['tel'=>['notlike','%135%']]
in in 查询 $where = ['id'=>['in',[8,9]]]
notin not in 查询 $where = ['id'=>['notin',[8,9]]]
exp 原始字符串 $where = ['id'=>['exp','=9']] sql:id =9
raw 原始字符串(用于连表) ['u.UserName'=>['raw','t.UserName']](u.UserName = t.UserName), ['id'=>['raw','9']](id = 9);
inc 字段递增 $data = ['id'=>['inc',1]] sql:id = id + 1
dec 字段递减 $data = ['id'=>['dec',1]] sql:id = id - 1

别名设置及引用

连表关联查询(join)

with关联查询

分组查询(group)

子查询(subQuery)

聚合查询(scalar)

联合查询(Union)

事务操作(transaction)

分表分库

分表

分库

分库分表

DB连接操作模式

数据表(queryTable)操作模式

主从数据库

全库读写分离

单表读写分离

连接池

线程安全

All versions of hehep-horm with dependencies

PHP Build Version
Package Version
Requires php Version >=7.1
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package hehex/hehep-horm contains the following files

Loading the files please wait ....