表結構如下:
DROP TABLE IF EXISTS `crm_wm_comment0`;
CREATE TABLE `crm_wm_comment0` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` varchar(1000) NOT NULL,
`createtime` int(11) NOT NULL,
`replay_content` varchar(500) DEFAULT NULL,
`replay_time` int(11) DEFAULT NULL,
`uid` int(11) NOT NULL DEFAULT '0',
`ip` varchar(15) DEFAULT NULL,
`pid` int(11) NOT NULL DEFAULT '0',
`level` varchar(40) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=138 DEFAULT CHARSET=utf8;
level:是id序列 ,1,3,5,7,
<style>
.acc{border:1px solid #666;padding:3px; max-width: 300px;}
</style>
<?php
$sql = mysql_query("select * from crm_wm_comment0 limit 20");
while($value = mysql_fetch_array($sql))
{
$html = '';
if($value['pid']==0 ){
?>
<p><?php echo $value['content'];?>
<?php
}
$in_id = ltrim(rtrim($value['level'],','),',');
$sqla = mysql_query("select * from crm_wm_comment0 where id in(".$in_id.")");
$sqlb = mysql_query("select * from crm_wm_comment0 where id in(".$in_id.")");
if($in_id)
{
while($valuea = mysql_fetch_array($sqla))
{
$html .= "<div class='acc'>".$valuea['content'];
}
while($valuev = mysql_fetch_array($sqlb))
{
$html .= "</div>";
}
}
echo $html;
?>
</p>
<?php
}
?>
頁面顯示:
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiInBnauQDN3ADOfZ3ZmF1XyQDOyQTMvwFOxYDMvwFNxAjMvwVZjFGcz9CXzRWYvxGc19CX0VmbuEmbph2Yz9mLjlGdhR3cvw1LcpDc0RHaiojIsJye.jpg)
版權聲明:本文為CSDN部落客「weixin_33816821」的原創文章,遵循CC 4.0 BY-SA版權協定,轉載請附上原文出處連結及本聲明。
原文連結:https://blog.csdn.net/weixin_33816821/article/details/92070679