[RESOLVED] HTACCESS

include_me

Hi there,

Im trying to write an HTACCESS file to rewrite some pages i have on my site.

I currently have www.domain.com/page.php?urllookup=new-page

and i want to rewrite it so that it looks like:

www.domain.com/page/new-page.php

I tried this but it doesnt work:

RewriteEngine On
RewriteRule /page/([^.]+).php page.php?urllookup=$1

Can anyone tell me what im doing wrong?

Thanks,
Chris

thorpe

Try...

RewriteRule ^(.*)\.php page.php?urllookup=$1

suntra

You need to escape the dot in the parentheses...

RewriteEngine On
RewriteRule /page/([^[COLOR="Red"]\[/COLOR].]+).php page.php?urllookup=$1

"." means "everything"
"." means "dot"

Also, make sure the file is called ".htaccess" (without the quotes)... you wrote it in capital letters, so I was just wondering...

include_me

sorry.. my .htaccess file

include_me

thorpe wrote:
Try...
RewriteRule ^(.*)\.php page.php?urllookup=$1

I tried this, it loads the page but it didnt query my DB?

bradgrafelman

If it loads the page, then the problem is no longer mod_rewrite's - must be your PHP script.

EDIT: Could be because the pattern doesn't look to do what you want it to do. Try using suntra's example.

include_me

does this SQL look right? Ive tried my normal link before the rewrite and its not working.. I swear it could be something to do with my SQL?

"SELECT * FROM page_content WHERE page_Url = {$_GET['urllookup']}";

My head is exploding with fury haha.

Thanks,
Chris

bradgrafelman

No, it doesn't look right; if you're passing MySQL a string value, you must surround it with (single) quotes - just like PHP, HTML, etc. etc.

In addition, it appears as though you're vulnerable to SQL injection attacks. User-supplied data should never be placed directly into a SQL query! Instead, sanitize it with a function such as [man]mysql_real_escape_string/man.

include_me

Hi there, I currently have an .htaccess file that directs users from my website

http://www.domain.com/individual-page/

http://www.domain.com/page.php?page=individual-page

My problem is that I also have AWstats installed in the AWstats directory but obviously when i try to go to /awstats it is processed by the .htaccess file and does horribly wrong, is there a way i can exclude the awstats directory from being processed by the .htaccess rules?

Thanks,

Chris

bradgrafelman

You could add two RewriteCond rules before your pattern so that mod_rewrite won't rewrite any URLs that point to actual directories or files, like so:

RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule *** Your current rule here ***

include_me

Thanks that worked perfectly!