hi..
how can i do to change this url:
http:www.example.com/index.php?category=article&id=12
to nicer URL by hiding the file extension or id, something like this:
http://www.example.com/article/article-title-goes-here/

I've found some solutions for that, that is by writing a regex in .httaccess file, but most of them still displayed id in URL like this:
http://www.example.com/article/12/ar...tle-goes-here/

is it possible if i want to hide the id and just display the title in URL, it might be something like this:
http://www.example.com/article/article-title-goes-here/

a lot of website uses such url, but i don't know exactly did those website perform the query based on title or id (id might be a primary_key), i think it is bad practice if the query based on title isn't it?

thx in advance!

It might be worth while looking at what blog systems these sites are using and looking at the source.

Example, if a site that is doing what you want is running wordpress, have a look at how wordpress does it.

Ive used a .htaccess file based on the wordpress seo friendly links for a while now and it works great but dosnt work quite how you want it to.

If your article titles are unique then you could just search from them in the url rather than id to begin with although im sure there is somthing wrong with that, that im missing.

yeah,
perhaps it uses title as an unique instead of id, right?

according to your opinion does wordpres also use this way to its article..???

it think it does, am i wrong?

I believe wordpress does allow this however im no wordpress expert, it would be worthwhile looking through the wordpress site.

yeah, i think so too..
lol

settings - permalinks you can change it there

Originally Posted by aadam

settings - permalinks you can change it there

how can i do that ?
i'm not so expert in this stuff.

Originally Posted by philips

how can i do that ?
i'm not so expert in this stuff.

Read this, http://codex.wordpress.org/Using_Permalinks

.htaccess
RewriteEngine on
RewriteBase /
RewriteRule article/(.*)/$ index.php?category=article&linktitle=$1 [L]

And you write in you database a field name linktitle, and your select would be like this.
select * from articles where linktitle='".$_REQUEST['linktitle']."'";

@perseadrin:
Thank you, that's exactly what i want

@aadam;
i've read it, it was very amazin. good solution.

@all:
thank you very much for all the answers.

Originally Posted by Phunk Rabbit

I believe wordpress does allow this however im no wordpress expert, it would be worthwhile looking through the wordpress site.

Yes wordpress does allow.

Originally Posted by Phunk Rabbit

It might be worth while looking at what blog systems these sites are using and looking at the source.

Example, if a site that is doing what you want is running wordpress, have a look at how wordpress does it.

Ive used a .htaccess file based on the wordpress seo friendly links for a while now and it works great but dosnt work quite how you want it to.

If your article titles are unique then you could just search from them in the url rather than id to begin with although im sure there is somthing wrong with that, that im missing.

Right....
I think too.