php父類與子類讀取資料代碼

代碼如下

複製代碼

function getsubcomments($parent = 0, $level = 0) { $db = &jfactory::getdbo(); $sql = "..."; // 查詢記錄的sql $db->setquery($sql); $rows = $db->loadobjectlist(); $list = array(); // 先從資料得到記錄集，再對記錄添加level, 父層level = 0,它的下級level = 1，如此類推 foreach ($rows as $row) { $row->level = $level; $list[] = $row; $tmparr = getsubcomments($row->id, $level + 1); // 遞迴調用 if (count($tmparr)) { foreach ($tmparr as $tmprow) { $list[] = $tmprow; } } } return $list; } $list = array(); foreach ($tmplist as $row) { $row->level = 0; $list[] = $row; $tmplist2 = getsubcomments($row->id, 1); foreach ($tmplist2 as $row2) { $list[] = $row2; } } // 按level分層次輸出內容 if ($row->level) { $pre = ''; for ($n = 0; $n < $row->level; $n++) $pre .= '----'; echo $pre . '|- '; } echo strip_tags($row->content);