Documentation Database

select view
   
CommandOrder by:  Command

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 than value
    • gt - Fieldcontent is greater than 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 than 100 $
    • 


{joodb endif}

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

Since version 3.9.9pro you are able to compare multiple values and use conditions like "&&" and "||".

This feature is still experimental!

Example

{joodb ifis|price|10|lt || special_price && print_price_info}

    

  • This price is lower as 10$ OR it's a special price AND  we can output the price info!
    • 


{joodb endif}

Instead of "&&" or "||" you can use "and" and "or"

Notes

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

ifnot

{joodb ifnot}
thumb

Ifnot tests FIELDNAME empty,false,zero or negative and discontinues output if the content is positive or filled.

Example

{joodb ifnot|in_stock}

    

  • This product is sold out
    • 


{joodb else}

    

  • You can buy this product. {joodb field|in_stock} units are available
    • 


{joodb endif}

Print a waring no more products are available.

Notes

  • {joodb ifnot} is deprecated. Use ifis with the "ne" condition.

image

{joodb image}
thumb

Displays the complete image stored with the dataset. If no image is available it displays the nopic image in /components/com_joodb/assets/images/ and adds a nopic class to the image.

Example

{joodb image}

Notes

If you set .nopic {display: false;} in your stylesheet, only existing images are displayed

Related commands are thumb, path2image, path2thumb

You can change the size for thumbnails and images in the options of your JooDB database

See also » about images

imageupload

{joodb imageupload} »pro only«
thumb

Inserts a file-input to the form where users can submit an image with a contribution. The images will be automatically scaled, named and linked to the item.

Example


		
{joodb form|topic}

		
{joodb form|mail|email}

		
{joodb form|message}

		
{joodb form|imageupload}

	


{joodb captcha}


{joodb submitbutton}

Notes

  • Only JPG, PNG and GIF-Images are supported
  • You can change the maximum size of thumbnails and images with the configuration of your database

 

limitbox

{joodb limitbox}
thumb

Inserts a select box where the user can change the numbers of entries per page ind catalogue-view.

Example

{joodb limitbox}

Note

Should be placed outside the loop commands

loop

{joodb loop}
thumb

In the catalogue view the LOOP commands encapsulates the output of the entries.

Remember! There must be allways two LOOP-commands in the catalogue template.

Example

	
Booklist

	
    {joodb loop}
		
  • {joodb booktitle}
    • {joodb loop}

Output a list with booktitles. If booktitle is defined as joodb title field and "link titles" is selected in menu, the titles will be linked to the single entry views.

loopclass

{joodb loopclass}
thumb

Inserts a class tag (even or odd) of an item in catalogue-view or in subtemplate items. Must be used inside of the loop commands.

Example

  • {joodb field|author}
    •

    Display a list auf authors in a subtemplate

    Note

    You can style the .even and .odd elements in your template css or with the joodb.css in /components/com_joodb/assets

    nextbutton

    {joodb nextbutton} »pro only«
    thumb

    Inserts an icon or text link into the single view. With nextbutton and prevbutton the user will be able to browse between the database-entries.

    Example

    {joodb nextbutton}

    Notes

      • If you want a textlink instead of an icon you can change the icon-settings in JooDB-general options.
      • The next- and prevbutton-functions are using the current selection and ordering of the parenrt katalog-view.

    nodata

    {joodb nodata}
    thumb

    Nodata is replaced by a div with the classname error nodata and the "No Data found!" expression.

    Example

    {joodb nodata}

    Notes

    • Nodata must be placed outside of the catalogue-loop commands.
    • You can change the text displayed if the result was empty by changing the propriate language file xx-XX.com_joodb.ini in /language/XX

    notepadbutton

    {joodb notepadbutton} »pro only«
    thumb

    Inserts an icon or text link to mark items. A click on the link adds the item to a notepad and shows a list with all selected items. The selected items are stored with the session. You can realize carts with this function.

    Example

    {joodb notepadbutton}

    Notes

    • If you want a textlink instead of an icon you can change the icon-settings in JooDB-general options
    • This is still a higly experimental feature

     

    Page 2 of 4 Results 11 - 20 of 40