Documentation Database

* This Documentation was realized with the joodb component. Please click on the items to open a detailed description. The documentation is still under construction.
select view
   
CommandOrder by:  Command

alphabox

{joodb alphabox}
thumb

Alphabox is replaced by a div with the classname pagination alphabox with a list containing all roman letters. With the linked letters you can select items by the first char of their titles.

Example

{joodb alphabox}

 

backbutton

{joodb backbutton}
thumb

Inserts an icon or text link into the single view. A click on that link navigates to the previous page.

Example

{joodb backbutton}

Note

    If you want a textlink instead of an icon you can change the icon-settings in JooDB-general options.

 

captcha

{joodb captcha}
thumb

Displays a small captcha where the user has to enter 5 letters before submitting the form.

Example

{joodb captcha}

Note

We do not use the built in cpatcha of Joomla 2.5

editbutton

{joodb editbutton|[cond]} »pro only«
thumb
editbutton (new with 2.7 pro) displays an icon or link to load the current entry into the form- or edit-view. The old automatic Notepad icon was removed.

Parameters 

  • COND (optional) - condition: if true the entry is loaded into the edit view instead of the form view.

Example

{joodb editbutton|true}

Notes

  • editbutton with condition true will be displayed only to special users if the are logged in. Edit in frontend must be enabled for the current JooDB database.
  • editbutton without condition or condition false true will be displayed only to registered users with acces to the form if
    1. A userfield ID is defined where the joomla user ID is stored.
    2. The current user ID matches with the id of this dataset.
    3. If no userfield ID is defined and the user has the level for formview or above
  • Due security reasons only registered users can edit items
  • See path2editform command

else

{joodb else}
thumb

Else negates the current output condition. {joodb else} must be in between an {joodb ifis} and {joodb endif} command.

Example

{joodb ifis|in_stock}

    

  • You can buy this product. {joodb field|in_stock} Unities are availiable
    • 


{joodb else}

    

  • This product is sold out
    • 


{joodb endif}

Prints a waring no more products are available.

endif

{joodb endif}
thumb

Endif ends an Ifis condition and enables the output regardless of the current condition.

Example

{joodb ifis|color|red}

    

  • The color is red like a firewagon
    • 


{joodb endif}

Prints a color definition.

exportbutton

{joodb exportbutton} »pro only«
thumb

Exportbutton displays an input-button with the classname button export to export the complete catalogue or the current search result as Excel-table.

Example

{joodb exportbutton}

Note

You can define the exported fields and the maximum rows at the joomla menuy-entry for your catalogue.

field

{joodb field|FIELDNAME|[length]}
thumb

Output of content of FIELDNAME. FIELDNAME must be the name of an existing Database field.

Some datatypes like (Date,Timestamp, Set, Enum) will be formated automatically be the system.

Parameters

  • FIELDNAME - Name of a field in your database
  • length (optional) - Maximum length of output for text files

Example

{joodb longtext|120}

Strips the text in longtext to 120 chars and adds thre points to the end...

Note: The old version with {joodb FELDNAME} without any command is deprecated

 

form

{joodb form|FIELDNAME|[parameters]} »pro only«
thumb

Generates a formfield to the form-view. The formelement-types are dependent on the datafield-type. 

  • Varchar is displayed as a input-element. Possible parameters are "password" and "email". (For example {joodb form|usermail|email})
  • Text is displayed as a editor field. Possible parameter is "textarea" to display as textbox field instead.
  • Tinyint or boolean SQL Fields. Possible parameter is "yesno" to display the field as YES/NO boolean field. (value 0 and 1)
  • ENUM and SET SQL fields are displayed as a select-element. Possible parameter is radio or check to display the field
    as a radio-element (enum) or checkbox (set) atomatically
  • ENUM and SET SQL fields with less than 5 elements are displayed as a radio-element (enum) or checkbox (set) atomatically

Form validation is done automatically. If the value of a field can not be »Null« it is required.

Example


		
{joodb form|topic}

		
{joodb form|mail|email}

		
{joodb form|message}

	


{joodb captcha}


{joodb submitbutton}

Notes

  •  If a datafield can no NULL the form-element is marked as required.

groupselect

{joodb groupselect|FIELDNAME|[rows]|[use search]} »pro only«
thumb

Groupselect is part of the catalogue search options. Groupselect generates a select list of all existing values from the field FIELDNAME. Groupselect uses the current search filter to reduce the list of possible values. You can combine multiple Groupselects to allow complex parametric searches.

Parameters 

  • FIELDNAME - Name of a field in your database
  • rows (optional, integer) - Number of rows for a multiselect form element.
  • use search (optional, boolean, default no) - Apply the current search to the result. Note: this behaviour was changed with version 2.1.2

Example

Search electronic components






{joodb groupselect|voltage|5}
{joodb groupselect|resistance|5}
{joodb groupselect|price|5}
{joodb groupselect|in_stock|5}

Search in electronic components combining multiple parameters

Notes

  • Fields used for parametric searches should type varchar or integer instead of text and indexed.

Page 1 of 4 Results 1 - 10 of 40