PHPackages                             keenlysoft/database - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. keenlysoft/database

ActiveComposer[Database & ORM](/categories/database)

keenlysoft/database
===================

database is keen Framework core file

1.27(5y ago)2521MITPHPPHP ^7.0

Since Jul 20Pushed 5y agoCompare

[ Source](https://github.com/keenlysoft/database)[ Packagist](https://packagist.org/packages/keenlysoft/database)[ RSS](/packages/keenlysoft-database/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (9)DependenciesVersions (13)Used By (1)

如何使用Keenly database ORM 目前只支持mysql 连接库

查找
==

[](#查找)

##### 一个简单的查找

[](#一个简单的查找)

```
model::find(['id'])->where(['name'=>'keenly'])->one(); #获取一条数据
```

```
model::find(['id'])->where(['name'=>'keenly'])->all(); #获取多条数据
```

keenly database 返回结果集以数组方式返回

##### 介绍条件语句

[](#介绍条件语句)

方法使用描述inwhereinwhere('filed',\['q','b'\])参数1：字段，参数2：数组或者字符串pwherepwhere(\['id'=>'100','name'=>'ssc'\])参数1：数组pwherepwhere('<',\['id'=>'100','name'=>'ssc'\])参数1：运算符，参数2：数组pwherepwhere(">",\['id'=>'100','name'=>'ssc'\],'and')参数1：运算符，参数2：数组,参数3：and orlikeWherelikewhere('field','name','a')left = l , right = r , all = a更新
==

[](#更新)

```
$user = new user();
$user->Update($data,$where,flase); #更新数据
```

参数1参数2参数3更新值条件语句如果是true 表示预处理语句更新 false 非预处理语句更新数据```
# 使用主键值更新
$user = new user($id);
$user->name = 'jack_yang';
$user->save();
```

添加
==

[](#添加)

```
$user = new user();
$user->add($data); #添加数据
```

参数1\['name'=>'yang','age'=>18```
#使用AR添加 预处理模式
$user = new user();
$user->name = 'jack_yang';
$user->save();
```

删除
==

[](#删除)

```
#删除条件以数组方式或字符串方式传参
$user = new User();
$user->Delete(['id'=>1,'name'=>'ccc']);

```

返回SQL
=====

[](#返回sql)

```
model::find(['id'])->where(['name'=>'keenly'])->all(false) #all()或者 one()参数为FALSE
```

求总数
===

[](#求总数)

```
model::find('id')->where(['name'=>'keenly'])->count(); # 返回结果 int 整数
```

判断是否存在
======

[](#判断是否存在)

```
model::find('id')->where(['name'=>'keenly'])->exist(); #返回结果 bool
```

判断是否存在
======

[](#判断是否存在-1)

```
model::find('id')->where(['name'=>'keenly'])->exist(); #返回结果 bool
```

返回 top 10
=========

[](#返回-top-10)

```
model::find('id')->where(['name'=>'keenly'])->top(10); #返回数组
```

计数器
===

[](#计数器)

```
user::UpdateCounter(['name'=>2],['id'=>2]); ##参数1 字段=>2 or -2 参数2：where 语句
```

切换数据库
=====

[](#切换数据库)

```
User::SwitchDB('test'); # test 是database 配置里面连接的数据库名称
$user = User::find()->where([])->all();
User::InitDB();
```

事务
==

[](#事务)

### 开启事务

[](#开启事务)

```
$user = new user;
$user->begin();

```

### 检查是否在一个事务内

[](#检查是否在一个事务内)

```
$user = new user;
$user->InTransaction();

```

### 提交事务

[](#提交事务)

```
$user = new user;
$user->commit();

```

### 回滚事务

[](#回滚事务)

```
$user = new user;
$user->back();

```

###  Health Score

28

—

LowBetter than 54% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity11

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity64

Established project with proven stability

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~76 days

Recently: every ~146 days

Total

11

Last Release

2087d ago

PHP version history (2 changes)1.0.1PHP ^5.3.3 || ^7.0

1.2PHP ^7.0

### Community

Maintainers

![](https://www.gravatar.com/avatar/ebf036a2f870fd56c726461c5da15ef8e8769fd7edd6ea9ac278d5f53b98324c?d=identicon)[brain\_yang](/maintainers/brain_yang)

---

Top Contributors

[![keenlysoft](https://avatars.githubusercontent.com/u/38453834?v=4)](https://github.com/keenlysoft "keenlysoft (39 commits)")

---

Tags

keenlykeenly database

### Embed Badge

![Health badge](/badges/keenlysoft-database/health.svg)

```
[![Health](https://phpackages.com/badges/keenlysoft-database/health.svg)](https://phpackages.com/packages/keenlysoft-database)
```

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.3k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M542](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90340.3M209](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)