"I don't exactly know how to ask the question." cnc using mysql query?

Question

PHP

Searched everywhere, found here one similar question. It offered an interesting option that makes cnc with minimal link processing intervention and using a mysql query.
Tell me how this method is called and where can I find an example or a lesson or a hint of something similar?
The principle is something like this:
The correct directory architecture is made, then with the help of php or Apache,
extra characters are removed "what is better to use: php with regular expressions or a mod for Apache or the same ngenix ??"
Well, at the end of the link is the very understandable url, `id`=`name_link`, from
name.domen/categore.php?name=29&id=2167 it turns out
name.domen/categore_name/nameurl
If so, how to do it?? In theory, there the number of requests to the database is reduced to one, if the request is correctly compiled)
You don’t even need to parse the yurl, if only because of the ending and there you already use the same expression for the kill /? etc..?

Answer 1

In WordPress, this is implemented using slugs. Those. once, based on the title, unique NCs are generated (My best article name => my-best-article-name), and they are searched in the database:
http://site.com/[category/]my-best- article-name
If you don't want to do this, you can just quietly substitute the id in the url:
http://site.com/[category/]id/my-best-article-name
Search engines will respond just as well, and you don't have to string search.