PHP Classes

PHP JSON Flat File Database : Create database tables stored as files in JSON

Recommend this page to a friend!
     
  Info   View files Example   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 58%Total: 556 All time: 5,472 This week: 455Up
Version License PHP version Categories
jsonql 0.12Free For Educatio...5.3PHP 5, Databases, Files and Folders
Description 

Author

Daniel Alan Guerrero Matamoros

This class can create database tables stored as files in JSON.

It can create a database column and add one or more columns of a given type to it.

The class can also add or delete rows from the table. When the changes are done, the database table can be saved to a given JSON file format.

Later the class can load the saved table from the JSON file.

Picture of Daniel Alan Guerrero Matamoros
  Performance   Level  
Name: Daniel Alan Guerrero ... is available for providing paid consulting. Contact Daniel Alan Guerrero ... .
Classes: 7 packages by
Country: Mexico Mexico
Age: 28
All time rank: 197121 in Mexico Mexico
Week rank: 360 Up7 in Mexico Mexico Up

Level 1 Star

 Innovation award
Innovation award
Nominee: 1x

Example

<?php

require_once "jsonql.class.php";

$jql = new jsonql();
if($jql->createDB("sample")){
    echo "Basic creating<BR/>";
    $jql->addColumn("Name", "t");
    $jql->addColumn("Lastname", "t");
    $jql->addColumn("Age", "i");
    $jql->addRow(array("Daniel", "Guerrero", 20));
    $jql->addRow(array("Valeria", "Guerrero", 4));
    $jql->addRow(array("Mia", "Efdent", 30));
    $jql->printTable();
    echo "<HR>";
    echo "One row delete<BR/>";
    $jql->deleteRow("Name", "Mia");
    $jql->printTable();
    echo "<HR>";
    echo "All table delete";
    $jql->deleteRow();
    $jql->printTable();
} else {
    echo "<BR/>Error!<BR/>";
}

?>

  Files folder image Files  
File Role Description
Plain text file jsonql.php Class Base class
Accessible without login Plain text file sample.basic.php Example Basic Sample

Downloadjsonql-2016-05-19.zip 1KB
Downloadjsonql-2016-05-19.tar.gz 1KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:556
This week:0
All time:5,472
This week:455Up
User Ratings User Comments (1)
 All time
Utility:100%StarStarStarStarStarStar
Consistency:87%StarStarStarStarStar
Documentation:-
Examples:-
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1379
  

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.