mysql - Category and subcategory php

Hello i am trying to fix a thing as a beginner i am still learningphp untill i consider i can migrate to a framework, what i am trying to do is:

1. I have a router in php like this :

   <?php 
   
        if(isset($_GET['contact'])){
            include('conctact.php');
        }elseif(isset($_GET['name_product'])){
            include('product.php');
        }else{
            include('home.php');
        }
   
    ?>
   Copy code

2. Links for menu like this:

    <?php 
       $select = mysqli_query($conn, "SELECT * FROM products");
       while($row = mysqli_fetch_assoc($select)){?>
           <div><a href="shoes/<?=$row['url_slug'];?>"><?=$row['name']?> - <?=$row['url_slug'];?></a></div>
    <?php } ?>
   Copy code

(Shoes is the category i want to add later dynamic category, on click i want to load page product.php, i dont want to have id on url so i did with url slug)

There is the.htaccess

RewriteRule ^([a-zA-Z0-9-])/([a-zA-Z0-9-])$   index.php?name_category=$name_product=$1 [L]
Copy code

My url would like to look like thiswww.example/shoes/product-name

And theproduct.php looks like this:

<?php 

   $name_product = mysqli_real_escape_string($conn, $_GET['name_product']);

   $sql=mysqli_query($conn,"SELECT * FROM products WHERE url_slug='$name_product '");

   $row=mysqli_fetch_array($sql);

 ?>
Copy code

My table mysql looks like that:

Product table
|id|name|url_slug|category|

Category table
|id|name
Copy code

I don't know how to write that.htaccess when click on link to include pageproduct.php and show details of product fetch from database.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.