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

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

badtomcat/connection
====================

PDO Connection

v0.0.1(8y ago)0631MITPHPPHP >=5.4.0

Since Dec 14Pushed 8y agoCompare

[ Source](https://github.com/badtomcat/connection)[ Packagist](https://packagist.org/packages/badtomcat/connection)[ Docs](https://github.com/badtomcat/connection)[ RSS](/packages/badtomcat-connection/feed)WikiDiscussions master Synced yesterday

READMEChangelog (1)Dependencies (2)Versions (2)Used By (1)

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

[](#pdo-connection组件)

安装组件
----

[](#安装组件)

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

> composer require badtomcat/connection

```
//参数错误出抛出异常
new Badtomcat\Db\Connection\MysqlPdoConn ( [
	'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

23

—

LowBetter than 26% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity48

Maturing project, gaining track record

 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

Unknown

Total

1

Last Release

3120d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/33171263?v=4)[badtomcat](/maintainers/badtomcat)[@badtomcat](https://github.com/badtomcat)

---

Top Contributors

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

---

Tags

dbconnectiontiananweibadtomcat

###  Code Quality

TestsPHPUnit

### Embed Badge

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

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

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k116.5M113](/packages/jdorn-sql-formatter)[propel/propel1

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

8351.6M87](/packages/propel-propel1)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

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