Reactphp-ORM

A database ORM for reactphp based on illuminate/database and react/mysql

Project Information

Installation

Use php package manager composer to install reactphp-orm.

composer require basttyy/reactphp-orm

Usage

<?php
//import
require './vendor/autoload.php';

use Basttyy\ReactphpOrm\Wrapper;use React\MySQL\Factory;use React\MySQL\QueryResult;

#create react/mysql factory
$factory = new Factory();

#create qbuilder connection object
$connection = (new Wrapper($factory, 'root:123456789@localhost/react-database'))->createLazyConnection();

#run an insert query
$values = [
    'username' => 'johndoe',
    'firstname' => 'john',
    'lastname' => 'doe',
    'email' => 'johndoe@mail.com'
];

$connection->from('users')->insert($values)->then(
    function (bool $status) {
        echo "inserted successfully ".PHP_EOL;
    },
    function (Exception $ex) {
        echo $ex->getMessage().PHP_EOL;
    }
);

#run a select where query
$connection->from('users')->where('status', 'active')->query()->then(
    function (QueryResult $command) {
        print_r($command->resultRows);
        echo count($command->resultRows) . ' row(s) in set' . PHP_EOL;
    },
    function (Exception $error) {
        echo 'Error: ' . $error->getMessage() . PHP_EOL;
    }
);

#run a get query
$connection->from('users')->where('status', 'active')->get()->then(
    function(Collection $data) {
        print_r($data->all());
        echo $data->count() . ' row(s) in set' . PHP_EOL;
    },
    function (Exception $error) {
        echo 'Error: ' . $error->getMessage() . PHP_EOL;
    }
);

Query Features Coverage Map

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.

License

MIT