I have a database consisting of a table called "pages". I have a controller called "site" and a function called "page"... http://website.com/site/page/page_id.
In the page function it currently looks for the 3th URI segment (page_id), then finds and matches this to a page row in the database and displays the row results.
My question is, is it possible to route/change my URL from http://website.com/site/page/page_id to http://website.com/page_id. And then obviously change my function to find the first URI segment??
My current .htaccess file removes the "index.php", and looks like this:
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /db
#Removes access to the system folder by users.
#Additionally this will allow you to create a System.php controller,
#previously this would not have been possible.
#‘system’ can be replaced if you have renamed your system folder.
RewriteCond %{REQUEST_URI} ^system.*
RewriteRule ^(.*)$ /index.php/$1 [L]
#Checks to see if the user is attempting to access a valid file,
#such as an image or css document, if this isn’t true it sends the
#request to index.php
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
#This last condition enables access to the images and css folders, and the robots.txt file
#Submitted by Michael Radlmaier (mradlmaier)
RewriteCond $1 !^(index\.php|images|robots\.txt|css)
RewriteRule ^(.*)$ index.php/$1 [L]
</IfModule>
<IfModule !mod_rewrite.c>
# If we don’t have mod_rewrite installed, all 404’s
# can be sent to index.php, and everything works as normal.
# Submitted by: ElliotHaughin
ErrorDocument 404 /index.php
</IfModule>