====== PageBuilder Database Add-on ======

** pb_addon_database **

The following packages are required;

     pagebuilder
     report-template


To learn how to use the PageBuilder Database Add-on we strongly suggest you watch our video tutorials:

    http://radria.sqlfusion.com/video_tutorial.php


====== Included scripts ======

Below are all the scripts with-in **pb_addon_database**:
  - Interactive Data Display
  - Interactive Multi-Select
  - Display Table Content
  - Display Form for a Table
  - Data source: Detail Link
  - Data source: Saved Query
  - Data source: Raw SQL
  - Display Data Field
  - Display Image Field
  - Next Record Link
  - Previous Record Link
  - Ajax Drop Down Search
  - Registry
  - Form Header
  - Form Edit Button
  - Form Add Button



===== Interactive Data Display =====

With this scrip you can display the content of a database table and optionally add editing capability to manage the content of that table.

{{pagebuilder:addons:pb_addon_database:interactive_data_display.png|}}



==== Report Template ====
You currently have a choice of 3 default interactive templates:
   * //Tables of records//: Multiples rows of records are displayed in a table with ordering on the top column.
   * //One record list//: Display records with each field on one line, perfect for displaying one record.
   * //One record in 2 columns//: Display records like the one record list but in 2 columns.

==== Choose a table name ====
This is the second and last required field.
Each display of data or view needs the name of the base table associate with it.

==== Or a Saved SQL Query ====
This drop down lists all of the SQL Queries created in the WebIDE under the Query tab.
You can assign the query to the interactive display.

==== Number of rows to display ====
By default it will display all the rows in the table or return by the SQL query results.

If you want to limit the number of rows you can enter a number and it will automatically create a pagination to browse multiple pages or records.

==== Optional Registry ====
The registry object defines how database table fields should be displayed in a web based environment.
You can get more information on Registries and field types in the Radria [[core:registry:registry_object|Core Developer documentation]].

===== Display Form for a Table =====

Display a form for adding or editing content in a database table.