library jsondb

jajo/jsondb

A PHP Class that reads JSON file as a database. Use for sample DBs

php-jsondb

A PHP Class that reads JSON file as a database. Use for sample DBs., _(*1)

Usage

Install package composer require jajo/jsondb, _(*2)

Initialize

<?php 
use Jajo\JSONDB;
$json_db = new JSONDB( __DIR__ ); // Or passing the directory of your json files with no trailing slash, default is the current directory. E.g.  new JSONDB( '/var/www/html/json_files' )

Inserting

Insert into your new JSON file. Using users.json as example here, _(*3)

NB: Columns inserted first will be the only allowed column on other inserts, _(*4)

<?php
$json_db->insert( 'users.json', 
    [ 
        'name' => 'Thomas', 
        'state' => 'Nigeria', 
        'age' => 22 
    ]
);

Get

Get back data, just like MySQL in PHP, _(*5)

All columns:

<?php
$users = $json_db->select( '*' )
    ->from( 'users.json' )
    ->get();
print_r( $users );

Custom Columns:

<?php 
$users = $json_db->select( 'name, state'  )
    ->from( 'users.json' )
    ->get();
print_r( $users );

Where Statement:

This WHERE works as AND Operator at the moment or OR, _(*6)

<?php 
$users = $json_db->select( 'name, state'  )
    ->from( 'users.json' )
    ->where( [ 'name' => 'Thomas' ] )
    ->get();
print_r( $users );

// Defaults to Thomas OR Nigeria 
$users = $json_db->select( 'name, state'  )
    ->from( 'users.json' )
    ->where( [ 'name' => 'Thomas', 'state' => 'Nigeria' ] )
    ->get();
print_r( $users );  

// Now is THOMAS AND Nigeria 
$users = $json_db->select( 'name, state'  )
    ->from( 'users.json' )
    ->where( [ 'name' => 'Thomas', 'state' => 'Nigeria' ], 'AND' )
    ->get();
print_r( $users );      

Where Statement with regex:

By passingJSONDB::regex to where statement, you can apply regex searching. It can be used for implementing LIKE or REGEXP_LIKE clause in SQL., _(*7)

$users = $json_db->select( 'name, state' )
    ->from( "users" )
    ->where( array( "state" => JSONDB::regex( "/ria/" )), JSONDB::AND )
    ->get();
print_r( $users );
// Outputs are rows which contains "ria" string in "state" column. 

Order By:

Thanks to Tarun Shanker for this feature. By passing the order_by() method, the result is sorted with 2 arguments of the column name and sort method - JSONDB::ASC and JSONDB::DESC, _(*8)

<?php 
$users = $json_db->select( 'name, state'  )
    ->from( 'users.json' )
    ->where( [ 'name' => 'Thomas' ] )
    ->order_by( 'age', JSONDB::ASC )
    ->get();
print_r( $users );

Updating Row

You can also update same JSON file with these methods, _(*9)

<?php 
$json_db->update( [ 'name' => 'Oji', 'age' => 10 ] )
    ->from( 'users.json' )
    ->where( [ 'name' => 'Thomas' ] )
    ->trigger();

Without the where() method, it will update all rows, _(*10)

Deleting Row

<?php
$json_db->delete()
    ->from( 'users.json' )
    ->where( [ 'name' => 'Thomas' ] )
    ->trigger();

Without the where() method, it will deletes all rows, _(*11)

Exporting to MySQL

You can export the JSON back to SQL file by using this method and providing an output, _(*12)

<?php 
$json_db->to_mysql( 'users.json', 'users.sql' );

Disable CREATE TABLE, _(*13)

<?php 
$json_db->to_mysql( 'users.json', 'users.sql', false );

Exporting to XML

Tarun Shanker also provided a feature to export data to an XML file ```php <?php if( $json_db->to_xml( 'users.json', 'users.xml' ) ) { echo 'Saved!'; }, _(*14)