Ok, I’ll go a bit deeper in the solution since there seems to be interest in it.
There are two questions here:
1) How do I generate those URLs
2) What do I do in the Snippet.
Re 1)
We don’t want the url to be like www.mysite.nl/?product=lawnmower&type=yamaha&model=XV13
since this is not good for Google ranking.
A better url is www.mysite.nl/product/lawnmower/yamaha/xv13.html.
An even beter url is
www.mysite.nl/product/lawnmower/xv13/a-good-lawnmower-for-soccer-fields.html
(To catch all those Google Searches: "what is the best lawnmower for soccer fields")
The homepage is a simple page with a list of links to all products. Or 26 pages with
product-starting-with-A, B, C, etc.
Each product has a description, a productcode and a 5-word-elevatorpitch.
Create a snippet going through you product database and generate a link
for each product. If you have a lot of products, make that snippet cachable,
you don’t want every visitor selecting the whole producttable from your DB
Together with some SEO-magic those specific product pages are ranked
high in the results on searches on those specific products.
Re 2)
The snippet in the "Virtual Page" starts of with getting the $_SERVER["REQUEST_URI"].
In that variable we find "/product/lawnmower/xv13/good-for-soccerfiels.html".
The structure is "product/[[productname]]/[[producttype]]/[[google-stuff]]".
PHP:
list($x, $productname, $producttype, $y) = split("/", $_SERVER["REQUEST_URI"], 4);
Ignore the google-stuff and use the productname and producttype to go
to the database and there you get all info on this product.
DBQuery:
select *
from producttable
where productname = '$productname' AND producttype = '$producttype'
Does this make any sense the people who requested more info?
☆ A M B ☆
