How to organize the verification of categories?

Question

Hello! I decided to create categories with infinite nesting. Of course in practice will not exceed 5.

There is a base

With columns: id, name, url, parent .

How to correctly identify the current category by checking all parental existence? Maybe there are ready solutions for codeigniter?

Everything would be simple if the url had their id. How to do here?

You need to get the id categories, check the chain for correctness and not to create a strong load on the database.

@ navi1893, what if 2 child categories come across with the same url?
For example, localhost / computer / other and localhost / tv / other .
> How to correctly identify the current category by checking all parental existence?
Going cycle up (or down) one at a time and giving 404 on a mismatch.

alex159 alex159 680 3 nineteen · Accepted Answer · 2017-08-26T15:16:21

Solved. Going cycle up (or down) one at a time and giving 404 on a mismatch.

1 answer 1