在url而不是id php中获取产品名称

Question

I am working on a shopping cart website for a university project and need some help.

The site is currently under production at http://www.cutecupcak.es.

At the moment, each product has a url of something like http://cutecupcak.es/product.php?id=11, but I want it to be something like http://cutecupcak.es/product.php?id=chocolate_cupcake.

This is the code we have been given to make this work.

if(isset($_GET['id'])) {
$id = $_GET['id'];
$result = mysql_query("SELECT * FROM `CAKE` WHERE `cake_id`=($id)");    
}

What do I need to change to get the cake_name to show rather than the cake_id?

Answer 1

Generally, if you want to reference your products by a name instead of id - you should add a new column (I always name it as "slug") with an UNIQUE key. Then, when product is added or edited, based on its name you generates new value for the slug column. For example - from "Chocolate Cake" you will create "chocolate_cake". Then you have to check if the slug is unique - and if not - resolve conflict somehow (e.g. "chocolate_cake_1").

If you have all this set up - just select the appropriate product by unique slug:

$result = mysql_query("SELECT * FROM `CAKE` WHERE `slug`='" . mysql_real_escape_string($_GET['id']) . "'"); 

And - obviosuly - use mysqli instead of deprecated mysql functions.

http://php.net/manual/en/mysqli.query.php