GitHub - donjajo/php-jsondb: A PHP Class that reads JSON file as a database. Use for sample DBs

<div id=""><h2><a id="user-content-php-jsondb" class="anchor" aria-hidden="true" href="#php-jsondb"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>php-jsondb</h2>
A PHP Class that reads JSON file as a database. Use for sample DBs.
<h3><a id="user-content-usage" class="anchor" aria-hidden="true" href="#usage"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>Usage</h3>
Install package <code>composer require jajo/jsondb</code>
<h4><a id="user-content-initialize" class="anchor" aria-hidden="true" href="#initialize"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>Initialize</h4>
<div class="highlight highlight-text-html-php" readability="35"><pre><?php 
use Jajo\JSONDB;
$jsondb = 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/jsonfiles' )</pre></div>
<h4><a id="user-content-inserting" class="anchor" aria-hidden="true" href="#inserting"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>Inserting</h4>
Insert into your new JSON file. Using users.json as example here
NB: Columns inserted first will be the only allowed column on other inserts
<div class="highlight highlight-text-html-php" readability="35"><pre><?php
$jsondb->insert( 'users.json', 
 [ 
 'name' => 'Thomas', 
 'state' => 'Nigeria', 
 'age' => 22 
 ]
);</pre></div>
<h4><a id="user-content-get" class="anchor" aria-hidden="true" href="#get"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>Get</h4>
Get back data, just like MySQL in PHP
<h5><a id="user-content-all-columns" class="anchor" aria-hidden="true" href="#all-columns"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>All columns:</h5>
<div class="highlight highlight-text-html-php" readability="32"><pre><?php
$users = $jsondb->select( '*' )
 ->from( 'users.json' )
 ->get();
printr( $users );</pre></div>
<h5><a id="user-content-custom-columns" class="anchor" aria-hidden="true" href="#custom-columns"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>Custom Columns:</h5>
<div class="highlight highlight-text-html-php" readability="33"><pre><?php 
$users = $jsondb->select( 'name, state' )
 ->from( 'users.json' )
 ->get();
printr( $users );
 </pre></div>
<h5><a id="user-content-where-statement" class="anchor" aria-hidden="true" href="#where-statement"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>Where Statement:</h5>
This WHERE works as AND Operator at the moment or OR
<div class="highlight highlight-text-html-php" readability="41"><pre><?php 
$users = $jsondb->select( 'name, state' )
 ->from( 'users.json' )
 ->where( [ 'name' => 'Thomas' ] )
 ->get();
printr( $users );
 
// Defaults to Thomas OR Nigeria 
$users = $jsondb->select( 'name, state' )
 ->from( 'users.json' )
 ->where( [ 'name' => 'Thomas', 'state' => 'Nigeria' ] )
 ->get();
printr( $users ); 
 
// Now is THOMAS AND Nigeria 
$users = $jsondb->select( 'name, state' )
 ->from( 'users.json' )
 ->where( [ 'name' => 'Thomas', 'state' => 'Nigeria' ], 'AND' )
 ->get();
printr( $users ); 
 
 </pre></div>
<h5><a id="user-content-order-by" class="anchor" aria-hidden="true" href="#order-by"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>Order By:</h5>
Thanks to <a href="http://in.linkedin.com/in/tarunshankerpandey" rel="nofollow" style="color: inherit; text-decoration: none;" name="readabilityLink-1">Tarun Shanker</a> for this feature. By passing the <code>orderby()</code> method, the result is sorted with 2 arguments of the column name and sort method - <code>JSONDB::ASC</code> and <code>JSONDB::DESC</code><a href="#readabilityFootnoteLink-1" class="readability-DoNotFootnote" style="color: inherit;">[1]</a>
<div class="highlight highlight-text-html-php" readability="35"><pre><?php 
$users = $jsondb->select( 'name, state' )
 ->from( 'users.json' )
 ->where( [ 'name' => 'Thomas' ] )
 ->orderby( 'age', JSONDB::ASC )
 ->get();
printr( $users );</pre></div>
<h4><a id="user-content-updating-row" class="anchor" aria-hidden="true" href="#updating-row"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>Updating Row</h4>
You can also update same JSON file with these methods
<div class="highlight highlight-text-html-php" readability="34"><pre><?php 
$jsondb->update( [ 'name' => 'Oji', 'age' => 10 ] )
 ->from( 'users.json' )
 ->where( [ 'name' => 'Thomas' ] )
 ->trigger();
 </pre></div>
Without the where() method, it will update all rows
<h4><a id="user-content-deleting-row" class="anchor" aria-hidden="true" href="#deleting-row"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>Deleting Row</h4>
<div class="highlight highlight-text-html-php" readability="32"><pre><?php
$jsondb->delete()
 ->from( 'users.json' )
 ->where( [ 'name' => 'Thomas' ] )
 ->trigger();
