README

Usage

Composer

For the composer, have it like:

composer require myaaghubi/mhm-json-db

Code

    $db = new MHMJsonDB('mydb.json', $pathToDB);

    // select all: array of arrays or an empty array
    var_dump($db->select());

    // select multiple: array of arrays or an empty array
    // sort: $db->select(['name' => 'Moham'], 'name', true);
    var_dump($db->select(['name' => 'Moham']));

    // select one item/array or null
    $result = $db->selectOne(['name' => 'Moham']);

    // returns the whole record as an array
    $insertedRecord = $db->insert(['name' => 'Moham', 'email' => '...']);

    // returns true or false
    $insertedRecord = $db->update(['name' => 'Moham', ...], ['name' => 'Mohammad', ...]);

    // delete multiple: returns the number of deleted
    $deleted = $db->delete(['id' => $insertedRecord['id']]);

    // delete all
    $deleted = $db->delete();

Test

Just run ./vendor/bin/phpunit

License

This project is licensed under an AGPL-3.0 license.