举例：想通过关键词，搜索出数据表A，B，C，各数据多少数据显示出来
search.php代码：
<?php
$guanjianci = urldecode($_GET["key"]);
$guanjianci = strFilter($guanjianci);
function strFilter($str) {
$str = str_replace(array('/', ' ', '|', '#', '~', '@', '%', '^', '&', '*', '(', ')', '-', '_', ':'), array('', '', '', '', '', '', '', '', '', '', '', '', '', ''), $str); // 添加了缺失的分号
return trim($str);
}
if ($guanjianci == '' || $guanjianci == null) {
// 可以在这里处理没有搜索关键词的情况
} else {
require("../e/class/connect.php");
if (!defined('InEmpireCMS')) {
exit();
}
require("../e/class/db_sql.php");
require("../e/class/q_functions.php");
$link = db_connect();
$empire = new mysqlquery();
$footer=$empire->fetch1("select varvalue from {$dbtbpre}enewstempvar where myvar='sofooter' limit 1");
?>
<!DOCmod HTML>
<style>
.header{min-width:1200px;animation:myfirst 10s;}</style>
</head><body>
<div class="mainbox">
<h2 class="layui-elem-quote" style="margin-bottom: 0;"><i class="layui-icon layui-icon-search" ></i> <?=$public_r['add_name']?>为您找到与<em style="color: #e10602;"><?=$guanjianci?></em>相关的网站</h2>
<div class="so-container-slogan">
<?php
$numurl = $empire->gettotal("SELECT COUNT(*) AS total FROM phome_ecms_url WHERE title LIKE '%$guanjianci%' OR INSTR(title, '$guanjianci') > 0 ORDER BY newstime LIMIT 6");
$numysbaike = $empire->gettotal("SELECT COUNT(*) AS total FROM phome_ecms_ysbaike WHERE title LIKE '%$guanjianci%' OR INSTR(title, '$guanjianci') > 0 ORDER BY newstime LIMIT 6");
if ($numurl < 1 && $numysbaike < 1) {
?>
<div class="create-entrance">
<p class="first-tip">抱歉，<?=$public_r['add_name']?>尚未收录网站 “<em><?=$guanjianci?></em>”</p>
<p class="content-txt">欢迎您来提交，与网友分享该网站信息，在提交网站前，请查看收录标准。</p>
<div class="btn-group"> <a href="/pay.html" target="_blank" class="btn-left">提交网站</a> <a href="/about/shoulu.html" target="_blank" class="btn-right">收录标准</a> </div>
</div>
<?php
}
if ($numurl > 0) {
?>
<?php
$queryurl = $empire->query("SELECT * FROM phome_ecms_url WHERE title LIKE '%$guanjianci%' OR INSTR(title, '$guanjianci') > 0 ORDER BY newstime LIMIT 6");
while ($rurl = $empire->fetch($queryurl)) {
$src = $rurl[id];
$urltitle=$rurl['title'];
$urltitleurl=$rurl['titleurl'];
$urltitlepic = !empty($rurl['titlepic']) ? $rurl['titlepic'] : '/e/data/images/notimg.gif';
$urlsmall=$rrurl['smalltext'];
$urlkouhao=$rurl['kouhao'];
$urlnewstime=date('Y-m-d',$url['newstime']);
$urldengji=$rurl['dengji'];
$urlcr=$empire->fetch1("select bname from phome_enewsclass where classid='".$rurl[classid]."' limit 1");
$urlslei=$urlcr['bname'];
?>
<div class="so-item-slogan-logo so-container-slogan-content">
<div class="so-item-slogan-logo-left"> <a href="<?=$urltitleurl?>" target="_blank" title="<?=$urltitle?>">
<div class="so-item-slogan-logo-icon" style="background-image:url(<?=$urltitlepic?>)"></div>
</a>
<div class="so-item-slogan-logo-info">
<div class="so-item-slogan-logo-info-name sz-ellipsis"><a href="<?=$urltitleurl?>" target="_blank" title="<?=$urltitle?>"><?=$urltitle?></a></div>
<div class="so-item-slogan-logo-info-size sz-ellipsis">所属分类：<a href="<?=$urltitleurl?>" target="_blank" style="color: #626675;"><?=$urlslei?></a></div>
<div class="sz-ellipsis"><?=$urlkouhao?></div>
</div>
</div>
<a class="sz-button" href="<?=$urltitleurl?>" target="_blank">
<button class="native-button">查看</button>
</a> </div>
<?php } ?>
<?php } ?>
<?php
$numysbaike=$empire->gettotal("select count(*) as total from phome_ecms_ysbaike where title like '%$guanjianci%' or instr('$guanjianci',title)>0 order by newstime limit 6");
if($numysbaike<1){}else{
?>
<?php
$querybaike = $empire->query("SELECT * FROM phome_ecms_ysbaike WHERE title LIKE '%$guanjianci%' OR INSTR(title, '$guanjianci') > 0 ORDER BY newstime LIMIT 6");
while ($rbaike = $empire->fetch($querybaike)) {
$src = $rbaike[id];
$baiketitle=$rbaike['title'];
$baiketitleurl=$rbaike['titleurl'];
$baiketitlepic = !empty($rurl['titlepic']) ? $rurl['titlepic'] : '/e/data/images/notimg.gif';
$baikesmall=$rbaike['description'];
$baikenewstime=date('Y-m-d',$rbaike['newstime']);
$baikedengji=$rbaike['dengji'];
$baikecr=$empire->fetch1("select bname from phome_enewsclass where classid='".$rbaike[classid]."' limit 1");
$baikeslei=$baikecr['bname'];
?>
<div class="so-item-slogan-logo so-container-slogan-content">
<div class="so-item-slogan-logo-left"> <a href="<?=$baiketitleurl?>" target="_blank" title="<?=$baiketitle?>">
<div class="so-item-slogan-logo-icon" style="height:115px;background-image:url(<?=$baiketitlepic?>)"></div>
</a>
<div class="so-item-slogan-logo-info">
<div class="so-item-slogan-logo-info-name sz-ellipsis"><a href="<?=$baiketitleurl?>" target="_blank" title="<?=$baiketitle?>"><?=$baiketitle?></a></div>
<div class="so-item-slogan-logo-info-size sz-ellipsis">所属分类：<a href="<?=$baiketitleurl?>" target="_blank" style="color: #626675;"><?=$baikeslei?></a></div>
<div class="sz-ellipsis"><?=$baikesmall?></div>
</div>
</div>
<a class="sz-button" href="<?=$baiketitleurl?>" target="_blank">
<button class="native-button">查看</button>
</a> </div>
<?php } ?>
<?php } ?>
</div>
</body>
</html>
<?php } ?>
模板前端调用：
<form action="/search/search.php" method="get" name="form1" data-node="searchForm" target="_blank" id="form1" class="search-form">
<span class="icon"></span>
<input type="text" class="suchbegriff" value="网易云音乐" id="searchfield" name="key">
<button class="search-submit" type="image"><img src="/skin/images/search.png"></button>
</form>
发表评论