I'm trying to understand the dynamic web pages. Someone can explain to me what index.php is for?

What I understand is that based on Title or Content, the script inside that file makes a query to the database and generate a certain page.

Basically is it a file that redirects the user based on requests?

(I'm not sure it's a duplicate, but checking i found nothing)