PHPackages                             aweitian/db-connection - 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. aweitian/db-connection

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

aweitian/db-connection
======================

PDO Connection

2.0.11(7y ago)02384MITPHPPHP >=5.3.0

Since May 28Pushed 7y ago1 watchersCompare

[ Source](https://github.com/aweitian/db-connection)[ Packagist](https://packagist.org/packages/aweitian/db-connection)[ Docs](https://github.com/aweitian/db-connection)[ RSS](/packages/aweitian-db-connection/feed)WikiDiscussions master Synced 2w ago

READMEChangelog (10)Dependencies (1)Versions (15)Used By (4)

PDO Connection组件
================

[](#pdo-connection组件)

安装组件
----

[](#安装组件)

使用 composer 命令进行安装或下载源代码使用。

> composer require aweitian/connection

```
//参数错误出抛出异常
new Aw\Db\Connection\Mysql ( [
	'host' => '127.0.0.1',
	'port' => 3306,
	'user' => 'root',
	'password' => 'root',
	'charset' => 'utf8',
	'database' => 'garri'
] );

```

设置调试模式
------

[](#设置调试模式)

```
/**
 *
 * 设置为TRUE。异常由PDO对象抛出
 * 默认为FALSE，异常由MysqlPdoConn对象抛出
 */
function setDebugMode($mode);

```

连接信息获取
------

[](#连接信息获取)

```
getDbName();  #返回数据库名
getHost();    #返回主机名
getCharset(); #返回连接端口

```

添加记录
----

[](#添加记录)

```
/**
 *
 * 当主键是自增时，返回插入ID,其它返回0
 * 有错误时会抛出异常
 * @param string $sql
 * @param array $data       eg: ['k' => 'v','a' => 'b']
 * @param array $bindType   KEY和DATA一样，值为PDO:PARAM_**
 * @return int
 */
insert($sql, $data = [], $bindType = []);

```

获取一个数据
------

[](#获取一个数据)

```
/**
 *
 * 返回一个标量
 * @param string $sql
 * @param array $data
 * @return mixed;
 */
public function scalar($sql, $data = [], $bindType = [])

```

获取一行数据
------

[](#获取一行数据)

```
/**
 *
 * 返回一维数组,SQL中的结果集中的第一个元组
 * 有错误时会抛出异常
 * @param string $sql
 * @param array $data
 * @return array;
 */
public function fetch($sql, $data = [], $bindType = [], $fetch_mode = \PDO::FETCH_ASSOC)

```

获取表格数据
------

[](#获取表格数据)

```
/**
 *
 * 返回二维数组
 * 有错误时会抛出异常
 * @param string $sql
 * @param array $data
 * @return array;
 */
public function fetchAll($sql, $data = [], $bindType = [], $fetch_mode = \PDO::FETCH_ASSOC)

```

SQL执行操作，可多条语句同时执行
-----------------

[](#sql执行操作可多条语句同时执行)

```
/**
 *
 * 返回影响行数
 * 有错误时会抛出异常
 * @param string $sql
 * @param array $data
 * @param array $bindType
 *        	KEY和DATA一样，值为PDO:PARAM_**
 * @return int
 */
public function exec($sql, $data = [], $bindType = [])

```

事务
--

[](#事务)

```
function transaction(\Closure $closure) #返回对象本身
function beginTransaction() #返回对象本身
function rollback()         #返回对象本身
function commit()           #返回对象本身
function getQueryLog()      #返回对象本身

```

###  Health Score

30

—

LowBetter than 62% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity11

Limited adoption so far

Community13

Small or concentrated contributor base

Maturity66

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 ~43 days

Recently: every ~12 days

Total

13

Last Release

2803d ago

Major Versions

v1.0 → v2.0.02018-01-24

PHP version history (2 changes)v1.0PHP >=5.4.0

v2.0.0PHP >=5.3.0

### Community

Maintainers

![](https://www.gravatar.com/avatar/2f29043b8f5aebb2d7a34302c1bc1626bd711398bb0c5387cd8630b45057a4c9?d=identicon)[awei.tian](/maintainers/awei.tian)

---

Top Contributors

[![aweitian](https://avatars.githubusercontent.com/u/6269615?v=4)](https://github.com/aweitian "aweitian (20 commits)")

---

Tags

dbconnectionaweitiantiananwei

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/aweitian-db-connection/health.svg)

```
[![Health](https://phpackages.com/badges/aweitian-db-connection/health.svg)](https://phpackages.com/packages/aweitian-db-connection)
```

###  Alternatives

[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)

PHPackages © 2026

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