PHP PMA_getBinaryAndBlobColumn函数代码示例

/**
 * Get the HTML elements for value column in insert form
 * (here, "column" is used in the sense of HTML column in HTML table)
 *
 * @param array   $column                description of column in given table
 * @param string  $backup_field          hidden input field
 * @param string  $column_name_appendix  the name attribute
 * @param string  $onChangeClause        onchange clause for fields
 * @param integer $tabindex              tab index
 * @param integer $tabindex_for_value    offset for the values tabindex
 * @param integer $idindex               id index
 * @param string  $data                  description of the column field
 * @param string  $special_chars         special characters
 * @param array   $foreignData           data about the foreign keys
 * @param boolean $odd_row               whether row is odd
 * @param array   $paramTableDbArray     array containing $table and $db
 * @param integer $rownumber             the row number
 * @param array   $titles                An HTML IMG tag for a particular icon from
 *                                       a theme, which may be an actual file or
 *                                       an icon from a sprite
 * @param string  $text_dir              text direction
 * @param string  $special_chars_encoded replaced char if the string starts
 *                                       with a \r\n pair (0x0d0a) add an extra \n
 * @param string  $vkey                  [multi_edit]['row_id']
 * @param boolean $is_upload             is upload or not
 * @param integer $biggest_max_file_size 0 integer
 * @param string  $default_char_editing  default char editing mode which is stored
 *                                       in the config.inc.php script
 * @param array   $no_support_types      list of datatypes that are not (yet)
 *                                       handled by PMA
 * @param array   $gis_data_types        list of GIS data types
 * @param array   $extracted_columnspec  associative array containing type,
 *                                       spec_in_brackets and possibly
 *                                       enum_set_values (another array)
 *
 * @return string an html snippet
 */
function PMA_getValueColumn($column, $backup_field, $column_name_appendix, $onChangeClause, $tabindex, $tabindex_for_value, $idindex, $data, $special_chars, $foreignData, $odd_row, $paramTableDbArray, $rownumber, $titles, $text_dir, $special_chars_encoded, $vkey, $is_upload, $biggest_max_file_size, $default_char_editing, $no_support_types, $gis_data_types, $extracted_columnspec)
{
    // HTML5 data-* attribute data-type
    $data_type = $GLOBALS['PMA_Types']->getTypeClass($column['True_Type']);
    $html_output = '';
    if ($foreignData['foreign_link'] == true) {
        $html_output .= PMA_getForeignLink($column, $backup_field, $column_name_appendix, $onChangeClause, $tabindex, $tabindex_for_value, $idindex, $data, $paramTableDbArray, $rownumber, $titles);
    } elseif (is_array($foreignData['disp_row'])) {
        $html_output .= PMA_dispRowForeignData($backup_field, $column_name_appendix, $onChangeClause, $tabindex, $tabindex_for_value, $idindex, $data, $foreignData);
    } elseif ($GLOBALS['cfg']['LongtextDoubleTextarea'] && mb_strstr($column['pma_type'], 'longtext')) {
        $html_output = '&nbsp;</td>';
        $html_output .= '</tr>';
        $html_output .= '<tr class="' . ($odd_row ? 'odd' : 'even') . '">' . '<td colspan="5" class="right">';
        $html_output .= PMA_getTextarea($column, $backup_field, $column_name_appendix, $onChangeClause, $tabindex, $tabindex_for_value, $idindex, $text_dir, $special_chars_encoded, $data_type);
    } elseif (mb_strstr($column['pma_type'], 'text')) {
        $html_output .= PMA_getTextarea($column, $backup_field, $column_name_appendix, $onChangeClause, $tabindex, $tabindex_for_value, $idindex, $text_dir, $special_chars_encoded, $data_type);
        $html_output .= "\n";
        if (mb_strlen($special_chars) > 32000) {
            $html_output .= "</td>\n";
            $html_output .= '<td>' . __('Because of its length,<br /> this column might not be editable.');
        }
    } elseif ($column['pma_type'] == 'enum') {
        $html_output .= PMA_getPmaTypeEnum($column, $backup_field, $column_name_appendix, $extracted_columnspec, $onChangeClause, $tabindex, $tabindex_for_value, $idindex, $data);
    } elseif ($column['pma_type'] == 'set') {
        $html_output .= PMA_getPmaTypeSet($column, $extracted_columnspec, $backup_field, $column_name_appendix, $onChangeClause, $tabindex, $tabindex_for_value, $idindex, $data);
    } elseif ($column['is_binary'] || $column['is_blob']) {
        $html_output .= PMA_getBinaryAndBlobColumn($column, $data, $special_chars, $biggest_max_file_size, $backup_field, $column_name_appendix, $onChangeClause, $tabindex, $tabindex_for_value, $idindex, $text_dir, $special_chars_encoded, $vkey, $is_upload);
    } elseif (!in_array($column['pma_type'], $no_support_types)) {
        $html_output .= PMA_getValueColumnForOtherDatatypes($column, $default_char_editing, $backup_field, $column_name_appendix, $onChangeClause, $tabindex, $special_chars, $tabindex_for_value, $idindex, $text_dir, $special_chars_encoded, $data, $extracted_columnspec);
    }
    if (in_array($column['pma_type'], $gis_data_types)) {
        $html_output .= PMA_getHTMLforGisDataTypes();
    }
    return $html_output;
}

 /**
  * Test for PMA_getBinaryAndBlobColumn
  *
  * @return void
  */
 public function testGetBinaryAndBlobColumn()
 {
     $GLOBALS['cfg']['ProtectBinary'] = 'blob';
     $column = array();
     $column['is_blob'] = true;
     $column['Field_md5'] = '123';
     $column['pma_type'] = 'blob';
     $column['True_Type'] = 'blob';
     $GLOBALS['max_upload_size'] = 65536;
     $result = PMA_getBinaryAndBlobColumn($column, '12\\"23', null, 20, 'a', 'b', 'c', 2, 1, 1, '/', null, 'foo', true);
     $this->assertEquals('Binary - do not edit (5 B)<input type="hidden" name="fields_typeb" ' . 'value="protected" /><input type="hidden" name="fieldsb" value="" />' . '<br /><input type="file" name="fields_uploadfoo[123]" class="text' . 'field" id="field_1_3" size="10" c/>&nbsp;(Max: 64KiB)' . "\n", $result);
     // case 2
     $GLOBALS['cfg']['ProtectBinary'] = "all";
     $column['is_binary'] = true;
     $result = PMA_getBinaryAndBlobColumn($column, '1223', null, 20, 'a', 'b', 'c', 2, 1, 1, '/', null, 'foo', false);
     $this->assertEquals('Binary - do not edit (4 B)<input type="hidden" name="fields_typeb" ' . 'value="protected" /><input type="hidden" name="fieldsb" value="" ' . '/>', $result);
     // case 3
     $GLOBALS['cfg']['ProtectBinary'] = "noblob";
     $column['is_blob'] = false;
     $result = PMA_getBinaryAndBlobColumn($column, '1223', null, 20, 'a', 'b', 'c', 2, 1, 1, '/', null, 'foo', true);
     $this->assertEquals('Binary - do not edit (4 B)<input type="hidden" name="fields_typeb" ' . 'value="protected" /><input type="hidden" name="fieldsb" value="" ' . '/>', $result);
     // case 4
     $GLOBALS['cfg']['ProtectBinary'] = false;
     $column['is_blob'] = true;
     $column['is_char'] = true;
     $column['Type'] = 'char(255)';
     $GLOBALS['cfg']['TextareaRows'] = 20;
     $GLOBALS['cfg']['TextareaCols'] = 10;
     $GLOBALS['cfg']['CharTextareaRows'] = 5;
     $GLOBALS['cfg']['CharTextareaCols'] = 1;
     $GLOBALS['cfg']['LimitChars'] = 100;
     $result = PMA_getBinaryAndBlobColumn($column, '1223', null, 20, 'a', 'b', 'c', 2, 1, 1, '/', null, 'foo', true);
     $this->assertEquals("\na\n" . '<textarea name="fieldsb" class="char" maxlength="255" rows="5" cols="1" dir="/" ' . 'id="field_1_3" c tabindex="3"></textarea><br /><input type="file" ' . 'name="fields_uploadfoo[123]" class="textfield" id="field_1_3" ' . 'size="10" c/>&nbsp;(Max: 64KiB)' . "\n", $result);
     // case 5
     $GLOBALS['cfg']['ProtectBinary'] = false;
     $GLOBALS['cfg']['LongtextDoubleTextarea'] = true;
     $GLOBALS['cfg']['LimitChars'] = 100;
     $column['is_blob'] = false;
     $column['len'] = 255;
     $column['is_char'] = false;
     $GLOBALS['cfg']['TextareaRows'] = 20;
     $GLOBALS['cfg']['TextareaCols'] = 10;
     $result = PMA_getBinaryAndBlobColumn($column, '1223', null, 20, 'a', 'b', 'c', 2, 1, 1, '/', null, 'foo', true);
     $this->assertEquals("\na\n" . '<textarea name="fieldsb" class="" rows="20" cols="10" dir="/" ' . 'id="field_1_3" c tabindex="3"></textarea>', $result);
     // case 6
     $column['is_blob'] = false;
     $column['len'] = 10;
     $GLOBALS['cfg']['LimitChars'] = 40;
     /**
      * This condition should be tested, however, it gives an undefined function
      * PMA_getFileSelectOptions error:
      * $GLOBALS['cfg']['UploadDir'] = true;
      *
      */
     $result = PMA_getBinaryAndBlobColumn($column, '1223', null, 20, 'a', 'b', 'c', 2, 1, 1, '/', null, 'foo', true);
     $this->assertEquals("\na\n" . '<input type="text" name="fieldsb" value="" size="10" class=' . '"textfield" c tabindex="3" id="field_1_3" />', $result);
 }