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?
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)