English 中文(简体)
PHP中的动态检索文档
原标题:Dynamic .htaccess file in PHP

As part of a project, we re currently looking at adding in SEO URLs to pages. This is for an online store, and there are numerous types of content within the site: static pages (for example "About Us", "Privacy Policy", product categories and product pages.

We have the numerous URL stubs stored in a MySQL table as follows:

+-----------------+------------------+----------------+
|    url_stub     | destination type | destination_id |
+-----------------+------------------+----------------+
| privacy-policy/ |       page       |       1        |
+-----------------+------------------+----------------+
|   category-1/   |     category     |       2        |
+-----------------+------------------+----------------+
|  my-product-1/  |      product     |       1        |
+-----------------+------------------+----------------+

达到这一水平的一个选择是拥有巨大的指数。 然而,如果能够处理所有事项,我们更希望有单独的网页,以达到不同的内容类型。 例如,<代码>stination_type of page的任何东西都将上页。 php?id=#,等等。 因此,以上表格中的例子如下:

privacy-policy/ = page.php?id=1
category-1/     = category.php?cat=2
my-product-1/   = product.php?prod=1

My question is this: what would be the best practice to achieve this? We don t want to include the destination_id anywhere in the SEO-friendly URL. I was thinking that it might be possible to create a dynamic .htaccess file which outputs everything on the fly with mod_rewrite, but I can t find any solutions.

Any help or comments would be most gratefully received.

最佳回答

Short answer would be "no you have to rewrite it every time" but this older question should answer yours :) Can I make a dynamic .htaccess file?

Otherwise, complicated/stupid/useless idea:

RewriteRule /(.*)  /index.php?url=$1

Then in your PHP file

if (isset($_GET[ url ]))
{
  //Parse url and echo page according to requested url
}
问题回答

暂无回答




相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

php return a specific row from query

Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...

Character Encodings in PHP and MySQL

Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...

Pagination Strategies for Complex (slow) Datasets

What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...

Averaging a total in mySQL

My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...

热门标签