How to replace urls of all pages in a certain category with database aliases?

Question

PHP

Hello!

There is an index.php file in the news directory.
If you go to the page with the get-parameter id, i.e. for example site.ru/news/?id=12, then information from the database about the news with id=12 will be displayed.

How can I replace all these urls with those that are recorded in the database for each news. Those. for example site.ru/news/?id=12should become site.ru/news/istoriya-companii.

As I understand it, you need to use mod_rewrite, but how to get aliases from the database?

Thanks in advance for the tips!

Answer 1

do you need
a million CNC options
https://rio-shaman.ru/razrabotka-cms/uluchshenija/... ?

Answer 2

Hint: there are approximately 100,500 answers to this question on this site.
Specifically, you don't need to receive any aliases for news.
the link should be of the form site.ru/news/12-istoriya-companii
from it you need to get only the number 12