CODEWITHSUNDEEP
c#mysqlasp.net-mvc-4slug
Guilherme Oderdenge
Guilherme Oderdenge

Reputation: 5001

Select by slugged string/friendly URL

The goal

Select data from database using Name-Of-Product instead of its id.

The problem

My application allows the user to compare product prices. To make some comparison I need to access myapp.com/Product/Compare?Id=1. I'm upgrading my application and now I want to access myapp.com/Product/Xbox-360 to make the comparison.

How can I select the sluggified word from the database instead of its id? Do I have to unsluggify the string?

Can someone enlighten me?

What I've already tried

I even do not know how to start. In other words, I didn't try nothing. Oh... Actually, if necessary, I already created a method that can sluggify some string, but I don't think it is necessary to post here.

SQL Spotlight

My query to produce the list of products to compare is simple:

Select product.Name,
       marketProduct.Price
From app_products As product
Join app_marketProducts As marketProduct
Where product.Id = 1

Upvotes: 0

Views: 225

Answers (1)

D.R.
D.R.

Reputation: 21194

You essentially have two choices:

  • You can store the slug in a new column within your database.

  • You can add the primary key (the ID) to your URL in some way:

    a) Directly to the slug (e.g. /42-My-Slug)

    b) To another section of the URL (e.g. /42/My-Slug). This seems to be the best practice, e.g. StackOverflow uses it.

Upvotes: 2

Related Questions