Simple json db javascript library, create json 'tables' and save data to it.
Requires JQuery, PHP.
PHP for login and logout, Javascript for edit, delete and get table / item.
-
Copy json-db folder to your website.
-
Open json-db/config.php and set your database username and password.
-
For editing, creating or deleting tables / items and selecting protected table data, you need login with php:
- include 'json-db/config.php'; - json_db_login($yourusername, $yourpassword); -
After this you can edit tables with Javascript using json-db/json-db.js.
-
json-db/index.php is simple adminpanel for db.
- include 'config.php';
Log in with config.php username and password.
json_db_login($USERNAME, $PASSWORD);
Logout
json_db_logout();
If you are logged in -> return true, else return false.
json_db_logged_in();
Response message format:
{
response: (object), // if error is 1, this won't exist.
message: (string),
error: (0 = No error, 1 = error)
}
Json db library path
json_db.folder.path = "json_db/"; // This is default path. This needs to be valid and <b>use slash at end of path!</b>
Create table, eg:
json_db.createTable("tableName", function(response){
console.log(response);
});
Create Protected table, you can read only if you are logged in. eg:
json_db.createProtectedTable("tableName", function(response){
console.log(response);
});
Update table protected status. eg:
json_db.updateTableContent(TABLE_NAME, PROTECTED_STATUS, SUCCESS_FUNCTION);
json_db.updateTable("tableName", 1 /*1 = protected, 0 = non-protected*/, function(response){
console.log(response);
});
Update table content. This replace old table to JSON_VARIABLE parameter. eg:
json_db.updateTableContent(TABLE_NAME, JSON_VARIABLE, SUCCESS_FUNCTION);
json_db.updateTableContent("tableName", {"name": "test"}, function(response){
console.log(response);
});
Remove table eg:
json_db.removeTable("tableName", function(response){
console.log(response);
});
Get table eg:
json_db.getTable("tableName", function(response){
console.log(response);
});
Get all tables eg:
json_db.getTables(function(response){
console.log(response);
});
Get item eg:
json_db.getItem(TABLE_NAME, ITEM_INDEX, SUCCESS_FUNCTION);
json_db.getItem("tableName", 0, function(response){
console.log(response);
});
Edit item eg:
json_db.editItem(TABLE_NAME, ITEM_INDEX, NEW_ITEM, SUCCESS_FUNCTION);
json_db.editItem("tableName", 0, {"item":"newItem"}, function(response){
console.log(response);
});
Add item eg:
json_db.addItem(TABLE_NAME, ITEM, SUCCESS_FUNCTION);
json_db.addItem("tableName", {"title":"this item will be added."}, function(response){
console.log(response);
});
GNU General Public License v3.0