SEO网址与kohana策略

Question

I want to use SEO urls in kohana, I already use htaccess file so I can have www.food.com/food/3123

Id:3123 title:hotdog

but thats not SEO friendly ,how would I get it to www.food.com/food/hotdog ? or www.food.com/food/I-love-hotdog ?

Searching DB with hotdog or I-love-hotdog is wrong right?

Ive read around some say do this www.food.com/food/3123/hotdog or www.food.com/food/hotdog3123 then parse it

Has anyone got the right way to do it? or better yet the structure?

Answer 1

Searching with "hotdog" or "I-love-hotdog" is rather OK. You can store additional field in DB table named "url" (for example). Note that "url" field MUST be uinique. Then in application/bootstrap.php create correct routes which will serve your requests taking url part of product and then search it in DB with controller.

Making http://stackoverflow.com/questions/10202703 automaticaly redirect to http://stackoverflow.com/questions/10202703/seo-urls-with-kohana-strategy is possible with Kohana's $this->request->redirect() (Request::redirect()) method. In controller you get the ID of item (in our example 10202703) then find corresponding URL (seo-urls-with-kohana-strategy) of item and redirect to $this->request->uri().'/'.$item_url by $this->request->redirect('/'.$this->request->uri().'/'.$item_url)