Documentation Database

documentation-icon.png 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

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}
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 textbox
  • Enum and set fields are displayed as a select-element
  • Enum and set fields with less then 3 elements are displayed as a radio-element (enum) or checkbox (set)

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.

ifis

{joodb ifis|FIELDNAME|[value]|[cond]}
thumb

Compares whether a condition is valid or not and stops or continues output. Without any value or condition the content of FIELDNAME is tested for empty,false,zero or negative.

Parameters 

  • FIELDNAME - Name of a field in your database
  • value (optional) - An integer or string value
  • cond (optional) - The condition to test for
    Valid conditions are
    • eq (default) - Fieldcontent is equal value
    • ne - Fieldcontent is  not equal value
    • lt - Fieldcontent is lower then value
    • gt - Fieldcontent is greater then value
    • le - Fieldcontent is lower or equal value
    • ge - Fieldcontent is greater or equal value

Example

{joodb ifis|price|100|ge}

    

  • This item is rather expensive	
    • 


{joodb else}

    

  • The price is less then 100 $
    • 


{joodb endif}

Compares whether the value of the field price is more then 100 $ ...

Notes

  • {joodb ifnot} is deprecated. Use ifis with the "ne" condition.
  • If value is a string, ifis is testing the alphabethical order.

Page 1 of 4 Results 1 - 10 of 37