Welcome to the home of JINXPAGE framework. If you have created a MySQL DB and you need a fast way to create an admin section, then this framework is for you.

What is JINXPAGE framework?

JINXPAGE is a framework written in PHP on server-side and JS on client side, optimized for fast, well actually very, very fast building REST API service, HTML TABLES and HTML FORMS for your MYSQL DataBase.

After initial creation, developer will be able to quickly change any element on these forms, with just changing JSON config files.

How does it do?

It creates alot of json config files. One file for each HTML form and table, and a few more json files to describe your DB tables and columns. By changing these files, you can change the way your forms and tables looks like, what elements thay have and how they act.

Is this an API, DB and ORM too?

NO. It does have some files to describe your DB, but its main focus is representing HTML TABLES and HTML FORMS. Because this framework does need an API in background, there is an API service too, built on REST principles. So you can use this API for some other actions, on some other pages you create, without any HTML form or HTML table that this framework offers.

Please watch this short 5-minute video to get a feeling of what this framework can do.
Your browser does not support the video tag.

Presentation of some complex changes.
Your browser does not support the video tag.

LETS RECAP, with one click on button CREATE =>
each mySQL table gets:

form to update or insert

table to show data

paged tables (pick a number of lines on one page)

search form

sort table by any column

AFTER that, you can:

change table color-schema

easily change html-elements

use plugins for html-elements. First video have example of jqueryDatePicker plugin. Other plugins included:

browse and upload file with percentage bar

browse and select a file on server side

simple wysiwig editor. for HTML parts

show coords on google-map

color-picker

date-picker

time-picker

And there will be a manual how to include your own plugins.

create elements in async way.
each element can execute their own sql-queries (something like inner select) that works independetly of main query. this can be used to show data from multiple tables.

but you can also join tables:

as a new query

as a mysql-view - define new view in MySql

OTHER OPTIONS, not shown in these videos:

show forms and tables in a widget

complete login system which CAN but dont have to be used.

different types of admin, which means that different administrators can view different forms and tables, based on their type (level). some can add and update data, other can only see tables, or cant see at all. it can be set for each table separately.

one table can have several different views, for example, on one page can only be input form, on second page table with all columns, on third page can be shown only some most important columns...

set default table to open after login

responsive tables:

pick what columns to hide on smaller screens

use totally different table layout

hidden elements, that can be calculated, and sent with the form.

default search options, not visible by the clients

elements in search can return more then one val, with an operators ">", "

each element can have its own "show required field" function

easy set basic restrictions {

"len": "<=30", //for strings

"val": ">=5;<=10", //for numbers

"notEmpty": true, //like required

"type": "int"

}

add your own restriction function

callbacks after events:

insert data,

update data,

delete data,

display table

multiple tables on one page

define your own buttons

FUTURE?

There are many plans for this framework in the future:

Rewriting backend for NODE.JS

Support other DBs: PostgreeSQL, MongoDB ...

live update, something like FIREBASE...

HOW CAN YOU HELP?

Not at the moment, except to hire me for background part of your projects. The more projects i built, more options will be added.
And at some point when i finish DOCS and DOWNLOAD section, i can concentrate on other FUTURE plans.

Sorry. There are still no available documentation for this framework.
I am working on it. If you need any help please write to: bojan.pejkovic@gmail.com

Move along, nothing to see here.

:-)

This framework is still in working phase. It works without bugs, but download section for public use will be available after i sort the code and finish docs.

One installation starts from 349e. It usualy requires 1 or 2 days for setup (if you know exectly what you want), to 3 days with trying different things to setup everything.