settings Follow @yiiframework

class SettingsController extends Controller
{
 
    public function actionIndex()
    {
        $settings = app()->settings;
 
        $model = new SettingsForm();
 
        if (isset($_POST['SettingsForm'])) {
            $model->setAttributes($_POST['SettingsForm']);
            $settings->deleteCache();
            foreach($model->attributes as $category => $values){
                $settings->set($category, $values);
            }
            user()->setFlash('success', 'Site settings were updated.');
            $this->refresh();
        }
        foreach($model->attributes as $category => $values){
            $cat = $model->$category;
            foreach($values as $key=>$val){
                $cat[$key] = $settings->get($category, $key);
            }
            $model->$category = $cat;
        }
        $this->render('index', array('model' => $model));
    }
 
}

class SettingsForm extends CFormModel
{
 
    public $site = array(
        'name' => '',
        'googleAPIKey' => '',
        'numSearchResults' => '',
        'defaultLanguage' => '',
        'defaultCurrency' => '',
    );
    public $seo = array(
        'mainTitle' => '',
        'mainKwrds' => '',
        'mainDescr' => ''
    );
    public $mail = array(
        'adminEmail' => '',
        'fromReply' => '',
        'fromNoReply' => '',
        'server' => '',
        'port' => '',
        'user' => '',
        'password' => '',
        'ssl' => '',
    );
    public $filter = array(
        'priceLower'=>'',
        'priceUpper'=>'',
    );
 
    /**
     * Declares customized attribute labels.
     * If not declared here, an attribute would have a label that is
     * the same as its name with the first letter in upper case.
     */
    public function getAttributesLabels($key)
    {
        $keys = array(
            'googleAPIKey' => 'Google API Key',
            'numSearchResults' => 'Number of search results at one page',
            'mainTitle' => 'Main Page Title',
            'mainKwrds' => 'Default Keywords (Meta Tag)',
            'mainDescr' => 'Default Description (Meta Tag)',
        );
 
        if(array_key_exists($key, $keys))
            return $keys[$key];
 
        $label = trim(strtolower(str_replace(array('-', '_'), ' ', preg_replace('/(?<![A-Z])[A-Z]/', ' \0', $key))));
        $label = preg_replace('/\s+/', ' ', $label);
 
        if (strcasecmp(substr($label, -3), ' id') === 0)
            $label = substr($label, 0, -3);
 
        return ucwords($label);
    }
 
    /**
     * Sets attribues values
     * @param array $values
     * @param boolean $safeOnly
     */
    public function setAttributes($values,$safeOnly=true) 
    { 
        if(!is_array($values)) 
            return; 
 
        foreach($values as $category=>$values) 
        { 
            if(isset($this->$category)) {
                $cat = $this->$category;
                foreach ($values as $key => $value) {
                    if(isset($cat[$key])){
                        $cat[$key] = $value;
                    }
                }
                $this->$category = $cat;
            }
        } 
    }
}

<h3>Site Settings</h3>
 
<?php echo CHtml::errorSummary($model); ?>
<?php
echo CHtml::beginForm();
?>
<ul class="nav nav-tabs" id="site-settings">
<?php
 
$tabs = array();
$i = 0;
    foreach ($model->attributes as $category => $values):?>
        <li<?php echo !$i?' class="active"':''?>><a href="#<?php echo $category?>" data-toggle="tab"><?php echo ucfirst($category)?></a></li>
    <?php 
    $i ++;
    endforeach;?>
</ul>
    <div class="tab-content">
        <?php 
        $i = 0;
        foreach ($model->attributes as $category => $values):?>
            <div class="tab-pane<?php echo !$i?' active':''?>" id="<?php echo $category?>">
                <?php
                $this->renderPartial(
                        '_'.$category, 
                        array('model' => $model, 'values' => $values, 'category' => $category)
                    );
                ?>
            </div>
        <?php 
        $i ++;
        endforeach;?>
    </div>
<?php
echo CHtml::submitButton('Submit', array('class' => 'btn'));
echo CHtml::endForm();

<?php foreach ($values as $key => $val): ?>
    <div class="control-group">
        <?php echo CHtml::label($model->getAttributesLabels($key), $key); ?>
        <?php 
        if($key === 'ssl')
            echo CHtml::checkBox(get_class($model) . '[' . $category . '][' . $key . ']', $val); 
        else 
            echo CHtml::textField(get_class($model) . '[' . $category . '][' . $key . ']', $val, array('class'=>'input-xxlarge')); 
 
        ?>
        <?php echo CHtml::error($model, $category); ?>
    </div>
<?php endforeach; ?>

/**
 * Shortcut for Yii::app()->settings->get();
 * @param string $param 
 */
function sg($category, $key){
    return Yii::app()->settings->get($category, $key);
}

sg('site', 'name');

protected $_dbComponentId='db';
    protected $_tableName='{{settings}}';
    protected $_idColumn='id';
    protected $_categoryColumn='category';
    protected $_keyColumn='key';
    protected $_valueColumn='value';
    protected $_createTable=false;
    protected $_dbEngine='InnoDB';
    protected $_defaultCategory='system';
.......
.......
    protected function createTable()
    {
        $connection=$this->getDbComponent();
        $tableName=$connection->tablePrefix.str_replace(array('{{','}}'), '', $this->getTableName());
        $sql='CREATE TABLE IF NOT EXISTS `'.$tableName.'` (
          `'.$this->_idColumn.'` int(11) NOT NULL auto_increment,
          `'.$this->_categoryColumn.'` varchar(64) NOT NULL default \''.$this->_defaultCategory.'\',
          `'.$this->_keyColumn.'` varchar(255) NOT NULL,
          `'.$this->_valueColumn.'` text NOT NULL,
          PRIMARY KEY  (`'.$this->_idColumn.'`),
          KEY `'.$this->_categoryColumn.'_key` (`'.$this->_categoryColumn.'`,`'.$this->_keyColumn.'`)
        ) '.($this->getDbEngine() ? 'ENGINE='.$this->getDbEngine() : '').'  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; ';
        $command=$connection->createCommand($sql);
        $command->execute();
    }

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{settings}} WHERE `category`='bidon' AND `key`='appname' LIMIT 1' at line 1. The SQL statement executed was: SELECT id FROM {{settings}} WHERE `category`=:cat AND `key`=:key LIMIT 1 
 
.../yii/framework/db/CDbCommand.php(528)

Yii::app()->settings->clearCache(); //clear all the cached content  
Yii::app()->settings->clearCache('category'); // clear only this category cache.

foreach($result AS $row)
                $items[$row['key']] = @unserialize($row['value']);

foreach($result AS $row) {
                $value = @unserialize($row['value']);
                if ($value === false)
                    $value = $row['value'];
                $items[$row['key']] = $value;
            }

public $tableName = 'settings'; /*default name is your name for those guys who           firstly use this setting feature,and use your schema above .*/
    public $idAttribute='id';
    public $categoryAttribute='category';
    public $keyAttribute='key';
        public $valueAttribute='value';