PHPackages                             dframe/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. dframe/database

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

dframe/database
===============

Database pdo wrapper

v2.3.0(2y ago)53.3k23MITPHPPHP >=5.6CI failing

Since Aug 29Pushed 2y ago2 watchersCompare

[ Source](https://github.com/dframe/database)[ Packagist](https://packagist.org/packages/dframe/database)[ Docs](https://dframeframework.com)[ RSS](/packages/dframe-database/feed)WikiDiscussions master Synced today

READMEChangelog (10)Dependencies (1)Versions (20)Used By (3)

Dframe/Database
===============

[](#dframedatabase)

[![Build Status](https://camo.githubusercontent.com/be66318a5484c70fd9994dd788dea19203dfb63918f37f1fe3922cd8f0cede47/68747470733a2f2f7472617669732d63692e6f72672f646672616d652f64617461626173652e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/dframe/database) [![Latest Stable Version](https://camo.githubusercontent.com/33da0d99c4167ddd22355303e4b963ca90ddfb2c9f76a8ffadca3270b00c6b99/68747470733a2f2f706f7365722e707567782e6f72672f646672616d652f64617461626173652f762f737461626c65)](https://packagist.org/packages/dframe/database) [![Total Downloads](https://camo.githubusercontent.com/4bde6ca873e00fcc33989508d897d3d3f87972e393aabf416d15dd2fc86ae6fe/68747470733a2f2f706f7365722e707567782e6f72672f646672616d652f64617461626173652f646f776e6c6f616473)](https://packagist.org/packages/dframe/database) [![Latest Unstable Version](https://camo.githubusercontent.com/cd645b51c46659b6406cef506e836f1731b789ed516ab110bc80bc453801ec52/68747470733a2f2f706f7365722e707567782e6f72672f646672616d652f646672616d652f762f756e737461626c65)](https://packagist.org/packages/dframe/database) [![License](https://camo.githubusercontent.com/cb8e43d055b4d85c6f2f9bfeb124dab013b6e74f429deddb57c12047409fe69b/68747470733a2f2f706f7365722e707567782e6f72672f646672616d652f646672616d652f6c6963656e7365)](https://packagist.org/packages/dframe/dframe)

Dframe **[Documentation](https://dframeframework.com/en/page/index)**

### Installation Composer

[](#installation-composer)

```
$ composer require dframe/database
```

What's included?
----------------

[](#whats-included)

- [MySQL PDO](https://dframeframework.com/en/docs/database/master/configuration)
- [MySQL Query Builder](https://dframeframework.com/en/docs/database/master/query-builder)
- [MySQL WHERE Builder](https://dframeframework.com/en/docs/database/master/chunks)

Methods
-------

[](#methods)

DescriptionnameMySQL querypdoQuery()MySQL select queryselect()MySQL insert queryinsert()MySQL insert batchinsertBatch()MySQL update queryupdate()MySQL delete querydelete()MySQL truncate tabletruncate()MySQL drop tabledrop()MySQL describe tabledescribe()MySQL count recordscount()Show/debug executed queryshowQuery()Get last insert idgetLastInsertId()Get all last insert idgetAllLastInsertId()Get MySQL resultsresults()Get MySQL resultresult()Get status of executed queryaffectedRows()MySQL begin transactionsstart()MySQL commit the transactionend()MySQL rollback the transactionback()Debugger PDO ErrorsetErrorLog()Init Connection
---------------

[](#init-connection)

```