# 评论区域开始
代码说明:通过Execute方法执行SQL语句,然后通过while循环将GetArray方法获取出来的记录循环出来
<?php
$dosql->Execute("SELECT * FROM `#@__infolist` WHERE (classid=4 or parentid=4) AND delstate='' AND checkinfo=true ORDER BY orderid,id DESC LIMIT 0,3");
while($row = $dosql->GetArray())
{
if($row['linkurl'] == '') $gourl = 'newsshow.php?cid='.$row['classid'].'&id='.$row['id'];
else $gourl = $row['linkurl'];
?>
<a href="<?php echo $gourl; ?>" style="color:<?php echo $row['colorval']; ?>;font-weight:<?php echo $row['boldval']; ?>;"><?php echo ReStrLen($row['title'],14); ?></a><?php echo GetDateMk($row['posttime']); ?>
<?php
}
?># 获取列表
<select multiple class="form-control" name="domain">
<?php
$basedomain = hurl($data['url']);
$selecteddomain = 'selected="selected"';
$dosql->Execute("SELECT * FROM `tp_domain_test`");
$domains = $dosql->Execute();
while($domains = $dosql->GetArray()){
$domain = $domains['domain'];
?>
<option value="<?php echo $domain;?>"
<?php if($domain == $basedomain) {echo $selecteddomain;} ?> >
<?php echo $domain;?>
</option>
<?php } ?>
</select># 删除
$id = $_GET['id'];
$datas = $dosql->QueryNone("DELETE FROM `tp_domain_test` WHERE (`id`='$id')");
echo $message = "已删除";
echo "<br>";
header("location:links.php");
签名:这个人很懒,什么也没有留下!