Posted by Geradeaus on 08/07/07 09:11

I use mod_rewrite all the time, but I was still asking myself how you
combine it with a database.

e.g. you have an article with the title : "Mac, windows or linux. Who
will tell?"

so I can get something like this : http:///www.domain.com/article/mac-windows-or-linux-who-will-tell
What should I do?

1. just urlencode the title (but then I have problems with the ,
and .)

2. use a regular expression to filter out the special characters
(replace spaces and ", ." by "-" ... etc) and save the filtered-title
into the database? When I want to search for this article I just
perform a regular expression on the title string and search for it in
the databse: WHERE title = ".regularexpressionfunction($title)."

3. Or don't you save this title into the database, but do you always
perform this regular expression while searching in the database? e.g.
WHERE REGEX(title) LIKE '".regularexpressionfunction($title)."'

I have been googling for a long time, but I can't find a descent
article about this ...

thanks for your help!

[Back to original message]