Installation
VJ Basic Table is installed using standard Joomla! installation procedure in Joomla! back-end: Extensions -> Extension Manager -> Upload Package File.
VJ Basic Table module can be configured in Extensions -> Module Manager -> VJ Basic Table and can be used to place basic table in module positions or articles.
Module Usage
Displaying module
Module Class Suffix indicates specifies CSS class to be applied to this module instance.
Module Assignment in Menu Assignment tab allows to assign module to the pages to be displayed on.
Position in Details tab allows to set module position to render module in.
To place the module in an article assign some unique position to it like pos1, publish module and assign it to all pages. Then place {loadposition pos1} code into article to show the module in it.
It's possible to create many instances of the module in Module Manager by copying it or creating new one.
Module options
Load jQuery option specifies whether jQuery javascript library should be loaded or not. If you use other jQuery instance on the site please turn this off.
Table Source option specifies where table data should come from: HTML table (table constructed in 'HTML Table' text area, SQL query (query indicated in 'SQL Query' field), CSV file (path indicated in 'CSV file' field)).
Responsive - should table be responsive or not.
Title - title to display above the table.
CSS class name - CSS class name to apply to the table.
HTML Table - HTML table to use when Table Source option is set to 'HTML Table'.
SQL Query - SQL Query to use when Table Source option is set to 'SQL Query'. Example: select id, title from mytable.
Connection string - When using database other than Joomla! database it's needed to indicate connection string. If not specified, Joomla! database is used. If using different database, connectionString should be specified in format: database_type,host,database_name,user,password. Supported database types: fbsql, gladius, maxdb, msql, mssql, mssqlpro, mysql, mysqli, mysqlt, odbc, postgres, postgres64, postgres7, postgres8, sqlite, sqlitepro, sybase, sybase_ace. To work with some databasee appropriate php extension may need to be installed and enabled.
CSV file - CSV file to use when Table Source option is set to 'CSV file'. Example: docs/file.csv.
CSV delimiter - Delimiter to use with CSV file. Default: ,
Inline header CSS styles, Inline cell CSS styles - CSS styles to apply to headers or columns respectively. Style for each header/cell should be indicates on a new line.
Displaying module on front-end
Module is displayed on front-end using specified module position and chosen menu items.