I am looking to rewrite a rule for my products.
My goal is to utilize the id and name in the URL, separated by a dash like this:
123-name translates to product id = 123 and name = name
This way, in my PHP code, I can fetch the $_GET[id] and then query my database using this id as follows:
$sql = "SELECT * from Products Where productId = ".$_GET['id'];
Here is what I currently have:
RewriteEngine On
RewriteRule ^products/([0-9]+)\-([a-z]+)/?$ products.php?id=$1 [NC,L]
However, when I enter this as a URL, I encounter a 404 error.
What could be causing this issue?