æ–°ã—ã„プラグインã®è£½ä½œé€”ä¸ãªã®ã§ã™ãŒã€ãれã«é–¢é€£ã—ã¦è¦‹ã¤ã‘ãŸãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã€ã¨ã„ã†ã‹ã¾ã ä¿—ã«è¨€ã† Snippet〠画åƒã‚’å«ã‚€è¨˜äº‹ãƒ»ã‚³ãƒ¡ãƒ³ãƒˆã‚’å–ã‚Šå‡ºã™æ–¹æ³•紹介ã—ã¾ã™ã€‚
get_results() ã¯ã€€WordPress ã®ã‚«ã‚¹ã‚¿ãƒ 関数㧠mySQL ã®ã‚¯ã‚¨ãƒªã‚’実行ã—ã¦å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’é…åˆ—ã«æ ¼ç´ã—ã¦ãれã¾ã™ã€‚ã“ã®å ´åˆã€ã€€$wp_posts $wp_comments ãれãžã‚Œã«é…列ã¨ã—ã¦ç”»åƒã‚’å«ã‚€è¨˜äº‹ã‚’ストアã•ã›ã¦ã„ã¾ã™ã€‚
-
$sql_wp_posts ="
-
SELECT ID, post_content
-
FROM $wpdb->posts
-
WHERE post_content LIKE '%src=%'
-
ORDER BY ID DESC
-
";
-
-
$sql_wp_comments ="
-
SELECT comment_content, comment_post_ID
-
FROM $wpdb->comments
-
WHERE comment_content LIKE '%src=%'
-
ORDER BY comment_post_ID DESC
-
";
-
-
$wp_posts = $wpdb->get_results($sql_wp_posts);
-
$wp_comments = $wpdb->get_results($sql_wp_comments);
mySQL ã¡ã‚‡ã£ã¨è§£èª¬ï¼š
SELECT ã®ã™ã後ã«é¸æŠžã—ãŸã„ コラムを入力ã—ã¾ã™ã€‚ ã“ã®å ´åˆã¯ã€ID, post_content 㨠comment_content, comment_post_ID
FROM ã®å¾Œã¯ã€€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ルå。 $wpdb->post ã¨ã™ã‚‹ã“ã¨ã§ã€prefix㌠wp_ ã®å ´åˆã€wp_posts テーブルをã€ã€€$wpdb->comments ã§ wp_comments テーブルを指定ã§ãã¾ã™ã€‚
WHERE post_content LIKE '%src=%' :ã“れã¯ã€€post_content ã®ä¸ã‹ã‚‰ src= ã¨ã„ã†æ–‡å—列をå«ã‚€ã‚‚ã®ã‚’探ã—ã¦ãã€ã¨ã„ã†å‘½ä»¤æ–‡ã€‚
ãŠã¾ã‘ã¨ã—ã¦ã€ ORDER BY [colum name] DESC ã¯ãã˜ãŒæ–°ã—ã„é †ã«è¡¨ç¤ºã‹ã©ã†ã‹ã‚’決ã‚るコードã§ã™ã€‚
| Share This |
|



