khr/react-mysql

Asynchronous & non-blocking MySQL driver for React.PHP

AsyncMysql

Asynchronous & non-blocking MySQL driver for React.PHP., _(*1)

Install

Add this crap to your composer.json:, _(*2)

{
  "require": {
    "khr/react-mysql": "*"
  }
}

Usage

Create instance of AsyncMysql and call method query. It returns Promise of mysqli_result that will be resolved imediately after query completes., _(*3)

<?php

$loop = React\EventLoop\Factory::create();

$makeConnection = function () {
  return mysqli_connect('localhost', 'user', 'pass', 'dbname');
};

$mysql = new \KHR\React\Mysql\Client($loop, new \KHR\React\Mysql\Pool(function(){
    return mysqli_connect('127.0.0.1', 'root', '', 'test');
}, 10));
$mysql->query('select * from ponies_and_unicorns')->then(
  function ($result) { writeHttpResponse(json_encode($result->all())); },
  function ($error)  { writeHeader500(); }
);