PHP CRUD Generator - Database wwwumdom_arvores

Tools
General settings
Organize Admin Navbar
Reload database structure
wwwumdom_arvores Relations
Table Column Referenced table Referenced column
arvores family tipo_arvore id
phpcg_users profiles_ID phpcg_users_profiles ID
Choose a table
Select an action

Build Read List

Build Create / Update Forms

Build Delete Form
Options from the paginated list
arvoresMain settings

Need help?

arvoresField Names Displayed in Admin
arvoresFilters (drop-down lists to filter results)

Use FlySpeed SQL Query to generate and test your queries

Label
Label displayed next to the drop-down list.
Example : "Author"
Value(s)
Fields to be displayed in the drop-down list, separated by "+".
Example : "authors.name + authors.first_name"
Fields
Fields for the query SQL SELECT.
Example : "authors.name, authors.first_name, articles.authors_id"
Fields to be filtered
The field used to filter the query.
Example : "articles.authors_id"
SQL FROM
SQL FROM query.
Example : "articles Left Join authors On articles.authors_id = authors.id"
Column number
Index of the filtered column in the paged list
Used to color the filtered column. The index starts at number 1.
Type of values
Text or Boolean.

The query cited as an example will be the following :

SELECT DISTINCT authors.name, authors.first_name, articles.authors_id FROM articles INNER JOIN authors ON articles.authors_id = authors.id

When the user has chosen an item from the list :

SELECT DISTINCT authors.name, authors.first_name, articles.authors_id FROM articles INNER JOIN authors ON articles.authors_id = authors.id WHERE articles.authors_id = [posted value]

Use table.field rather than field to avoid ambiguous queries.

arvoresarvores Fields

Values : None

Values : None

Values : None

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

Values : None

Values : None

Values : None

Values : Custom values

Values : tipo_arvore.id

Choose the field types and options for Create | Update
arvores

Auto-increment fields values are automatically generated in CREATE forms
Validation is automatic and cannot be changed

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

integer($message = null)
min($limit, $include = TRUE, $message = null)
max($limit, $include = TRUE, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
float($message = null)
integer($message = null)
min($limit, $include = TRUE, $message = null)
max($limit, $include = TRUE, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
float($message = null)
integer($message = null)
min($limit, $include = TRUE, $message = null)
max($limit, $include = TRUE, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
float($message = null)
min($limit, $include = TRUE, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
float($message = null)
min($limit, $include = TRUE, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
float($message = null)
min($limit, $include = TRUE, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
float($message = null)
min($limit, $include = TRUE, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
float($message = null)
min($limit, $include = TRUE, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

Custom values

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

required($message = null)
oneOf($allowed, $message = null)
[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Leave blank if no limitation

Leave blank if no limitation

Hide the field and set the value to the current date (no|yes)

tipo_arvore.id

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM

No html

integer($message = null)
min($limit, $include = TRUE, $message = null)
max($limit, $include = TRUE, $message = null)
Single record list options
Main settings
arvores
arvores

Values : None

Values : None

Values : None

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt

[ROOT_PATH]/
[ROOT_URL]/

Values : None

Values : None

Values : None

Values : None

Values : Custom values

Values : tipo_arvore.id

Options for the deletion form

Fields displayed to user in admin to confirm deletion