<?= PMA\libraries\Util::getDivForSliderEffect(
'searchoptions', __('Options')
); ?>
<!-- Displays columns select list for selecting distinct columns in the search -->
<fieldset id="fieldset_select_fields">
<legend>
<?= __('Select columns (at least one):'); ?>
</legend>
<select name="columnsToDisplay[]"
size="<?= min(count($columnNames), 10); ?>"
multiple="multiple">
<?php
/**
* Displays the list of the fields
*/
foreach ($columnNames as $each_field): ?>
<option value="<?= htmlspecialchars($each_field); ?>"
selected="selected">
<?= htmlspecialchars($each_field); ?>
</option>
<?php endforeach; ?>
</select>
<input type="checkbox"
name="distinct"
value="DISTINCT"
id="oDistinct" />
<label for="oDistinct">
DISTINCT
</label>
</fieldset>
<!-- Displays input box for custom 'Where' clause to be used in the search -->
<fieldset id="fieldset_search_conditions">
<legend>
<em><?= __('Or'); ?></em>
<?= __('Add search conditions (body of the "where" clause):'); ?>
</legend>
<?= PMA\libraries\Util::showMySQLDocu('Functions'); ?>
<input type="text" name="customWhereClause" class="textfield" size="64" />
</fieldset>
<!-- Displays option of changing default number of rows displayed per page -->
<fieldset id="fieldset_limit_rows">
<legend><?= __('Number of rows per page'); ?></legend>
<input type="number"
name="session_max_rows"
required="required"
min="1"
value="<?= intval($GLOBALS['cfg']['MaxRows']); ?>"
class="textfield" />
</fieldset>
<!-- Displays option for ordering search results by a column value (Asc or Desc) -->
<fieldset id="fieldset_display_order">
<legend><?= __('Display order:'); ?></legend>
<select name="orderByColumn"><option value="--nil--"></option>
<?php foreach ($columnNames as $each_field): ?>
<option value="<?= htmlspecialchars($each_field); ?>">
<?= htmlspecialchars($each_field); ?>
</option>
<?php endforeach; ?>
</select>
<?= PMA\libraries\Util::getRadioFields(
'order',
array(
'ASC' => __('Ascending'),
'DESC' => __('Descending')
),
'ASC',
false,
true,
"formelement"
); ?>
</fieldset>
<br style="clear: both;" />