dongxian6285 2012-06-02 07:46
浏览 50
已采纳

如何使用PHP在SQL菜单中显示记录？

i have made a static drop-down menu for my e-commerce website. i have various categories and then sub categories. my main tabs are, "CLOTHES", "FOOTWEAR", "ACCESSORIES" etc. The clothes tab is divided into two parts one is brand wise and one is type(shirts, jeans, etc.) Now my question is, if i go to the clothes tab and then click on shirts, how can i traverse and retrieve the records from my SQL table. I have made the connection with the database, my table name is 'products'. The page to display products is list.php. I am new to PHP and i know a little bit about this language.

  • 写回答

3条回答 默认 最新

  • douli4337 2012-06-02 10:54
    关注

    have a pages table and categories table

    also have cat_parent in the categories table Then have a php loop to go through each topmost categories and then subcats and ......... and then pages.

    watch it in action this is the site i am working a the moment

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题？

悬赏问题

  • ¥15 hexo+github部署博客
  • ¥15 求螺旋焊缝的图像处理
  • ¥15 blast算法（相关搜索：数据库）
  • ¥15 请问有人会紧聚焦相关的matlab知识嘛？
  • ¥15 网络通信安全解决方案
  • ¥50 yalmip+Gurobi
  • ¥20 win10修改放大文本以及缩放与布局后蓝屏无法正常进入桌面
  • ¥15 itunes恢复数据最后一步发生错误
  • ¥15 关于#windows#的问题：2024年5月15日的win11更新后资源管理器没有地址栏了顶部的地址栏和文件搜索都消失了
  • ¥100 H5网页如何调用微信扫一扫功能？