您的位置:首页 > 帝国cms教程

帝国cms根据title标题检索包含标题关键字调用和高亮关键字

2024-01-23 15:12:35 帝国cms教程 186

帝国cms根据title标题检索包含标题关键字调用和高亮关键字

帝国cms根据title标题检索包含标题关键字调用和高亮关键字 第1张

<?php
$title = $navinfor['title'];
$id = $navinfor['id'];
$chars = array_unique(preg_split('//u', mb_strtolower($title, 'UTF-8'), null, PREG_SPLIT_NO_EMPTY));
$likeConditions = array_map(function($char) {
    return "LOWER(title) LIKE '%$char%'";
}, $chars);
$condition = implode(' OR ', $likeConditions);
$sql = "select id,title,titleurl,pinyin from mysql521_ecms_zhu where ($condition) and id <> $id order by onclick desc limit 16";
?>
[e:loop={"$sql",10,24,0}]
<li><a href="<?=$bqr['titleurl']?>" target="_blank" title="<?=$bqr['title']?>"><span><?=$bqr['pinyin']?></span><?=preg_replace('/('.implode('|', $chars).')/iu', '<b>$1</b>', mb_strtolower($bqr['title'], 'UTF-8'))?></a> </li>
[/e:loop]

相关推荐