With this behavior, you can generate an URI for a single or combination of columns in your table. Some call it permalink, others call it slug or human readable url.

Check out the latest version at: github.com/mintao/yii-behavior-sluggable

| id | category | title                             |
|----+----------+-----------------------------------|
|  1 | security | NASA Server hacked by hacker kids |
| ...

http://your-blog.org/index.php?r=blog/show&id=1422

http://your-blog.org/security/nasa-server-hacked-by-hacker-kids

Google will love you ;)

• Add another column called "slug" to your table
• Download this extension and drop it into your protected/extensions folder,
• Add the behavior to your model (shown below)

If you're using git, I'd recommend:

cd <YOUR YII-PROJECT>
mkdir -p protected/extensions/behaviors (optional)
git submodule add git://github.com/mintao/yii-behavior-sluggable.git protected/extensions/behaviors/SluggableBehavior

/**
 * Behaviors for this model
 */
public function behaviors(){
  return array(
    'sluggable' => array(
      'class'=>'ext.behaviors.SluggableBehavior.SluggableBehavior',
      'columns' => array('category', 'title', 'author.name'),
      'unique' => true,
      'update' => true,
    ),
  );
}

• class Defines the path where to find the SluggableBehavor.php
• columns Needs to be an array of the fields to use for slug creation
• unique Set this to true to ensure a unique slug (Numbers will be added to duplicate slugs, if already existing)
• update Set this to true is every time you change the entry, the slug should be updated too. Set it to false, if the slug should be only created once

github.com/mintao/yii-behavior-sluggable

• 2011-04-30 Added update functionality
• 2011-06-23 Added support for dependent models (see demo configuration, author.name)