Page to load all catagory requests from hierachical category tree in the url

[elphin]

Let me explain what I am trying to accomplish:

I have a page build in Wappler: cat.php. This page holds a table of all the tasks belonging to a certain category.

In the frontend application I pass the category hierarchicaly in the url: mysite.com/cat/maincat/subcat1/subsubcat4/

The category table has a field 'path' and stores the path as a 'Materialized path'; /maincat/subcat1/subsubcat4/ this way I can query the database for all tasks in a certain category (where path like '/maincat/subcat/%' for example).

This method also needs a .htaccess rewrite condition to catch all requests with the url that starts with /cat/ and redirect those to my cat.php page.

I probably could make it myself a lot easier bij using a querystring passing the category id, but I like the names of the categories in the url making it much clearer for the end user where he is.

Is this the (or a) right way to accomplish this? Or is there a much easier way I didn't think of?

[famousmag]

Hey Jim and welcome!

Have a look at these Doc links:

URL Rewriting with Wappler

URL Rewriting (also known as Routing) can greatly improve the usability and SEO of your site. It’s really easy to setup URL Rewriting in Wappler visually, without dealing with complicated .htaccess rules and regular expressions. What is URL Rewriting? Most dynamic sites include variables (query parameters) in their URLs that tell the site what information to show the user. For example the following URL tells the scripts on the page to load product number 3: https://someurl.com/product_detail…

How to access URL params and send to a server action using url rewriting

URL rewriting and accessing the query parameters I’m going to strip away Wappler’s UI first, so you can clearly see what’s happening. Create this route: /:country/:language/product/:product_id [image] How it works: the variable, ex. :country, captures ANY word in it’s place and makes it available as {{query.country}}. So the :country is basically the key. And the word in it’s place will be the value. For example: /norway will be: query.country = norway Note: if you use this directly with…

If you have furher questions please give us a few info about what you have already done (screenshots, code) in order for us to understand.

[elphin]

Thanks famousmag! I'll look into this. It looks like it can solve (some of) my issues