What is the best way to implement cnc?

Question

PHP

Hello.

I'm doing CNC now and outputting data. My question is how best to do this. Now my cnc looks like this site.ru/12-kak-prigotovit-riby (I do it through mod rewrite)

When adding a post, I first add all the form data to the database, then I get the last added post by id and then I form the link in this way: id + title (translated from Russian into English) and change the url value in the post table.

It turns out that earlier, when displaying the data of a certain post, I received its id via get, and now I get the url because it is also unique due to the id that I add. Whether I’m doing the right thing or it’s worth it somehow differently, I just need advice so that I don’t do a lot of work in vain and immediately go in the right direction.