PHP和MySQL中的嵌套注释

我通过论坛搜索,但无法得到权威的答案.我想以这样的方式实现嵌套的注释结构：

<ul>
    <li>This is the parent first comment!
        <ul>
            <li>This is the reply for the first parent comment!
                <ul>
                    <li>This is a reply for the first reply of the parent comment!</li>
                    <li>This is a third reply for the first parent comment!</li>
                </ul>
            </li>
            <li>This is another reply for first parent comment!</li>
        </ul>
    </li>
    <li>This is gonna be parent second comment!
        <ul>
            <li>This is a reply for the second comment!</li>
        </ul>
    </li>
    <li>This is fourth parent comment!</li>
</ul>

我桌子的转储如下：

+----+------------------------------------------------------------+--------+
| id | text                                                       | parent |
+----+------------------------------------------------------------+--------+
|  1 | This is the parent first comment!                          |      0 |
|  2 | This is gonna be parent second comment!                    |      0 |
|  3 | This is the reply for the first parent comment!            |      1 |
|  4 | This is another reply for first parent comment!            |      1 |
|  5 | This is a reply for the first reply of the parent comment! |      3 |
|  6 | This is a reply for the second comment!                    |      2 |
|  7 | This is a third reply for the first parent comment!        |      3 |
|  8 | This is fourth parent comment!                             |      0 |
+----+------------------------------------------------------------+--------+

我知道如何使用MysqL_query()和while()循环. PHP和PHP的初学者MysqL的.请帮帮我.

@H_403_10@

<?PHP MysqL_connect('localhost','root'); MysqL_select_db('nestedcomments'); function getComments($parent) { $res = MysqL_query("SELECT * FROM `nestcomm` WHERE `parent` = $parent"); if (MysqL_num_rows($res)) { echo "<ul>\n"; while (($dat = MysqL_fetch_array($res)) !== false) echo "<li>",$dat["text"],getComments($dat["id"]),"</li>\n"; echo "</ul>\n"; } else echo ($parent === 0) ? 'No Comments!' : ""; } getComments(0); ?>

<ul> <li>This is the parent first comment!<ul> <li>This is the reply for the first parent comment!<ul> <li>This is a reply for the first reply of the parent comment!</li> <li>This is a third reply for the first parent comment!</li> </ul> </li> <li>This is another reply for first parent comment!</li> </ul> </li> <li>This is gonna be parent second comment!<ul> <li>This is a reply for the second comment!</li> </ul> </li> <li>This is fourth parent comment!</li> </ul>

PHP和MySQL中的嵌套注释

猜你在找的PHP相关文章