doujuanju3076 2013-08-26 03:56 采纳率: 0%
浏览 28

安排亲子关系

I have read the Build a tree from a flat array in PHP and the Convert a series of parent-child relationships into a hierarchical tree? but could not figure out how to implement it for my problem. There is a pairs of relations as such:

Array
(
    [0] => catalog.iden = catalog_sub.parent
    [1] => catalog.group = catalog_group.iden
    [2] => catalog_photo.iiden = catalog.iden
)

I have not NULL, or 0, or any explicit condition to stop looping. All what I know is what field has primary key with auto_increment attribute. Say in that example it will be field named 'iden' so in the relation it will be "parent".

I have spent a week to resolve this problem but with no result. So could anybody help me to arrange this array in order of relations. It may be tree of flat array.

Thanks in advance.

UPDATE

So far I only managed to do so:

foreach($matches[0] as &$match) {
    $ref  = explode('=', $match); // split by = sign
    $lft = explode('.', $ref[0]);
    $rgt = explode('.', $ref[1]);

    if($lft[1] == 'iden') {
        $arr[$lft[0]][$rgt[0]] = $rgt[1];
    } else {
        $arr[$rgt[0]][$lft[0]] = $lft[1];
    }
}

What gives sorting by primary key and grouping by used tables:

Array
(
[catalog] => Array
    (
        [catalog_sub] => parent
        [catalog_photo] => iiden
    )

[catalog_group] => Array
    (
        [catalog] => group
    )

)
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度
    • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测