搜索 - 腾讯云开发者社区-腾讯云

文章/答案/技术大牛

发布

来自专栏张戈的专栏
DIY网站统计：WordPress排除管理员评论及精准友链数的方法
php echo $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments");?>条

wpdb

77030发布于 2018-03-23

来自专栏小文博客

WordPress获取所有文章链接

wp-blog-header.php'); global $wpdb; $qianzui = "https://www.qcgzxw.cn/";//填你的前缀 $ wp_posts WHERE post_type = 'post' AND post_status = 'publish' ORDER BY ID DESC "; $myrows = $wpdb wp-blog-header.php'); global $wpdb; $qianzui = "https://www.qcgzxw.cn/";//填你的前缀 $houzui wp_posts WHERE post_type = 'post' AND post_status = 'publish' ORDER BY ID DESC "; $myrows = $wpdb wp-blog-header.php'); global $wpdb; $sql="SELECT guid FROM wp_posts WHERE post_type =

5.1K50发布于 2018-06-25

来自专栏用户8644135的专栏

wordpress代码实现相关文章的几种方法

->get_results(" SELECT DISTINCT ID, post_title FROM {$wpdb->prefix}posts, {$wpdb->prefix}term_relationships , {$wpdb->prefix}term_taxonomy WHERE {$wpdb->prefix}term_taxonomy.term_taxonomy_id = {$wpdb->prefix}term_relationships.term_taxonomy_id (" SELECT post_title, ID FROM {$wpdb->prefix}posts, {$wpdb->prefix}term_relationships, {$wpdb->prefix }term_taxonomy WHERE {$wpdb->prefix}posts.ID = {$wpdb->prefix}term_relationships.object_id AND {$wpdb ->prefix}term_taxonomy.taxonomy = 'category' AND {$wpdb->prefix}term_taxonomy.term_taxonomy_id = {$wpdb

67680发布于 2021-06-24

来自专栏空木白博客

WordPress加入”随便看看”菜单功能

function random_postlite() { global $wpdb; $query = "SELECT ID FROM $wpdb->posts WHERE post_type = 'post random_cat_id'] ) ) { $random_cat_id = (int) $_GET['random_cat_id']; $query = "SELECT DISTINCT ID FROM $wpdb ->posts AS p INNER JOIN $wpdb->term_relationships AS tr ON (p.ID = tr.object_id AND tr.term_taxonomy_id = $random_cat_id) INNER JOIN $wpdb->term_taxonomy AS tt ON(tr.term_taxonomy_id = tt.term_taxonomy_id $post_type = preg_replace( '|[^a-z]|i', '', $_GET['random_post_type'] ); $query = "SELECT ID FROM $wpdb

49600发布于 2019-12-15

来自专栏Andromeda的专栏

给网站加一个定时发布《每天60s读懂世界》功能

$term_taxonomy_id = $wpdb->get_row("SELECT tt.term_taxonomy_id from $wpdb->terms t join $wpdb->term_taxonomy $term_taxonomy_id) { $wpdb->query("insert into $wpdb->terms (name,slug,term_group)VALUES('每天60秒读懂世界 ','60秒','0')"); $category_id = $wpdb->insert_id; $wpdb->query("insert into $wpdb->term_taxonomy ->get_row("SELECT id from $wpdb->posts where post_title = '$title' "); if (! $insertid; $wpdb->query(" UPDATE $wpdb->posts SET guid=$post_guid where id = $insertid "); /

78450编辑于 2023-10-21

来自专栏灵简

关于wordpress文章id不连贯的问题

function wpbf_set_next_post_id() { global $wpdb; $last_post_id = (int) $wpdb->get_var("SELECT ; $wpdb->query("DELETE FROM $wpdb->posts WHERE post_status = 'auto-draft' OR post_type = ; $last_post_id = (int) $wpdb->get_var("SELECT MAX(ID) FROM $wpdb->posts"); if ($last_post_id > 0) { $next_post_id = $last_post_id + 1; $wpdb->query("ALTER TABLE $wpdb->posts AUTO_INCREMENT ; $wpdb->query("DELETE FROM $wpdb->posts WHERE post_status = 'auto-draft' OR post_type =

44510编辑于 2024-03-28

来自专栏WordPress果酱

WordPress 6.1 的 wpdb::prepare 将转义表和字段名称，加强程序的安全性

作为 WordPress 6.1 版本的一部分，wpdb::prepare() 也更新了，它可以使用 %i 占位符转义标识符（例如表和字段名称）。举个例子： $table = 'my_table'; $field = 'my_field'; $value = 'my_value'; $wpdb->prepare('SELECT * FROM %

49530编辑于 2023-04-13

来自专栏小狐狸说事

B2主题底部网站统计美化

; $count = $wpdb->get_var(' SELECT COUNT(comment_ID) FROM ' . ; $sql = "SELECT SUM(meta_value+0) FROM $wpdb->posts left join $wpdb->postmeta on ($wpdb->posts.ID ; $count=0; $views= $wpdb->get_results("SELECT * FROM $wpdb->postmeta WHERE meta_key='views'" ; $sql = "SELECT SUM(meta_value+0) FROM $wpdb->posts left join $wpdb->postmeta on ($wpdb->posts.ID ; $count=0; $views= $wpdb->get_results("SELECT * FROM $wpdb->postmeta WHERE meta_key='views'"); foreach

1.3K21编辑于 2022-11-17

来自专栏小俊博客

纯代码实现WordPress邀请码功能

$wpdb->prefix." $wpdb->prefix." $wpdb->prefix." $wpdb->prefix ." $wpdb->prefix ."

2.2K61发布于 2018-06-19

来自专栏帝讯博客

WordPress教程：如何删除文章的同时删除图片附件以及特色图像

/* 删除文章时删除图片附件 /* ———————— */ function delete_post_and_attachments($post_ID) { global $wpdb; //删除特色图片 $thumbnails = $wpdb->get_results("SELECT * FROM $wpdb->postmeta WHERE meta_key = '_thumbnail_id' AND ->get_results("SELECT * FROM $wpdb->posts WHERE post_parent = $post_ID AND post_type = 'attachment'") ; foreach ($attachments as $attachment) { wp_delete_attachment($attachment->ID, true); } $wpdb->query ("DELETE FROM $wpdb->postmeta WHERE meta_key = '_thumbnail_id' AND post_id = $post_ID"); } add_action

2.4K30编辑于 2022-11-23

来自专栏沈唁志

WordPress添加随便看看

// 添加随便看看 function random_postlite() { global $wpdb; $query = "SELECT ID FROM $wpdb->posts WHERE post_type random_cat_id'] ) ) { $random_cat_id = (int) $_GET['random_cat_id']; $query = "SELECT DISTINCT ID FROM $wpdb ->posts AS p INNER JOIN $wpdb->term_relationships AS tr ON (p.ID = tr.object_id AND tr.term_taxonomy_id = $random_cat_id) INNER JOIN $wpdb->term_taxonomy AS tt ON(tr.term_taxonomy_id = tt.term_taxonomy_id $post_type = preg_replace( '|[^a-z]|i', '', $_GET['random_post_type'] ); $query = "SELECT ID FROM $wpdb

88130发布于 2018-05-24

来自专栏WordPress果酱

WordPress 技巧：让搜索支持自定义字段

所以今天给花生小店实现根据商家编码搜索商品的功能：方法非常简单，只需要下面代码就可： add_action('posts_search', function($search, $query){ global $wpdb empty($query->query['s'])) { $sql = " OR EXISTS (SELECT * FROM {$wpdb->postmeta} WHERE post_id= {$wpdb->posts}.ID and meta_key = 'product_no' and meta_value like %s)"; $like = '%' . $wpdb->esc_like($query->query['s']) . '%'; $search .= $wpdb->prepare($sql, $like); } return $search

77620编辑于 2023-04-15

来自专栏钻芒博客

WordPress获取注册用户会员数量PHP

PHP获取WordPress注册的用户数量，效果如下图:图片图片代码一、global $wpdb$users = $wpdb->get_var("select count(id) from $wpdb- php global $wpdb;$users = $wpdb->get_var("select count(id) from $wpdb->users");echo "目前我们已经有 ".'

1.9K10编辑于 2023-05-16

来自专栏张戈的专栏

WordPress酷炫CSS3读者墙，排名按年度、本月、本周划分的小方法

->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->posts.ID=$wpdb->comments.comment_post_ID) WHERE comment_date ->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->posts.ID=$wpdb->comments.comment_post_ID) WHERE yearweek ->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->posts.ID=$wpdb->comments.comment_post_ID) WHERE comment_date ->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->posts.ID=$wpdb->comments.comment_post_ID) WHERE date_format ->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->posts.ID=$wpdb->comments.comment_post_ID) WHERE yearweek

1.1K30发布于 2018-03-23

来自专栏小狐狸说事

WordPress删除文章同时自动删除缩略图及图片附件。

/* 删除文章时删除图片附件 */ function delete_post_and_attachments($post_ID) { global $wpdb; //删除特色图片 $thumbnails = $wpdb->get_results( "SELECT * FROM $wpdb->postmeta WHERE meta_key = '_thumbnail_id' AND wp_delete_attachment( $thumbnail->meta_value, true ); } //删除图片附件 $attachments = $wpdb ->get_results( "SELECT * FROM $wpdb->posts WHERE post_parent = $post_ID AND post_type = 'attachment'" ( $attachments as $attachment ) { wp_delete_attachment( $attachment->ID, true ); } $wpdb

76851编辑于 2022-11-17

来自专栏张戈的专栏

WordPress获取文章浏览总数

实现很简单，网络上也已经有文章做了分享，代码如下： //浏览总数 function lo_all_view() { global $wpdb; $count=0; $views= $wpdb->get_results("SELECT * FROM $wpdb->postmeta WHERE meta_key='views'"); foreach($views as $key */ function lo_all_view(){ global $wpdb; $count = $wpdb->get_var("SELECT sum(meta_value) FROM $wpdb->postmeta WHERE meta_key='views'"); return $count; } 实现更加简单，直接使用 MySQL 的 sum 方法计算浏览总数，一步到位

1.4K140发布于 2018-03-21

来自专栏WordPress技术文章

wordpress调用指定ID分类下的最新、最多阅读、最后评论的内容

SELECT DISTINCT {$wpdb->posts}.ID, {$wpdb->posts}.post_title, {$wpdb->posts}.post_date, {$wpdb->comments }.comment_date FROM {$wpdb->posts} INNER JOIN {$wpdb->comments} ON {$wpdb->posts}.ID = {$wpdb->comments}.comment_post_ID WHERE {$wpdb->posts}.post_status = 'publish' AND {$wpdb ->posts}.post_type = 'post' AND {$wpdb->posts}.ID IN ( SELECT object_id FROM {$wpdb }.comment_date DESC LIMIT %d "; $results = $wpdb->get_results($wpdb->prepare($sql, $cat_id

27700编辑于 2025-08-02

来自专栏Baili Blog

解决Word Press文章ID不连续的问题

//WordPress解决文章ID不连续的问题 function keep_id_continuous(){ global $wpdb; $lastID = $wpdb->get_var ("SELECT ID FROM $wpdb->posts WHERE post_status = 'publish' OR post_status = 'draft' OR post_status = private' OR ( post_status = 'inherit' AND post_type = 'attachment' ) ORDER BY ID DESC LIMIT 1"); $wpdb ->query("DELETE FROM $wpdb->posts WHERE ( post_status = 'auto-draft' OR ( post_status = 'inherit' AND post_type = 'revision' ) ) AND ID > $lastID"); $lastID++; $wpdb->query("ALTER TABLE $wpdb->posts

78640编辑于 2023-03-16

来自专栏ytkah

如何让wordpress后台搜索只匹配搜索文章标题

empty( $wp_query->query_vars['search_terms'] ) ) { global $wpdb; $q = $wp_query->query_vars search = array(); foreach ( ( array ) $q['search_terms'] as $term ) $search[] = $wpdb ->prepare( "$wpdb->posts.post_title LIKE %s", $n . $wpdb->esc_like( $term ) . $n ); if ( ! is_user_logged_in() ) $search[] = "$wpdb->posts.post_password = ''"; $search = '

1.6K20发布于 2019-09-30

来自专栏网页杂谈

WordPress评论统计图

php global $wpdb; $numbers_day = 120; $numbers_month = 13; $numbers_user = 12; $query_day ="SELECT COUNT (*) AS `cnt` , DATE_FORMAT( `comment_date` , '%Y-%m-%d' ) AS d FROM $wpdb->comments GROUP BY d ORDER COUNT( comment_author_email ) AS number, comment_author_email, comment_author FROM ( SELECT * FROM $wpdb ->comments LEFT OUTER JOIN $wpdb->posts ON ( $wpdb->posts.ID = $wpdb->comments.comment_post_ID ) WHERE ->get_results($query_day); $output_month = $wpdb->get_results($query_month); $output_user = $wpdb->get_results

1.1K11编辑于 2022-11-11

第 2 页第 3 页第 4 页第 5 页第 6 页第 7 页第 8 页第 9 页第 10 页

点击加载更多

DIY网站统计：WordPress排除管理员评论及精准友链数的方法