秋風落葉、萍水相逢 - Matt 程式 旅行 攝

首先先切換到information_schema;

mysql> use information_schema;

然後用以下:

mysql> select CONCAT("Alter Table `", TABLE_SCHEMA,"`.`", TABLE_NAME, "` Add Column...blah...") as MySQLCMD from TABLES where TABLE_SCHEMA = "test";

先安裝好PHP包含Extension(MSSQL)

通常這樣還是沒辦法連結到

需要安裝一個ODBC這類型的驅動程式才能連結到

PHP官網上的說明:

首先這部分override先引入

Ext.define('AppOverrides.grid.column.Action', {
    override: 'Ext.grid.column.Action',

    iconTpl: '<tpl for=".">' +
    '<tpl if="glyph">' +
    '<div class="{cls}" style="font-family:{glyphFamily};  font-size:14px; line-height: 15px;margin-left:5px; float: left;"<tpl if="tooltip"> data-qtip="{tooltip}"</tpl>>&#{glyph};</div>' +
    '<tpl else>' +
    '<img role="button" alt="{alt}" class="{cls}"<tpl if="tooltip"> data-qtip="{tooltip}"</tpl> />' +
    '</tpl>' +
    '</tpl>',
    defaultRenderer: function(v, meta, record, rowIdx, colIdx, store, view) {
        var me = this,
            prefix = Ext.baseCSSPrefix,
            scope = me.origScope || me,
            items = me.items,
            altText = me.altText,
            disableAction = me.disableAction,
            enableAction = me.enableAction,
            iconCls = me.iconCls,
            len = items.length,
            i = 0,
            iconTpl = new Ext.XTemplate(me.iconTpl),
            datas = [],
            item, itemScope, ret, disabled, tooltip, glyph, cls, data;
        // Allow a configured renderer to create initial value (And set the other values in the "metadata" argument!)
        // Assign a new variable here, since if we modify "v" it will also modify the arguments collection, meaning
        // we will pass an incorrect value to getClass/getTip
        ret = Ext.isFunction(me.origRenderer) ? me.origRenderer.apply(scope, arguments) || '' : '';
        meta.tdCls += ' ' + Ext.baseCSSPrefix + 'action-col-cell';
        for (; i < len; i++) {
            item = items[i];
            itemScope = item.scope || scope;
            disabled = item.disabled || (item.isDisabled ? item.isDisabled.call(itemScope, view, rowIdx, colIdx, item, record) : false);
            tooltip = disabled ? null : (item.tooltip || (item.getTip ? item.getTip.apply(itemScope, arguments) : null));
            glyph = item.glyph || item.getGlyph;
            cls = Ext.String.trim(prefix + 'action-col-icon ' + prefix + 'action-col-' + String(i) + ' ' + (disabled ? prefix + 'item-disabled' : ' ') + ' ' + (Ext.isFunction(item.getClass) ? item.getClass.apply(itemScope, arguments) : (item.iconCls || iconCls || '')));
            data = {
                cls: cls,
                tooltip: tooltip
            };
            // Only process the item action setup once.
            if (!item.hasActionConfiguration) {
                // Apply our documented default to all items
                item.stopSelection = me.stopSelection;
                item.disable = Ext.Function.bind(disableAction, me, [i], 0);
                item.enable = Ext.Function.bind(enableAction, me, [i], 0);
                item.hasActionConfiguration = true;
            }


            if (glyph) {
                if (Ext.isFunction(glyph)) {
                    glyph = glyph.call(itemScope, view, rowIdx, colIdx, item, record);
                }


                if (glyph) {
                    glyph = glyph.split('@');
                    data.glyph = glyph[0];
                    data.glyphFamily = glyph[1];
                } else {
                    data = false;
                }
            } else {
                data.alt = item.altText || altText;
                data.src = item.icon || Ext.BLANK_IMAGE_URL;
            }


            data && datas.push(data);
        }


        len && (ret += iconTpl.apply(datas));
        return ret;
    }
});

 然後找你要用的字型icon，我這邊使用的是Font awesome，之前(Web) Glyphicons - icon改用字型 有提到，有興趣可以去看一下

不過這邊顯示item的code不太一樣，不是用class，請參考這裡，使用的是xf26e這樣的編碼

範例如下:

因為目前公司主要使用的CSS Framework為Bootstrap

本身有內建了一組字型是用來顯示Icon用的

Bootstrap 

不過其實裡面的icon不多

由於Codeigniter是使用MVC架構，這類型架構的網址變動通常是靠絕對位址

但是也會提供一個設定去變換絕對位址，Codeigniter提供在Config.php裡面