How to display category url, product list url and product details url dynamically (txt) in php mvc if not getting any parameter? | SoloLearn: Learn to code for FREE!

0

How to display category url, product list url and product details url dynamically (txt) in php mvc if not getting any parameter?

I want to call pageurl value of category title, product list title and product details title from one seo table (mysql). In my mvc project, I tried these queries for category controller :" select category.*, seo.url as seoid from category, seo where category.seoid = seo.id" For product controller : "Select product.*, seo.pageurl as seoid from product, seo where product.category_id=seo.id and seo.pageurl=? After clicking any 1 category url, a parameter is passed in seo.pageurl which is working fine. But main problem is that in the product list, when click on any product url, then it again calls same category as a detail page, if i use id, then it is working, but i want to use product name as url not id. Query for detail page is "select product.*, Seo.pageurl as seoid from product, seo where product.seoid=seo.id and seo.pageurl=?"

5/28/2020 1:19:05 PM

Roshan kr.

0 Answers

New Answer