JustAJAX.com
  ajax components

Lightweight and Clear
Ajax Components

Ajax Table Grid Documentation

Client-Side Setup

  <script src="./data/scripts/cba.js"></script>
  <script src="./data/scripts/justajax-table.js"></script>     
  <script>

    window.onload = function(){
         
         var _table = new justAjaxTable( {
            'main'    : document.getElementById('table-area'),
            'dbtable' : 'authors',
            'names'   : ['#','Name','Author'],
            'url'     : 'http://192.168.1.34/joomla/index.php'} );
      };

  </script>

Ajax Table Grid Parameters Info: main - the reference to a template of the table, dbtable - name of the table in database, lengths - array of lengths of columns in percentage, columns caption, url - url of the backend

The correct structure of the document is considered as the necessary condition: required tags <body></body>.

Server Side Setup

It is only required to specify parameters of the connection to a DB in the backen:

// params
$_db = array (
  'host' => 'localhost',
  'user' => 'root',
  'password' => '',
  'database' => 'ajax'
);

and tables accessible to viewing and editing:

// possible tables
$poss_tables = array(
      'authors' => array(       
           //parameters for 'authors'
           'hidden_columns' => array('authors_genre'),
           'editable'       => true,
           'disrows'        => array('authors_id'),
           'filter'         => true,
           'adding'         => true,
           'deleting'       => true       
        ),
      'rss_db' => array()
  );

The description of Ajax Table Grid parameters:

'authors','rss_db' - table's names;
'hidden_columns' - array with hidden fields;
'editable' - opportunity to edit the table.
( true - editing is possible, false - editing is forbidden). Default value: false;
'disrows' - array of the fields forbidden for editing;
'filter' - enable/disable use of the filter. Default value: true;
'adding' - enable/disable addition of new records. Default value: false;
'deleting' - enable/disable deletion of records. Default value: false;

Requirements to the table of databases.

  • You should use only standard data types (string, char, integer, datetime, double and other)
  • You should establish INDEX for the table, mainly for addition of records

Example of the table.

CREATE TABLE `authors` (
  `authors_id` int(5) NOT NULL AUTO_INCREMENT,
  `authors_product` varchar(255) NOT NULL DEFAULT 'default',
  `authors_author` varchar(50) NOT NULL,
  `authors_genre` varchar(50) NOT NULL,
  KEY `authors_id` (`authors_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

©2019 JustAjax.com


ajax table grid documentation | javascript ajax grid quick start |  ajax dynamic table purchase | javascript editable grid license