Re: Apache and database driven url rewriting

Mike,
this is an example of database driven apache configuration.
the use case is not identical to your problem, but similar enough.
in your case, you will generate the redirects based on the schools
database.
Notice that this is not a dynamic configuration: Apache must be restarted
for changes to take place.

http://wiki.apache.org/httpd/ApacheVirtualHostMysql
Regards,
Shalom Carmel
-----------------------
www.hackingiseries.com


2009/4/22 <web400-request@xxxxxxxxxxxx>

date: Wed, 22 Apr 2009 11:13:16 -0400
from: Mike Cunningham <mike.cunningham@xxxxxxx>
subject: [WEB400] Apache and database driven url rewriting

I have been searching for articles on this and can't find anything for
apache that would do want I want but can find some for IIS. What I would
like to do is do a url rewrite that would change xxx.pct.edu to
www.pct.edu/schools/'schoolname'/xxx.html<
http://www.pct.edu/schools/'schoolname'/xxx.html> where xxx is a code for
a major we offer and 'schoolname' is the name of the school that offers that
major. Majors come and go and we have a database with our current majors.
So the rewrite would lookup the xxx in a table where I would get the school
or even the full url for that major. Has anyone ever een anything like this
for Apache or is there a case where writing my own module would required?