Database Reference
In-Depth Information
$size_info
->
{
values
}
$size_info
->
{
default
}
The
values
member is a reference to a list of the legal enumeration values, and
de
fault
is the column's default value. Convert this information to a form element such as
a group of radio buttons or a pop-up menu as follows:
print
radio_group
(
-
name
=>
"size"
,
-
values
=>
$size_info
->
{
values
},
-
default
=>
$size_info
->
{
default
},
-
linebreak
=>
1
);
# display buttons vertically
print
popup_menu
(
-
name
=>
"size"
,
-
values
=>
$size_info
->
{
values
},
-
default
=>
$size_info
->
{
default
});
The default value is
medium
, so the browser selects that value initially when it displays
the form.
The equivalent Ruby metadata-fetching method returns a hash. Use it as follows to
generate form elements from the
size
column metadata:
size_info
=
get_enumorset_info
(
dbh
,
"cookbook"
,
"cow_order"
,
"size"
)
form
<<
make_radio_group
(
"size"
,
size_info
[
"values"
]
,
size_info
[
"values"
]
,
size_info
[
"default"
]
,
true
)
# display items vertically
form
<<
make_popup_menu
(
"size"
,
size_info
[
"values"
]
,
size_info
[
"values"
]
,
size_info
[
"default"
]
)
The metadata function for PHP returns an associative array, which is used in similar
fashion:
$size_info
=
get_enumorset_info
(
$dbh
,
"cookbook"
,
"cow_order"
,
"size"
);
print
(
make_radio_group
(
"size"
,
$size_info
[
"values"
],
$size_info
[
"values"
],
$size_info
[
"default"
],
TRUE
));
# display items vertically
print
(
make_popup_menu
(
"size"
,
$size_info
[
"values"
],
$size_info
[
"values"
],
$size_info
[
"default"
]));
The Python version of the metadata function returns a dictionary: