Help with MOD_REWRITE PLZ!

JuggernautH · 05-17-2007, 05:19 AM

Hi, currently building something for a site i am going to relaunch

I want index.php?id=3 rewritten so it makes it show the name like this name-nextword-lastword_1.html and so on.

You get the point, how would i do that? If you need to see the code i use i can supply it to honest people.

-NC- · 05-17-2007, 05:49 AM

Do you have 3 = name-nextword-lastword stored anywhere e.g. a database?

Or is the name-nextword-lastword simply hardcoded in the href?

Here is an example to turn

/3/ into index.php?id=3

Options +FollowSymLinks
Options +Indexes
RewriteEngine On
RewriteBase /
RewriteCond %{SCRIPT_FILENAME} !-f
RewriteCond %{SCRIPT_FILENAME} !-d
RewriteRule ^/([^/]+)/?$ index.php?id=$1 [NC,L]

If the name-nextword-lastword is simply hardcoded in the href, you could do:

/3/name-nextword-lastword/

Options +FollowSymLinks
Options +Indexes
RewriteEngine On
RewriteBase /
RewriteCond %{SCRIPT_FILENAME} !-f
RewriteCond %{SCRIPT_FILENAME} !-d
RewriteRule ^/([^/]+)/([^/]+)/?$ index.php?id=$1 [NC,L]

disclaimer: I'm no mod_rewrite master

JuggernautH · 05-17-2007, 05:54 AM

Just got the titles in the db, basicly like this "Welcome to site" for example. Would this do the trick?
None of those apparently worked

-NC- · 05-17-2007, 06:23 AM

The good news:
You're in good shape if you've got the titles/id's in the DB!

The bad news:
I think you're going to need some additional php to:

get the title from the url
modify it so that it looks like the title in the db
query the db to get the ID

e.g.
url:
/name-nextword-lastword/

rewrite:
RewriteRule ^/([^/]+)/?$ index.php?name=$1 [NC,L]

index.php
(pseudo code)
$dbname = str_replace('-', ' ', $_GET['name']);

(replace the underscores with spaces)

select id from database where title = $dbname

Oh erm, just to clarify, your example url:
name-nextword-lastword_1.html

"1" isnt the ID is it?

JuggernautH · 05-17-2007, 06:34 AM

Hey, you got msn or something we can chat over? Could show you how the code looks like in that case, would be realy nice of you

-NC- · 05-17-2007, 07:45 AM

Sorry, I'm at work, can only reply when the boss is not looking!

JuggernautH · 05-17-2007, 08:34 AM

Hehe okay :P

Dan · 05-17-2007, 12:56 PM

Code:

RewriteEngine on
RewriteRule ^[_a-zA-Z0-9]*-[_a-zA-Z0-9]*-[_a-zA-Z0-9]*-([0-9]*)?\.html index.php?id=$1

(site.com/something-hola-yay-3.html)

Put that in your .htaccess. You'll just need to make sure you use 3 words, followed by the id.

-NC- · 05-17-2007, 03:46 PM

Yeah that should work great as long as that number at the end is the ID!
(I was wondering if I had overlooked the obvious there....)

Nice regexp skills Dan!

edit: just noticed your title in your postbit, love the subliminal advertising message!

JuggernautH · 05-17-2007, 04:01 PM

Alright thanks Dan, will test that later. How would i go if i wanted to do it like this "index.php?id=1" to "review_1.html" for example? The review word will be same for all of the pages.

Thanks for any answers!

-NC- · 05-17-2007, 04:12 PM

^[_a-zA-Z0-9]*-[_a-zA-Z0-9]*-[_a-zA-Z0-9]*-([0-9]*)?\.html

Actually, there is an underscore at the end, so should it be:

^[_a-zA-Z0-9]*-[_a-zA-Z0-9]*-[_a-zA-Z0-9]*_([0-9]*)?\.html

or if underscore is a special char in .htaccess, it would be:

^[_a-zA-Z0-9]*-[_a-zA-Z0-9]*-[_a-zA-Z0-9]*\_([0-9]*)?\.html

JuggernautH, it should work fine as long as there is only ever 3 words including review. Are you asking what if you have any number of hypen delimited words before the review_{id}.html?

JuggernautH · 05-17-2007, 04:15 PM

Yes i would need to know that as well what would i put in the htaccess if i wanted to list review-{id}.html for example

-NC- · 05-17-2007, 04:26 PM

hmm, should be easy actually!

I guess Dan will be able to correct me if I'm wrong, but in that case, all we care about is the _{number}.html

So, here goes:
^[\-_a-zA-Z0-9]*\_([0-9]*)?\.html

There's definitely a better regex than that though, here's another attempt:

^/([^/\_]+)\_([0-9]*)?\.html

Guess I should actually fire up apache and test!

JuggernautH · 05-17-2007, 04:33 PM

Could you write me up the whole code for it? Kind of novice on this stuff myself :P

Tryed for a while myself and i managed to get it working

Thanks for all help!

Code:

RewriteRule ^review_([0-9]+).html reviews.php?id=$1 [L,NC]

That's what i used!

Dan & RCRiver:
Go to www.hideurl.info/reviews.html to check the script live

If you want i can review one each of your sites for free and put it there

05-17-2007, 05:19 AM	#1 (permalink)
JuggernautH Account Closed Join Date: Dec 2005 Location: ../home/mysite Posts: 3,566 37.00 NP$ (Donate)	Help with MOD_REWRITE PLZ! Hi, currently building something for a site i am going to relaunch I want index.php?id=3 rewritten so it makes it show the name like this name-nextword-lastword_1.html and so on. You get the point, how would i do that? If you need to see the code i use i can supply it to honest people.

05-17-2007, 05:49 AM	#2 (permalink)
-NC- Traveller Join Date: Mar 2007 Location: Yet another city Posts: 1,392 614.57 NP$ (Donate)	Do you have 3 = name-nextword-lastword stored anywhere e.g. a database? Or is the name-nextword-lastword simply hardcoded in the href? Here is an example to turn /3/ into index.php?id=3 Options +FollowSymLinks Options +Indexes RewriteEngine On RewriteBase / RewriteCond %{SCRIPT_FILENAME} !-f RewriteCond %{SCRIPT_FILENAME} !-d RewriteRule ^/([^/]+)/?$ index.php?id=$1 [NC,L] If the name-nextword-lastword is simply hardcoded in the href, you could do: /3/name-nextword-lastword/ Options +FollowSymLinks Options +Indexes RewriteEngine On RewriteBase / RewriteCond %{SCRIPT_FILENAME} !-f RewriteCond %{SCRIPT_FILENAME} !-d RewriteRule ^/([^/]+)/([^/]+)/?$ index.php?id=$1 [NC,L] disclaimer: I'm no mod_rewrite master __________________ Internet.geek.nz NameCooler.com Unlimited Domain Name Web Hosting Travel Money Rates

05-17-2007, 05:54 AM	#3 (permalink)
JuggernautH Account Closed Join Date: Dec 2005 Location: ../home/mysite Posts: 3,566 37.00 NP$ (Donate)	Just got the titles in the db, basicly like this "Welcome to site" for example. Would this do the trick? None of those apparently worked Last edited by JuggernautH; 05-17-2007 at 05:57 AM.

05-17-2007, 06:23 AM	#4 (permalink)
-NC- Traveller Join Date: Mar 2007 Location: Yet another city Posts: 1,392 614.57 NP$ (Donate)	The good news: You're in good shape if you've got the titles/id's in the DB! The bad news: I think you're going to need some additional php to: get the title from the url modify it so that it looks like the title in the db query the db to get the ID e.g. url: /name-nextword-lastword/ rewrite: RewriteRule ^/([^/]+)/?$ index.php?name=$1 [NC,L] index.php (pseudo code) $dbname = str_replace('-', ' ', $_GET['name']); (replace the underscores with spaces) select id from database where title = $dbname Oh erm, just to clarify, your example url: name-nextword-lastword_1.html "1" isnt the ID is it? __________________ Internet.geek.nz NameCooler.com Unlimited Domain Name Web Hosting Travel Money Rates

05-17-2007, 07:45 AM	#6 (permalink)
-NC- Traveller Join Date: Mar 2007 Location: Yet another city Posts: 1,392 614.57 NP$ (Donate)	Sorry, I'm at work, can only reply when the boss is not looking! __________________ Internet.geek.nz NameCooler.com Unlimited Domain Name Web Hosting Travel Money Rates

05-17-2007, 06:34 AM	#5 (permalink)
JuggernautH Account Closed Join Date: Dec 2005 Location: ../home/mysite Posts: 3,566 37.00 NP$ (Donate)	Hey, you got msn or something we can chat over? Could show you how the code looks like in that case, would be realy nice of you

05-17-2007, 08:34 AM	#7 (permalink)
JuggernautH Account Closed Join Date: Dec 2005 Location: ../home/mysite Posts: 3,566 37.00 NP$ (Donate)	Hehe okay :P

05-17-2007, 12:56 PM	#8 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,801 56.00 NP$ (Donate)	Code: RewriteEngine on RewriteRule ^[_a-zA-Z0-9]-[_a-zA-Z0-9]-[_a-zA-Z0-9]-([0-9])?\.html index.php?id=$1 (site.com/something-hola-yay-3.html) Put that in your .htaccess. You'll just need to make sure you use 3 words, followed by the id.

05-17-2007, 03:46 PM	#9 (permalink)
-NC- Traveller Join Date: Mar 2007 Location: Yet another city Posts: 1,392 614.57 NP$ (Donate)	Yeah that should work great as long as that number at the end is the ID! (I was wondering if I had overlooked the obvious there....) Nice regexp skills Dan! edit: just noticed your title in your postbit, love the subliminal advertising message! __________________ Internet.geek.nz NameCooler.com Unlimited Domain Name Web Hosting Travel Money Rates

05-17-2007, 04:01 PM	#10 (permalink)
JuggernautH Account Closed Join Date: Dec 2005 Location: ../home/mysite Posts: 3,566 37.00 NP$ (Donate)	Alright thanks Dan, will test that later. How would i go if i wanted to do it like this "index.php?id=1" to "review_1.html" for example? The review word will be same for all of the pages. Thanks for any answers!

05-17-2007, 04:12 PM	#11 (permalink)
-NC- Traveller Join Date: Mar 2007 Location: Yet another city Posts: 1,392 614.57 NP$ (Donate)	^[_a-zA-Z0-9]-[_a-zA-Z0-9]-[_a-zA-Z0-9]-([0-9])?\.html Actually, there is an underscore at the end, so should it be: ^[_a-zA-Z0-9]-[_a-zA-Z0-9]-[_a-zA-Z0-9]_([0-9])?\.html or if underscore is a special char in .htaccess, it would be: ^[_a-zA-Z0-9]-[_a-zA-Z0-9]-[_a-zA-Z0-9]\_([0-9])?\.html JuggernautH, it should work fine as long as there is only ever 3 words including review. Are you asking what if you have any number of hypen delimited words before the review_{id}.html? __________________ Internet.geek.nz NameCooler.com Unlimited Domain Name Web Hosting Travel Money Rates

05-17-2007, 04:15 PM	#12 (permalink)
JuggernautH Account Closed Join Date: Dec 2005 Location: ../home/mysite Posts: 3,566 37.00 NP$ (Donate)	Yes i would need to know that as well what would i put in the htaccess if i wanted to list review-{id}.html for example

05-17-2007, 04:26 PM	#13 (permalink)
-NC- Traveller Join Date: Mar 2007 Location: Yet another city Posts: 1,392 614.57 NP$ (Donate)	hmm, should be easy actually! I guess Dan will be able to correct me if I'm wrong, but in that case, all we care about is the _{number}.html So, here goes: ^[\-_a-zA-Z0-9]\_([0-9])?\.html There's definitely a better regex than that though, here's another attempt: ^/([^/\_]+)\_([0-9]*)?\.html Guess I should actually fire up apache and test! __________________ Internet.geek.nz NameCooler.com Unlimited Domain Name Web Hosting Travel Money Rates

05-17-2007, 04:33 PM	#14 (permalink)
JuggernautH Account Closed Join Date: Dec 2005 Location: ../home/mysite Posts: 3,566 37.00 NP$ (Donate)	Could you write me up the whole code for it? Kind of novice on this stuff myself :P Tryed for a while myself and i managed to get it working Thanks for all help! Code: RewriteRule ^review_([0-9]+).html reviews.php?id=$1 [L,NC] That's what i used! Dan & RCRiver: Go to www.hideurl.info/reviews.html to check the script live If you want i can review one each of your sites for free and put it there Last edited by JuggernautH; 05-17-2007 at 05:00 PM.

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