v5:reference:recordset:getmenu
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:reference:recordset:getmenu [2019/01/01 22:42] – mnewnham | v5:reference:recordset:getmenu [2019/11/24 00:16] (current) – Add wrap around fetch mode note dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== getMenu ====== | ====== getMenu ====== | ||
- | <WRAP info> | ||
- | You must set ADODB_FETCH_MODE to ADODB_FETCH_NUM before calling this method. | ||
- | </ | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
<WRAP right box> | <WRAP right box> | ||
== See Also == | == See Also == | ||
- | [[v5: | + | [[v5: |
- | [[v5: | + | [[v5: |
== Syntax == | == Syntax == | ||
string getMenu( | string getMenu( | ||
- | | + | string $selectName, |
optional mixed $defaultValue=false, | optional mixed $defaultValue=false, | ||
- | optional | + | optional |
- | optional bool $multiple=fale, | + | optional bool $multiple=false, |
optional int $numberOfRows=0, | optional int $numberOfRows=0, | ||
optional string $optionalAttributes='', | optional string $optionalAttributes='', | ||
Line 22: | Line 19: | ||
</ | </ | ||
===== Description ===== | ===== Description ===== | ||
- | The function '' | + | |
+ | The function '' | ||
+ | |||
+ | If the recordset | ||
+ | If it has 2 columns, the first one is the description and the second | ||
+ | |||
+ | Any extra column beyond the first two will be discarded. | ||
+ | |||
+ | <WRAP info left> | ||
+ | Until ADOdb 5.20.13, this method required that [[v5: | ||
+ | </ | ||
===== Parameters ===== | ===== Parameters ===== | ||
==== $selectName ===== | ==== $selectName ===== | ||
name of SELECT tag | name of SELECT tag | ||
==== $defaultValue ==== | ==== $defaultValue ==== | ||
- | The value to highlight. Use an array for multiple | + | The value to highlight. Use either a string for a single value to match, or a numeric |
==== $blankFirstLine ==== | ==== $blankFirstLine ==== | ||
- | true to leave the 1st item in list empty | + | This parameter has the following available options: |
+ | |||
+ | * true (default) - creates an empty ''< | ||
+ | * false - does not creates an empty ''< | ||
+ | * string value - creates an ''< | ||
+ | * string value format '' | ||
==== $multiple ==== | ==== $multiple ==== | ||
Set true to create a multi-select box | Set true to create a multi-select box | ||
==== $numberOfRows ==== | ==== $numberOfRows ==== | ||
- | Number of rows to show for multi-select box | + | Number of rows to show for multi-select box. If. a multi-select box is not created, this field has no meaning. |
==== $optionalAttributes ==== | ==== $optionalAttributes ==== | ||
- | Additional attributes to defined for SELECT tag, useful for holding javascript onChange=' | + | Additional attributes to defined for SELECT tag, useful for holding javascript onChange=' |
==== $compareAgainstFirstCol ==== | ==== $compareAgainstFirstCol ==== | ||
- | When we have 2 cols in recordset, we compare | + | If we have 2 columns, by default |
===== Usage ===== | ===== Usage ===== | ||
<code php> | <code php> | ||
Line 46: | Line 60: | ||
$result = $db-> | $result = $db-> | ||
- | $html = $result-> | + | $html = $result-> |
+ | ' | ||
+ | | ||
+ | | ||
+ | | ||
+ | ' | ||
print $html | print $html | ||
- | */ | + | |
</ | </ | ||
<code html> | <code html> | ||
- | <select name=" | + | <select name=" |
< | < | ||
<option value=' | <option value=' |
v5/reference/recordset/getmenu.1546378933.txt.gz · Last modified: 2019/01/01 22:42 by mnewnham