/**
* Get the HTML for the set column dropdown
* During grid edit, if we have a set field, returns the html for the
* dropdown
*
* @param string $db current database
* @param string $table current table
* @param string $column current column
* @param string $curr_value currently selected value
*
* @return string $dropdown html for the set column
*/
function PMA_getHtmlForSetColumn($db, $table, $column, $curr_value)
{
$values = PMA_getValuesForColumn($db, $table, $column);
$dropdown = '';
//converts characters of $curr_value to HTML entities
$converted_curr_value = htmlentities($curr_value, ENT_COMPAT, "UTF-8");
$selected_values = explode(',', $converted_curr_value);
$dropdown .= PMA_getHtmlForOptionsList($values, $selected_values);
$select_size = sizeof($values) > 10 ? 10 : sizeof($values);
$dropdown = '<select multiple="multiple" size="' . $select_size . '">' . $dropdown . '</select>';
return $dropdown;
}
/**
* Get the HTML for the set column dropdown
* During grid edit, if we have a set field, returns the html for the
* dropdown
*
* @param string $db current database
* @param string $table current table
* @param string $column current column
* @param string $curr_value currently selected value
*
* @return string $dropdown html for the set column
*/
function PMA_getHtmlForSetColumn($db, $table, $column, $curr_value)
{
$values = PMA_getValuesForColumn($db, $table, $column);
$dropdown = '';
$full_values = isset($_REQUEST['get_full_values']) ? $_REQUEST['get_full_values'] : false;
$where_clause = isset($_REQUEST['where_clause']) ? $_REQUEST['where_clause'] : null;
// If the $curr_value was truncated, we should
// fetch the correct full values from the table
if ($full_values && !empty($where_clause)) {
$curr_value = PMA_getFullValuesForSetColumn($db, $table, $column, $where_clause);
}
//converts characters of $curr_value to HTML entities
$converted_curr_value = htmlentities($curr_value, ENT_COMPAT, "UTF-8");
$selected_values = explode(',', $converted_curr_value);
$dropdown .= PMA_getHtmlForOptionsList($values, $selected_values);
$select_size = sizeof($values) > 10 ? 10 : sizeof($values);
$dropdown = '<select multiple="multiple" size="' . $select_size . '">' . $dropdown . '</select>';
return $dropdown;
}
