horseluke / drafts Goto Github PK

<?php
//代码略
$catid = @$_GET['catid'];
$sql = "SELECT * FROM `tc_guestbook` WHERE catid = ". $catid;
$list = $db->fetchAll($sql);
if(empty($list)){exit("该留言列表不存在");}
foreach($list as $k => $row){
    $list[$k]['user'] = $db->fetchOne("SELECT * FROM `tc_user` WHERE `uid` = '". $row['uid']. "'");
}

//代码略
require __DIR__. '/tpl/default/guestbook_list.php';

/*模板代码略*/
<?php foreach($list as $row): ?>
    <div>[<?php echo $row['user']["username"]; ?>] 
        <?php echo strlen($row["title"]) > 50 ? substr($row["title"], 0, 50). '...' : $row["title"]; ?>
    </div>
<?php endforeach; ?>
/*模板代码略*/