How to route urls from the database with Yii

Yii 1.1 General Discussion
1

Hi Yii community,

I’m having problems with the route url in database

In file: main.php


'components' => array(

   ...

   'urlManager' => array(

      'class' => 'ext.MyUrlManager.MyUrlManager',

   ),

   ...

),

In folder extentions/MyUrlManager I have file MyUrlManager.php


class MyUrlManager extends CUrlManager{

	   public $dbTable = 'UrlRules';


		protected function processRules(){

			echo 123456;

			/*$dbCommand = Yii::app()->db->createCommand("SELECT `pattern`, `route` FROM `{$this->dbTable}`")->execute();

			$urlRules = $dbCommand->readAll();


			foreach ($urlRules as $pattern => $route){

				$this->rules[$pattern] = $route;

			}*/


			parent::processRules();

		}

	}

But it is empty. Please show me how to fix. Thanks

2

I am already successfully. You should use public function addRules($rules, $append=true){}.

User: $this->addRules(array(‘viet-nam’ => ‘vietnam/default/index’));


<?php

class MyUrlManager extends CUrlManager{

	public $dbTable = 'urls';


	protected function processRules(){

		$command = Yii::app()->db->createCommand("SELECT `pattern`, `route` FROM {$this->dbTable}");

        $urlRules = $command->queryAll();


		foreach ($urlRules as $value){

			//$this->addRules(array('viet-nam' => 'vietnam/default/index'));

			$this->addRules(array($value['pattern'] => $value['route']));

		}

		parent::processRules();

	}

}

Have fun