JustAjaxTable 1.9new performs all operation with tables “on-fly” using Ajax requests.

Client-Side Setup

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 .
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;

Demo: http://justajax.com/table/demo.html

Source: http://justajax.com/table/documentation.html

Related Listings:

1. Table Gear – Moo Tools Plugin TableGear is a software package for working with data on...
2. Table Editor with jQuery TableEditor provides flexible in place editing of HTML tables. User...
3. phpMyDataGrid Table with Ajax phpMyDataGrid 2007 offers a toolkit to build a DataGrid in...
4. tEditable : In place Editing for Tables A jQuery plugin (based heavily on jEditable) that allows cells...
5. Table Drag n Drop Script I’ve been using JQuery for a while now and really...

Do you like this post?

Email: