add_filter('posts_orderby_request', 'wpjam_search_orderby_filter'); function wpjam_search_orderby_filter($orderby = ''){ if(is_search()){ global $wpdb; $keyword = $wpdb->prepare($_REQUEST['s']); return "((CASE WHEN {$wpdb->posts}.post_title LIKE '%{$keyword}%' THEN 2 ELSE 0 END) + (CASE WHEN {$wpdb->posts}.post_content LIKE '%{$keyword}%' THEN 1 ELSE 0 END)) DESC, {$wpdb->posts}.post_modified DESC, {$wpdb->posts}.ID ASC";
}else{ return $orderby;
}
}提示錯誤：Warning: Missing argument 2 for wpdb::prepare(),$keyword = $wpdb->prepare($_REQUEST['s']);就是這一行。
1 回答
胡子哥哥
TA貢獻1825條經驗 獲得超6個贊
global $wpdb;
$sql = "((CASE WHEN {$wpdb->posts}.post_title LIKE '%s' THEN 2 ELSE 0 END) + (CASE WHEN {$wpdb->posts}.post_content LIKE '%s' THEN 1 ELSE 0 END)) DESC, {$wpdb->posts}.post_modified DESC, {$wpdb->posts}.ID ASC";
$search = esc_sql(urldecode(stripslashes($_REQUEST['s'])));return sprintf($sql,$search,$search);這是相關性排序吧?
跟lz說下,wp還對$_REQUEST['s']進行了一些處理.
比如test1 test2
會分成
$wpdb->posts.post_title LIKE '%test1%' and $wpdb->posts.post_title LIKE '%test2%'
其實還會search content,略過
- 1 回答
- 0 關注
- 261 瀏覽
添加回答
舉報
0/150
提交
取消