J3.x

Difference between revisions of "Adding custom fields/Sql Field/zh-tw"

From Joomla! Documentation

< J3.x:Adding custom fields
(Created page with "上一篇:可重複欄位")
 
(Created page with "下一篇:文字欄位")
 
Line 33: Line 33:
 
<div class="row">  
 
<div class="row">  
 
<div class="large-6 columns">{{Basic button|S:MyLanguage/J3.x:Adding_custom_fields/Repeatable_Field|上一篇:可重複欄位|class=expand success}}</div>
 
<div class="large-6 columns">{{Basic button|S:MyLanguage/J3.x:Adding_custom_fields/Repeatable_Field|上一篇:可重複欄位|class=expand success}}</div>
<div class="large-6 columns">{{Basic button|S:MyLanguage/J3.x:Adding_custom_fields/Text_Field|Next: Text Field|class=expand}}</div>
+
<div class="large-6 columns">{{Basic button|S:MyLanguage/J3.x:Adding_custom_fields/Text_Field|下一篇:文字欄位|class=expand}}</div>
 
</div>
 
</div>
 
__NOTOC__
 
__NOTOC__

Latest revision as of 19:11, 16 March 2021

Other languages:
Bahasa Indonesia • ‎Deutsch • ‎English • ‎Nederlands • ‎français • ‎中文(台灣)‎


Sql Field


Sql

Provides a drop down list of entries obtained by running a query on the Joomlaǃ Database. The first results column returned by the query provides the values for the drop down box.

Options

Special options within this field are:

  • Multiple
    Allow multiple values to be selected - if activated.
  • Query
    The SQL query which will provide the data for the dropdown list. The query must return two columns; one called 'value' which will hold the values of the list items; the other called 'text' containing the text in the drop-down list.


Related Information

See SQL form field type

Screenshots

Creating the field

Let's say you create a field with the options shown in the next figure.

Sql field create-en.png

Using the field in the backend

In the backend while creating an article or a contact you see the field like in the following imageː

Sql-en.png

Using the field in the frontend

In the frontend, you can see the field as you see in the following image. The option Automatic display is responsible for the position of the field and your template is responsible for the design of the field.
Fields are only displayed in the frontend if you have filled them with data in the article. If it is not a required field, can you forget it?

Sql field frontend-en.png