How To Create New Pages Dynamically Without ? Sign

I don't know if I have described the title correctly, but the actual thing I want to achieve is mimic the way wordpress creates urls for new pages. I want to learn the mechanism of how these new URLs are created based on entries in the database. For instance, when you create a new page in wrodpress with title "First page", then dpending on your settings, wordpress will create a url for the page which would look something like "yourdomain.com/firstpage"

As no separate file is created for that specific page, so in principal this is similar to creating pages like "yourdomain.com/index.php?page=firstpage";.

The difference, according to my knowledge is that the second one doesn't involve the database while the first one (the wordpress one) does involve the databse. It reads the title of the page from the database and then depending on user settings, it creates a corresponding URL. The beauty of this type is that you don't need to create separate files for separate pages and it won't affect your SEO either.

So I just need to know how to create these URLs depending on the data in the database and how to make them act like permanent urls.

Well, you need to read some tutorial, but this can b achieved by mod rewrite if it's an apache server for the nice url's and a MySQL database for making it dynamic, where you store your pages from which you can select data and parse it the way you want to.

@quatrux can you mention a few good sources ??