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

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

davahome/database
=================

3.0(2y ago)12.3k[1 issues](https://github.com/DavaHome/database/issues)GPL-3.0-or-laterPHPPHP >=8.1

Since May 24Pushed 2y ago2 watchersCompare

[ Source](https://github.com/DavaHome/database)[ Packagist](https://packagist.org/packages/davahome/database)[ RSS](/packages/davahome-database/feed)WikiDiscussions master Synced 3d ago

READMEChangelog (10)Dependencies (2)Versions (15)Used By (0)

davahome/database
=================

[](#davahomedatabase)

[![Tests](https://github.com/davahome/database/actions/workflows/tests.yml/badge.svg)](https://github.com/davahome/database/actions/workflows/tests.yml)

davahome/database is a small php library which provides a very simple PDO based MySQL wrapper. Its main functionality is to provide some additional functionality to the basic PDO object.

The `DavaHome\Database\Adapter\MySQL` class is directly derived from PDO and provides all of its methods. There are some additional features like:

- **PDO Statement Cache** (Reuse of PDO statements if the query hasn't changed)
- **[Basic operations as methods](#basic-operation-methods)** (Like select, delete, and more)

Installation
============

[](#installation)

```
php composer.phar require davahome/database
```

Basic Operation Methods
=======================

[](#basic-operation-methods)

These methods are forced by the `DavaHome\Database\Adapter\AdapterInterface` and are supported by all database handlers

### select

[](#select)

Select rows from database. The where statement is an associative array with `tableColumn => value` convention.

```
/**
 * Select from database
 *
 * @param string $table
 * @param array  $where
 *
 * @return mixed
 */
public function select(string $table, array $where): mixed;
```

### update

[](#update)

Update existing rows in the database. The values are an associative array, exactly like the `where` statement from the [select](#select) method.

```
/**
 * Update a row
 *
 * @param string $table
 * @param array  $values key=>value
 * @param array  $where  key=>value where condition (will be combined using AND)
 * @param bool   $allowEmptyWhere
 *
 * @return mixed
 * @throws \DavaHome\Database\DatabaseException
 */
public function update(string $table, array $values, array $where, bool $allowEmptyWhere = false): mixed;
```

### insert

[](#insert)

Insert a new row into the database. The values are an associative array, exactly like the `where` statement from the [select](#select) method.

```
/**
 * Insert a new row
 *
 * @param string $table
 * @param array  $values key=>value
 *
 * @return mixed
 */
public function insert(string $table, array $values): mixed;
```

### delete

[](#delete)

Delete existing rows from the database. The where statement is identical to the [select](#select) method.

```
/**
 * Delete from database
 *
 * @param string $table
 * @param array  $where
 * @param bool   $allowEmptyWhere
 *
 * @return mixed
 * @throws \DavaHome\Database\DatabaseException
 */
public function delete(string $table, array $where, bool $allowEmptyWhere = false): mixed;
```

Mysql
=====

[](#mysql)

### Example

[](#example)

```
use DavaHome\Database\Adapter\Mysql;

$db = Mysql::create(
    Mysql::DRIVER_MYSQL,
    'localhost',
    'root',
    '',
    'database',
    [
        Mysql::ATTR_DEFAULT_FETCH_MODE => Mysql::FETCH_ASSOC,
        Mysql::ATTR_AUTOCOMMIT         => 1,
    ]
);

// Select row
$pdoStatement = $db->select('table', ['id' => 1]); // Returns \PDOStatement

// Update row
$pdoStatement = $db->update('table', ['foo' => 'bar'], ['id' => 1]); // Returns \PDOStatement

// Insert row
$pdoStatement = $db->insert('table', ['foo' => 'bar']); // Returns \PDOStatement

// Delete row
$pdoStatement = $db->delete('table', ['id' => 1]); // Returns \PDOStatement
```

### Additional Mysql methods

[](#additional-mysql-methods)

#### createUuid

[](#createuuid)

This method creates a uuid which can be used as non-incremental unique index. See the [MySQL documentation](https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_uuid) for further information.

```
/**
 * Let the database create a UUID
 *
 * @return string
 */
public function createUuid(): string;
```

#### execute

[](#execute)

Creates a prepared statement which will be executed directly

```
/**
 * Create and execute a prepared statement immediately
 *
 * @param string $statement
 * @param array  $inputParameters
 * @param array  $driverOptions
 *
 * @return mixed|\PDOStatement
 */
public function execute($statement, array $inputParameters = [], array $driverOptions = []): PDOStatement;
```

#### setIsolationLevel

[](#setisolationlevel)

Set the isolation level of transactions in the current connection

```
/**
 * Set the isolation level
 *
 * @param string $isolationLevel
 *
 * @return bool
 */
public function setIsolationLevel(string $isolationLevel): bool;
```

Advanced queries
================

[](#advanced-queries)

To provide a more advanced functionality for the basic operation methods there are additional classes.

### DirectValue

[](#directvalue)

The DirectValue class allows to use MySQL functions or a increment-queries through the basic operation methods. All arguments given to the DirectValue class will be passed 1-2-1 into the query. There will be no escaping for those values!

```
use DavaHome\Database\Extension\DirectValue;

// The query will look like this: UPDATE `table` SET `last_updated` = NOW() WHERE `id` = 1
$db->update('table', ['last_updated' => new DirectValue('NOW()')], ['id' => 1]);

// The query will look like this: UPDATE `table` SET `count` = `count` + 1 WHERE `id` = 1
$db->update('table', ['count' => new DirectValue('`count` + 1')], ['id' => 1]);
```

### CustomOperator

[](#customoperator)

The CustomOperator class allows to override the default operator used by all basic operation methods (`=`). You can also combine the CustomOperator with the DirectValue class.

```
use DavaHome\Database\Extension\CustomOperator;

// The query will look like this: SELECT * FROM `table` WHERE `count` >= 2
$db->select('table', ['count' => new CustomOperator('>=', 2)]);

// The query will look like this: SELECT * FROM `table` WHERE `last_updated` select('table', ['last_updated' => new CustomOperator('