Put the result of a SQL query into a .htaccess file?

Dev Shed Forums Sponsor:

December 3rd, 2011, 07:06 PM

Triffic

Contributing User

Join Date: Mar 2009

Posts: 90

Time spent in forums: 1 Day 6 h 31 m 53 sec
Reputation Power: 5

mod_rewrite - Put the result of a SQL query into a .htaccess file?

Hi,

I have just been trying to use mod_rewrite to create SEO friendly URLs. Very new to it.

In an eCommerce store the product urls are:

Code:

site.com/products.php?id=1

I want to use:

Code:

site.com/product-id-1s-title-from-inside-the-database

You see ^ the SEO friendly URL is a string/record from the database, it's the title field for the product with an ID of 1.

Can/how I use a SQL query inside the .htaccess file to make the writing of the .htaccess file automated? Or can you not do that, and my only option is to hardcode in the SEO friendly URLs by hand?

There are over 1000 products you see.

I'd appreciate any advice you can offer.

Thanks very much.

__________________
Mens Wedding Suits Mansfield

December 3rd, 2011, 08:32 PM

requinix

Still alive

Dev Shed God 16th Plane (12500 - 12999 posts)

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,855

Folding Points: 417516 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 5 Months 1 Week 5 Days 4 h 51 m 44 sec
Reputation Power: 8977

Send a message via Google Talk to requinix

What you do is turn the friendly URL into the real URL using pattern matching.

Code:

/product-id-(\d+)

Anything that looks like that gets rewritten to a different page. Say

Code:

products.php?id=$1

Then products.php decides what to do from there according to $_GET["id"].

You aren't creating a rule for every single URL. Just the different forms of them.

__________________
Site rules and FAQ | Project Suggestions | mod_rewrite guide | PHP New User Guide and FAQ - PHP Stickies | Regex Resources

Viewing: Dev Shed Forums > System Administration > Apache Development > mod_rewrite - Put the result of a SQL query into a .htaccess file?

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump