A jqGride module offer a powerful way to provide, collect and shear data with your users. Allow you to create fastly mature and roboust applications of various calibres from microapplication to more and more complex without / or little coding.

In that tutorial we will built an jqGrid application consecuently from trivial to more complex applications using jqGrid module.

All basic adjustments are collected in "Module" tab.

[to have full access to set-up this tab you mast be to connect as administrator].

In section "Database connection info" set your local or remote database credentials

Database User Name - [...]
Database Password - [...]
Database Host Name - [in case of local database write: localhost ) ]
Database Port - [ usually use 3306 port]
Database Name - [...]
OR native DSN string - [ use that field if you know how to set DSN string ]
Test connection - [ push "Test database connection" button to test if connection with your database is successful ]
[After successful connection, to continue, please, save]

In section "Define allowed tables to use" restrict which of your database tables will be available to users or guests

Allowed tables - [ from this control left the tables that want to make available to users or guests ]
What tables to use? - [ Here you can select if you will use some tables from database or will create from the SQL script (initTables.sql) any tables you want ]
REMARK: SQL script is located on path ../admin/sql/initTables.sql and feel free to modify it as you want.
Select table - [ select particular table for use of collection of available tables ]
Please save to actvate changes - [ save ]
Reinstall init tables - [ use it if you want to reinstall tables from the ../admin/sql/initTables.sql script ]
Autoincrement - [check if your table primary key is of AUTOINCREMENT type ]

In section "Setup Configurator Table" determine the look of table in use and fields in use and names of fields, eventually translated in Joomla! site available languages.

Output configurator - [ invoke Output configurator ]
If not used configurator then will be shown all table fields with their original names and order.

How to set-up the Output configurator

Output configurator have 5 adjustable fields where you can to setup table look
Field - [ table field name - unchangeable ]
Label - [ put here the table field caption / label ]
Order - [ put here order of table fields ]
Show - [ check what fields will be hidden or visible (0 / 1) ]
Width - [ set default fielt width ]
Sort - [ set by which field, initially, table will be sorted ]
In case of multilanguage site you can to get for every table caption / label name its translation by click on Output configurator preseding the column "Field" respective field triangle mark and fill shown up table with appropriate tanslations for every available to system language.

In section Grid ID [multiple modules on page] used if on page located more than one jqGrid Module

Grid ID - [ jqGrid Module distinkt ID ]

In section jqGrid php library some options mostly for developers to check or develop yor own jqGrid php library.

Revert to installed jqGrid lib - [ revert to pre installed jqGrid php library]
jqGrid Demo lib file name - [ set version of demo jqGrid php library to download from]
Install jqGrid Demo lib - [ install that version]

And that's your new jqGrid:

The most basic jqGrid using only predefined parameters and default adjustments of configurator.

Here are basic adjustments nedded to showup the jqGrid.

  • t0
  • t1
  • t2

Farther continues with classic module setup controls in Module tab such "Show Title", "Position", etc.

Thats it! Your first jqGrid was born.

By are marked mandatory fields to be filled.

In next article we w'll dive in more detailes of Configurator adjustments.

v 2