PHP PMA_getHtmlForOptionsList函数代码示例

 /**
  * Tests for PMA_getHtmlForSelect() method.
  *
  * @return void
  * @test
  */
 public function testPMAGetHtmlForSelect()
 {
     $column = "labelColumn";
     $columnCandidates = array("option1", "option2", "option3");
     $visualizationSettings = array("labelColumn" => "option3", "height" => "10");
     $html = PMA_getHtmlForSelect($column, $columnCandidates, $visualizationSettings);
     $this->assertContains('<label for="' . $column . '">', $html);
     $this->assertContains(__("Label column"), $html);
     $output = PMA_getHtmlForOptionsList($columnCandidates, array($visualizationSettings[$column]));
     $this->assertContains($output, $html);
 }

 /**
  * Tests for PMA_getHtmlForColumn() method.
  *
  * @return void
  * @test
  */
 public function testPMAGetHtmlForColumn()
 {
     $column = 0;
     $columnCandidates = array("option1", "option2");
     $visualizationSettings = array("option2", "option3");
     $html = PMA_getHtmlForColumn($column, $columnCandidates, $visualizationSettings);
     $this->assertContains('<tr><td><label for="labelColumn">', $html);
     $this->assertContains(__("Label column"), $html);
     $output = PMA_getHtmlForOptionsList($columnCandidates, array($visualizationSettings[$column]));
     $this->assertContains($output, $html);
 }

/**
 * 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;
}

/**
 * Function to get html for the lebel column and spatial column
 *
 * @param string $column                the column type. i.e either "labelColumn"
 *                                      or "spatialColumn"
 * @param array  $columnCandidates      the list of select options
 * @param array  $visualizationSettings visualization settings
 *
 * @return string  $html
 */
function PMA_getHtmlForColumn($column, $columnCandidates, $visualizationSettings)
{
    $html = '<tr><td><label for="labelColumn">';
    $html .= $column == "labelColumn" ? __("Label column") : __("Spatial column");
    $html .= '</label></td>';
    $html .= '<td><select name="visualizationSettings[' . $column . ']" id="' . $column . '">';
    if ($column == "labelColumn") {
        $html .= '<option value="">' . __("-- None --") . '</option>';
    }
    $html .= PMA_getHtmlForOptionsList($columnCandidates, array($visualizationSettings[$column]));
    $html .= '</select></td>';
    $html .= '</tr>';
    return $html;
}