drbuowqe02101 2016-03-27 12:24
浏览 31

如何将对象插入多个类别并使用php检索

I have a table having root categories like:

fruit
vehicle
goods

and sub categories like:

fruit   => sweet
        => sour
        => mixed

vehicle => car
        => light vehicle
        => hatch back
        => sedan

goods   => furniture
        => wooden
        => home accessories

I want to insert a object into database using multiple subcategory of a root category

mango  => fruit(root)   => sour, mixed
maruti => vehicle(root) => car, light vehicle, hatch back
table  => goods(root)   => furniture, wooden, home accessories

In my html I have multiple checkbox list of a root category, so how can I insert this into my database and retrieve it in php? and my database structure is

parentid  cat_id title
0             1   fruit
0             2    vehicle
0             3    goods
1             4    sour
1             5    sweet
1             6    mixed
2             7    sedan
2             8     hatchback
2             9     car

and so on

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 怎么用dlib库的算法识别小麦病虫害
    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算