ReactPHP MySQL Decorator

A decorator of the ReactPHP MySQL connection interface which augments its behaviour, e.g. providing binding of associative parameters.

Installation

Using Composer:

composer require tonix-tuft/reactphp-mysql-decorator

Usage

Currently, the only available decorator is BindAssocParamsConnectionDecorator, which provides the binding of associative parameters like in standard PHP PDO objects.

BindAssocParamsConnectionDecorator

This decorator allows the binding of associative parameters in queries (named parameters). To use it just wrap a React\MySQL\ConnectionInterface:

<?php

// ...
use React\EventLoop\Factory as LoopFactory;
use React\MySQL\Factory;
use ReactPHP\MySQL\Decorator\BindAssocParamsConnectionDecorator;

// ...
$loop = LoopFactory::create();
$factory = new Factory($loop);

$uri = 'username:password@localhost/dbname';
$connection = $factory->createLazyConnection($uri); // returns a React\MySQL\ConnectionInterface

$connectionWithBindAssocParams = new BindAssocParamsConnectionDecorator($connection);

// Now you can bind associative parameters when you execute your queries.
$value = 123;
$connectionWithBindAssocParams->query('SELECT * FROM table WHERE field = :value', [
   ':value' => $value
])->then(
   // ...
);

Acknowledgements

friends-of-reactphp/mysql - Async MySQL database client for ReactPHP.

License

MIT © Anton Bagdatyev (Tonix)