// 內容雷同關聯:正規化關鍵字 + 查中央 content_index 找雷同頁(同網優先+跨網補,有產文優先)
function ci_norm($s){
$s = preg_replace('/\\s+/u','',(string)$s);
$s = preg_replace('/[[:punct:]。,、!?:;「」『』()【】·.·・…~–—]/u','',$s);
if (function_exists('mb_convert_kana')) $s = mb_convert_kana($s,'as');
return mb_strtolower(trim($s));
}
function engine_related_content($keyword, $site, $ref){
$norm = ci_norm($keyword);
if ($norm === '') return array();
$parts = explode('.', $site); $net = $parts[count($parts)-2];
$cdb = 'u459614871_domain';
$cc = @mysqli_connect('localhost', $cdb, tbs_dbpass($cdb), $cdb);
if (!$cc) return array();
mysqli_query($cc, "SET NAMES utf8mb4");
$ne=mysqli_real_escape_string($cc,$norm); $se=mysqli_real_escape_string($cc,$site);
$rfe=mysqli_real_escape_string($cc,$ref); $nte=mysqli_real_escape_string($cc,$net);
$r = mysqli_query($cc, "SELECT url, kw FROM content_index
WHERE kw_norm='$ne' AND NOT(site='$se' AND ref='$rfe')
ORDER BY (net='$nte') DESC, has_gen DESC, hits_se DESC LIMIT 5");
$out=array(); while($r && ($x=mysqli_fetch_assoc($r))) $out[]=array('url'=>$x['url'],'name'=>$x['kw']);
mysqli_close($cc); return $out;
}
Spring Boot project :: 讀書心得分享網站
這則整理對你有幫助嗎?
感謝你的回饋 🙏