// 內容雷同關聯:正規化關鍵字 + 查中央 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 :: 讀書心得分享網站
讀書心得分享網站 LIFE 每 15 分更新

Spring Boot project

重點資訊
這則整理對你有幫助嗎? 感謝你的回饋 🙏
相關資訊