mod_rewrite how to get title from sql table in url but use id?
hello, pleaaase help me!
I have a php file "page.php" witch it gives the variable "id" from the url and shows a record WHERE id=$_GET['id'] .
I want to replace urls like "example.com/books/page.php?id=$id" (where $id can be anything numeric) with sth like "example.com/books/$id/title/"
where title and id are columns of sql table.
I want to know what to write in .htaccess file and how it gets the title from sql and writes it in front of $id in the url.
also I would like to titles Spaces be replaced by Dash sign.
my table is like :
id | title |
1 | an example |
witch then we should be able to use url "example.com/books/1/an-example/" instead of "example.com/books/page.php?id=1" .
Thanks a lot!
There are tutorials about URL rewrite everywhere in the internet. But for completion purposes A quick example of how to do rewrite:
The gist of rewrites is if you know regular expressions, you know how to do it.
Here is a cheatsheet for Apache rewrite.
All this is assuming you use Apache for web hosting server.
P.S. I didn't test the rewrite rule, just came about using your criteria
About this part:
I hope this helps.
|All times are GMT. The time now is 07:18 PM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0