Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


how to implement hierarchical cms sites


how to implement hierarchical cms sites  using -'php,mysql,database,codeigniter,content-management-system'

I'm coding a little learning CMS project and I've hit a brick wall that's stopping me to complete the next step. I know I should be taking KISS (Keep It Simple, Stupid) into account, but I think it would nice, to be able to group pages hierarchicaly.

The problem is that I want page [root]->fruits->tropical->bananas to be accessible only from this url: http://localhost/cms/fruits/tropical/bananas/. What I came up with until now is that cms table has a parent field that points to its parent. The question is: How to parse uri adress and select a row from DB with as few queries/efficiently as possible?

Table structure:
Id
Slug
...
...
...
ParentId


All help and advice is kindly accepted.
    

asked Sep 15, 2015 by Ref7311
0 votes
10 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...