尼玛博客评论合并脚本 <?php $dbhost='127.0.0.1'; $d - Assbbs
尼玛博客评论合并脚本 <?php $dbhost=& 39;127.0.0.1& 39;; $dbname=& 39;tp& 39;; $dbuser=& 39;root& 39;; $dbpass=& 39;root& 39;; date default timezone set & 39;PRC& 39; ; try{$pdo=new P…
尼玛博客评论合并脚本 <?php $dbhost=& 39;127.0.0.1& 39;; $dbname=& 39;tp& 39;; $dbuser=& 39;root& 39;; $dbpass=& 39;root& 39;; date default timezone set & 39;PRC& 39; ; try{$pdo=new PDO & 39;mysql:host=& 39;.$dbhost.& 39;;dbname=& 39;.$dbname,$dbuser,$dbpass ;}catch Exception $e {die & 39;sqlsb& 39; ;} $rt=$pdo->query & 39;SELECT FROM typecho contents LIMIT 20& 39; ->fetchAll PDO::FETCH ASSOC ; foreach $rt as $ttt { $rr=$pdo->query & 39;SELECT FROM typecho comments WHERE cid =& 39;.$ttt & 39;cid& 39; .& 39; ORDER BY coid ASC& 39; ->fetchAll PDO::FETCH ASSOC ; $txt=& 39; <br /> <div class="nima comments"> & 39;; foreach $rr as $rrr { $txt.=& 39;<hr /> <div class="nima comment" id="nima comment & 39;.$rrr & 39;coid& 39; .& 39;"> <span class="nima comment user">& 39;. empty $rrr & 39;url& 39; ?$rrr & 39;author& 39; :& 39;<a href="& 39;.$rrr & 39;url& 39; .& 39;" target=" blank" rel="nofollow">& 39;.$rrr & 39;author& 39; .& 39;</a>& 39; .& 39;</span> & 39;. $rrr & 39;created& 39; ==28800 ?& 39;& 39;:& 39;在 <span class="nima comment time">& 39;.date & 39;Y/m/d H:i:s& 39;,$rrr & 39;created& 39; .& 39;</span> & 39; . empty $rrr & 39;parent& 39; ?& 39;评论& 39;:& 39;<a href=" nima comment & 39;.$rrr & 39;parent& 39; .& 39;">回应</a>& 39; .& 39;： <br /> <span class="nima comment text">& 39;.$rrr & 39;text& 39; .& 39;</span> </div> & 39;; } $txt.=& 39;</div> & 39;; $ttt & 39;text& 39; .=$txt; $pdo->exec & 39;UPDATE typecho contents SET text ="& 39;.addslashes $ttt & 39;text& 39; .& 39;" WHERE cid =& 39;.$ttt & 39;cid& 39; ; } ?> 仅供参考