.htaccess url rewrite issue

[thetrooper1234]

Hello everyone. I am having an issue with creating a rewrite for blog posts. Here is my .htaccess file.

It doesn't work as intended.

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ index.php [QSA,L]
RewriteRule ^views/blog/?$ page.php?slug=/blog/ [L]
RewriteRule ^views/blog/(.*)/?([0-9]*) page.php?page_slug=/blog/$1/$2 [L]

index.php file points to the index.php in the views folder.
Here is my folder stucture:

root folder >  views > blog > page.php

The structure I'm trying to create is the following for any blog posts to be:

mydomain.com/blog/post-title

Any help would be much appriciated.

[requinix]

So /blog/post-title does not exist as a file, right?

[thetrooper1234]

12 hours ago, requinix said:

So /blog/post-title does not exist as a file, right?

That's right. It's a in the database in a field "page_slug" associated with the page. In this case it's called "post-title"

[requinix]

What are the rules in that .htaccess going to do if a file doesn't exist?

[thetrooper1234]

56 minutes ago, requinix said:

What are the rules in that .htaccess going to do if a file doesn't exist?

The page is page.php

I was under the impression that dynamic links retrieving from a database can have better urls created for SEO? I might be completely wrong?

[requinix]

Doesn't quite answer my question.

The very first rule you have

RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ index.php [QSA,L]

says that anything that does not exist should go to index.php. If you want other things to apply first, other things that also do not exist, then those rules need to go before it.