URL rewrite PHP & pulls data from a MySql DB

Question

I have a site tha is written in PHP and pulls data from a MySql DB. The site utilises query strings and I would like to map the query generated pages to the more search engine friendly page titles. For example I would like to acheive to the following mappings:

content.php?id=1 to map to /aboutus 
content.php?id=2 to map to /contactus
content.php?id=3 to map to /newfiles

how can i do this, in a more simple way. is that simply changing .htaccess file, or is that related to rewrite mapping function. pls can you give me hint and exact example would be great. thanks

Chanon · Accepted Answer · 2012-08-27 04:49:46Z

1

You need a field called permalink (or similar) in your database. e.g.

id | permalink | content |
1  | aboutus   | bra bra |
2  | contactus | bra bra |

Then use this in your .htaccess file

RewriteRule ^(.*)/ content.php?permalink=$1 [L]

What above .htaccess does is recognize your url in first level and pass it to url variable. e.g. when user type

yoursite.com/aboutus/

It will actually request to

yoursite.com/content.php?permalink=aboutus

(but user don't see it)

then you use $_GET['permalink'] to match your database and get content display on the screen.

edited Aug 27, 2012 at 4:49

answered Aug 27, 2012 at 1:56

Chanon

4761 gold badge5 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

URL rewrite PHP & pulls data from a MySql DB

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related