hide id with mod_rewrite

[raduenea]

Hi.

 

I have a link like this:

index.php?page=article-title&id=12

 

article-title and id are dynamical

 

How can I show in my address bar only: http://www.website.com/article-title/ 

not http://www.website.com/article-title/12/ 

 

What I must change in htaccess for this.

 

Thanks

[geudrik]

If you use mod-rewrite to hide the ID, it is no longer a variable - eg: you can't GET it from the URL without having it in the URL... instead, you should use a form and POST the id to the article display page.  Or just sanitize your GET variables...

[cags]

This can't be done purely via .htaccess, it's not magic, if the value isn't in the URL, then you can't use it in the script. You would need to update your script to fetch information from the database using 'article-title' instead of using the id (12). Basically you change the title to be the identifier of the article. Thus obviously it would need to be unique. Given the URL you describe it would seem you are already using mod_rewrite rules, these would just need a bit of tweaking to not match the id.

[raduenea]

If I fetch in databases using 'article-title' instead the id it will take longer to search for it ?

I know that if you search by id is much faster than text.

[cags]

Sure searching by id is probably quicker, but it's a matter of degrees. If you set the slug field to be an index, is that speed different actually going to be noticeable in a real-world environment?!

[raduenea]

Obviously, if I search by id or title in 5000 rows, the speed will be the same. I think the speed difference if the search it's made in over 10000 rows.