PHPackages                             jesperoestergaardjensen/mydb - 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. jesperoestergaardjensen/mydb

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

jesperoestergaardjensen/mydb
============================

The lightweight ORM for MySql and MariaDB

v0.0.6(5y ago)0371MITPHPPHP ^7.1

Since Sep 18Pushed 3y agoCompare

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

READMEChangelogDependencies (4)Versions (10)Used By (1)

[![Source Code](https://camo.githubusercontent.com/94410a1298690a749ee16d8cf9454ab5deab766e73f3ba70089482146b3c0b0a/687474703a2f2f696d672e736869656c64732e696f2f62616467652f736f757263652d616e64792d2d61612f6d7964622d626c75652e7376673f7374796c653d666c61742d737175617265)](https://github.com/andy-aa/mydb)[![Build Status](https://camo.githubusercontent.com/e057cd30770f9b4e43b0ebe8679996e9ceeac6519c090f5b4f96f329d25928c9/68747470733a2f2f7472617669732d63692e636f6d2f616e64792d61612f6d7964622e7376673f6272616e63683d6d6173746572)](https://travis-ci.com/andy-aa/mydb)[![License: MIT](https://camo.githubusercontent.com/c2bffd81d308ced1cc3b0d66fb0ed453ab478a5e17c988b780f9de986a390ee2/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4c6963656e73652d4d49542d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](https://opensource.org/licenses/MIT)[![Minimum PHP Version](https://camo.githubusercontent.com/dcd4b4aec2c1709157fa6a2c050f709d75cde9552a79cfff0b70a97fad7281ae/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7068702d253345253344253230372e312d3838393242462e7376673f7374796c653d666c61742d737175617265)](https://php.net/)[![Packagist](https://camo.githubusercontent.com/f8ffe8a32516bbb0f0642882960c58c003c3f0043b51512177b4a129caffacc2/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f767072652f7465786c61622f6d7964622e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/texlab/mydb)[![PHPStan](https://camo.githubusercontent.com/fff00cebb924e124a7335e6bd8ca8f8cf38869463c1654eff45d0939f1f21c57/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5048505374616e2d6c6576656c253230382d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](https://phpstan.org/)[![Psalm](https://camo.githubusercontent.com/27e0deaa1b19277e35a3fd644a6af988ef5e84f86a3e40c6fb34f3d6db788165/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5073616c6d2d4c6576656c253230322d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](https://psalm.dev/)[![Coverage Status](https://camo.githubusercontent.com/3853fe8e6b9206bc591e3986a3797f62c22cee328bdbd7383b7ffcebaafd1f10/68747470733a2f2f696d672e736869656c64732e696f2f636f766572616c6c732f6769746875622f616e64792d61612f6d7964622f6d61737465722e7376673f7374796c653d666c61742d737175617265)](https://coveralls.io/github/andy-aa/mydb?branch=master)

MyDB
====

[](#mydb)

- [Install](#install-via-composer)
- [Class diagram](#class-diagram)
- [Database for examples](#database-for-examples)
- [Usage example](#usage-example)
- [CRUD](#crud)
    - [Adding data](#adding-data)
    - [Reading data](#reading-data)
    - [Updating data](#updating-data)
    - [Data deletion](#data-deletion)
- [Query builder](#query-builder)
- [Error handling](#error-handling)
- [Pagination](#pagination)

Install via composer
--------------------

[](#install-via-composer)

Command line

```
composer require texlab/mydb

```

Example **composer.json** file

```
{
    "require": {
        "texlab/mydb": "^0.0.5"
    }
}

```

Class diagram
-------------

[](#class-diagram)

[![Class diagram](https://user-images.githubusercontent.com/46691193/73173964-abc3a380-4117-11ea-99b1-9424892a2fcd.png)](https://user-images.githubusercontent.com/46691193/73173964-abc3a380-4117-11ea-99b1-9424892a2fcd.png)[![Class diagram](https://user-images.githubusercontent.com/46691193/73174260-5b991100-4118-11ea-8fff-eab60f969af9.png)](https://user-images.githubusercontent.com/46691193/73174260-5b991100-4118-11ea-8fff-eab60f969af9.png)

Database for examples
---------------------

[](#database-for-examples)

```
CREATE DATABASE IF NOT EXISTS `mydb`;

USE `mydb`;

CREATE TABLE IF NOT EXISTS `table1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
```

[![Database for examples](https://user-images.githubusercontent.com/46691193/73180546-8b4f1580-4126-11ea-85c8-e75731668e7a.png)](https://user-images.githubusercontent.com/46691193/73180546-8b4f1580-4126-11ea-85c8-e75731668e7a.png)

Usage example
-------------

[](#usage-example)

```