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 . '|- '; //開源代碼Vevb.com
- }
- echo strip_tags($row->content);
新聞熱點
疑難解答