</pre></div>
Without the where() method, it will deletes all rows
<h4><a id="user-content-exporting-to-mysql" class="anchor" aria-hidden="true" href="#exporting-to-mysql"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>Exporting to MySQL</h4>
You can export the JSON back to SQL file by using this method and providing an output
<div class="highlight highlight-text-html-php" readability="33"><pre><?php 
$jsondb->tomysql( 'users.json', 'users.sql' );</pre></div>
Disable CREATE TABLE
<div class="highlight highlight-text-html-php" readability="34"><pre><?php 
$jsondb->tomysql( 'users.json', 'users.sql', false );</pre></div>
<h4><a id="user-content-exporting-to-xml" class="anchor" aria-hidden="true" href="#exporting-to-xml"><svg class="octicon octicon-link" viewbox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9h1v1H4c-1.5 0-3-1.69-3-3.5S2.55 3 4 3h4c1.45 0 3 1.69 3 3.5 0 1.41-.91 2.72-2 3.25V8.59c.58-.45 1-1.27 1-2.09C10 5.22 8.98 4 8 4H4c-.98 0-2 1.22-2 2.5S3 9 4 9zm9-3h-1v1h1c1 0 2 1.22 2 2.5S13.98 12 13 12H9c-.98 0-2-1.22-2-2.5 0-.83.42-1.64 1-2.09V6.25c-1.09.53-2 1.84-2 3.25C6 11.31 7.55 13 9 13h4c1.45 0 3-1.69 3-3.5S14.5 6 13 6z"/></svg></a>Exporting to XML</h4>
<a href="http://in.linkedin.com/in/tarunshankerpandey" rel="nofollow" style="color: inherit; text-decoration: none;" name="readabilityLink-2">Tarun Shanker</a><a href="#readabilityFootnoteLink-2" class="readability-DoNotFootnote" style="color: inherit;">[2]</a> also provided a feature to export data to an XML file
<div class="highlight highlight-text-html-php" readability="33"><pre><?php 
if( $jsondb->to_xml( 'users.json', 'users.xml' ) ) {
 echo 'Saved!';
}</pre></div>
</div><div id="readability-footnotes"><h3>References</h3><ol id="readability-footnotes-list"><li><a href="#readabilityLink-1" title="Jump to Link in Article">^</a> <a href="http://in.linkedin.com/in/tarunshankerpandey" rel="nofollow" name="readabilityFootnoteLink-1">Tarun Shanker</a> (in.linkedin.com)</li><li><a href="#readabilityLink-2" title="Jump to Link in Article">^</a> <a href="http://in.linkedin.com/in/tarunshankerpandey" rel="nofollow" name="readabilityFootnoteLink-2">Tarun Shanker</a> (in.linkedin.com)</li></ol></div>

keywords

No Items Found.

Add Comment

Other Items in php

SimplePie Documentation: API Reference MicroDB – A minimalistic file-based JSON object database written in PHP GitHub - donjajo/php-jsondb: A PHP Class that reads JSON file as a database. Use for sample DBs GitHub - andreskrey/readability.php: PHP port of Mozilla's Readability.js GitHub - claviska/SimpleImage: A PHP class that makes working with images as simple as possible. PHP Basics: Extending Classes - YouTube GitHub - strzlee/JsonDB.class.php: JSON Databaseclass. Handle JSON-Files like a very, very simple DB. GitHub - Greg0/Lazer-Database: PHP flat file database to store data with JSON MicroDB – A minimalistic file-based JSON object database written in PHP GitHub - symfony/panther: A browser testing and web crawling library for PHP and Symfony GitHub - ssddanbrown/sslcheck: Simple PHP script to check SSL expiry How F5Bot Slurps All of Reddit GitHub - codeplea/ahocorasickphp: Aho-Corasick multi-keyword string searching library in PHP. PHP Class to Get Weather Data Using OpenWeatherMap API – CodeSpeedy Slim Framework - Slim Framework

Other Categories in Linx

ai apps articles cloud apps code coffee factorio games hardware health iphone lists minecraft music pi security stock images stock images tech vpn web dev web developer websites windows ai android api apps articles asp audio australia bio bitcoin blog books bootstrap career charts code editors codepens cooking css css animations daily linx data day trips design design elements drawing education emulators entrepreneur factorio fitness flowcharts fonts foobar2000 themes games hardware headphones health home automation html templates icons itunes javascript jquery js linux mac maps media mhx minecraft misc money motivation music network news nginx os osrs pantheon parenting phone phones php pi products programming radio random reading reddit rs3 runescape seo shopping sqlite stock images storage tax tech technology text formatting tools trains video video editor videos wallpapers weather web web design web development web sites webdev windows wine wordpress workout youtube

Welcome

This is my test area for webdev. I keep a collection of code here, mostly for my reference. Also if i find a good link, i usually add it here and then forget about it. more...

Latest News

## 🚀 AI Giants Hit Bullseye: Anthropic & OpenAI Achieve Product-Market Fit Anthropic and OpenAI have reached a significant milestone, finding product-market fit with their AI technologies, which means their products effectively meet the needs of their customers, driving growth and adoption. This achievement showcases the practical value of their innovations, enabling businesses and individuals to leverage AI for enhanced productivity and efficiency. With this alignment of product and market needs, these companies are poised to transform industries and shape the future of technology.

GitHub - donjajo/php-jsondb: A PHP Class that reads JSON file as a database. Use for sample DBs

Add Comment

Other Items in php

Other Categories in Linx

Search Linx

Latest from Linx

Welcome

Random Quote

Latest News

Latest Articles

Code

Links

Quick Links

Quick Links

Sections