Routing via Database?

[eluser]Adam Griffiths[/eluser]
I did this for an old CMS I made.

Code:

// BEGIN FRESH DYNAMIC ROUTING

$connection = mysql_connect('localhost', 'user', 'pass');
mysql_select_db('db_name', $connection);

$query = mysql_query('SELECT * FROM routes');

while($result = mysql_fetch_array($query))
{
    $route[$result['fake_route']] = $result['real_route'];
}

mysql_close($connection);

// END FRESH DYNAMIC ROUTING

It's pretty simple, all you need inside the table is an id, the "fake" route (the first route in th CI route), and the real route (the part after the = sign).

Hopefully I made sense.