Quick htaccess mod_rewrite question

jdk · 05-23-2011, 03:32 PM

I am trying to do the following:

www.domain.com/play/Pacman

will go to

www.domain.com/play.php?game=Pacman

I want to then on play.php have a variable $game that I can use to search a MySQL database for the gamename and display the appropriate details.
????: NamePros.com http://www.namepros.com/programming/715966-quick-htaccess-mod_rewrite-question.html

Reading some tutorials I have the following but it is not working for some reason:

Code:

RewriteEngine on

RewriteRule ^game/([^/]*)\.html$ /play.php?game=$1 [L]

Any help? Also, how do I call the $game variable on the play.php? Do I need to do a $thename=$_GET[] ?? htaccess is not one of my strong points and I have been reading tutorials for over an hour without any luck.

un4given[MAD] · 05-23-2011, 04:04 PM

I would have done it this way:

Code:

RewriteEngine on
RewriteRule ^play/([a-zA-Z0-9]+)/?$	/play.php?game=$1 [L]

([a-zA-Z0-9]+) - this will be substitution for $1 (game name)
????: NamePros.com http://www.namepros.com/showthread.php?t=715966
[a-zA-Z0-9] - allowed characters in game name, you may alter this set if you intend to use another characters;
+ means that there can be more than one character (word);
/? - for both '/play/Pacman' and '/play/Pacman/' variants.;

Then, all you need is to get game name in your play.php file:

Code:

$gameName = isset($_GET["game"])?$_GET["game"]:"";

You should also sanitize $gameName variable to avoid SQL-injections before passing that variable to MySQL query.

jdk · 05-23-2011, 04:56 PM

[a-zA-Z0-9]

So if I want a space, ! or - or ' I would make it

[a-zA-Z0-9!'- ] ??? (note the space before the end bracket)?

un4given[MAD] · 05-23-2011, 05:21 PM

Originally Posted by jdk

So if I want a space, ! or - or ' I would make it [a-zA-Z0-9!'- ] ???

Well, almost

There are some tricks: in this particular case space should be escaped with \ and - should be the last character in []

So, finally it will look like this:

Code:

[a-zA-Z0-9!'\ -]

However, if you don't need such detailed control of input, you may use following rule:

Code:

RewriteRule ^play/(.+)/?$	/play.php?game=$1 [L]

Here . means 'any single character (including space) except end of line'
And + means 1 or more characters defined by .

If you need more information about regular expressions in .htaccess, you can follow this link.

jdk · 05-23-2011, 06:15 PM

Thanks repped.

05-23-2011, 03:32 PM	THREAD STARTER #1 (permalink)
jdk Senior Member Join Date: Jul 2004 Location: Florida Posts: 1,496	Quick htaccess mod_rewrite question I am trying to do the following: www.domain.com/play/Pacman will go to www.domain.com/play.php?game=Pacman I want to then on play.php have a variable $game that I can use to search a MySQL database for the gamename and display the appropriate details. ????: NamePros.com http://www.namepros.com/programming/715966-quick-htaccess-mod_rewrite-question.html Reading some tutorials I have the following but it is not working for some reason: Code: RewriteEngine on RewriteRule ^game/([^/])\.html$ /play.php?game=$1 [L] Any help? Also, how do I call the $game variable on the play.php? Do I need to do a $thename=$_GET[] ?? htaccess is not one of my strong points and I have been reading tutorials for over an hour without any luck. __________________ All offers are valid for 12 hours unless otherwise stated. Last edited by jdk; 05-23-2011 at 03:55 PM.*

05-23-2011, 04:04 PM	#2 (permalink)
un4given[MAD] NamePros Member Join Date: Aug 2008 Location: Solar System \ Earth \ Ukraine \ Kiev Posts: 43	I would have done it this way: Code: RewriteEngine on RewriteRule ^play/([a-zA-Z0-9]+)/?$ /play.php?game=$1 [L] ([a-zA-Z0-9]+) - this will be substitution for $1 (game name) ????: NamePros.com http://www.namepros.com/showthread.php?t=715966 [a-zA-Z0-9] - allowed characters in game name, you may alter this set if you intend to use another characters; + means that there can be more than one character (word); /? - for both '/play/Pacman' and '/play/Pacman/' variants.; Then, all you need is to get game name in your play.php file: Code: $gameName = isset($_GET["game"])?$_GET["game"]:""; You should also sanitize $gameName variable to avoid SQL-injections before passing that variable to MySQL query. __________________ Tired playing Freecell, Klondike or Spider? Discover 800 solitaire games at SolitairesUnlimited.com and play'em all!

05-23-2011, 04:56 PM	THREAD STARTER #3 (permalink)
jdk Senior Member Join Date: Jul 2004 Location: Florida Posts: 1,496	[a-zA-Z0-9] So if I want a space, ! or - or ' I would make it [a-zA-Z0-9!'- ] ??? (note the space before the end bracket)? __________________ All offers are valid for 12 hours unless otherwise stated.

05-23-2011, 06:15 PM	THREAD STARTER #5 (permalink)
jdk Senior Member Join Date: Jul 2004 Location: Florida Posts: 1,496	Thanks repped. __________________ All offers are valid for 12 hours unless otherwise stated.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)