Also they may be using URL rewriting via Apache to convert the URL into something like
http://myDomain.com/index.
at which point looking up the database becomes a trivial issue. The mod_rewrite rules for Apache for here http://httpd.apache.org/do
RewriteEngine on
RewriteRule ^/([a-zA-Z]+)/[-a-zA-Z0-9]
Main Topics
Browse All Topics





by: crackyPosted on 2009-02-14 at 19:22:35ID: 23643451
Chances are, they're just using a unique search key as the field to search on.
For example, you can create a "slug" field in your products table and set it to UNIQUE.
In your example, the product slug could be "Some-Product". As long as no other product has the same name, you will always be able to uniquely search for that product. Text searches won't be as fast as ID searches, but you'll still be able to select products by that field if you want a URL without an ID.