在Wordpress中运行查询 - Run Query within Wordpress

Run Query within Wordpress

本文关键字：查询运行 Wordpress | 更新日期: 2023-09-27

每次我的客户端上传产品时，我都需要运行这个查询，那么我如何在Wordpress中运行这个查询呢？我想把它与函数中的一个动作联系起来。php

UPDATE wp_postmeta
    JOIN wp_posts ON wp_posts.id = wp_postmeta.post_id
    SET wp_postmeta.meta_value = 'no'
    WHERE (wp_posts.post_title = '4x6' AND wp_postmeta.meta_key = '_virtual')

在函数中添加此代码。hp:

function on_product_publish( $new_status, $old_status, $post ) {
    global $post;
    if ( 'publish' !== $new_status or 'publish' === $old_status ) return;
    $wpdb->query("UPDATE wp_postmeta
    JOIN wp_posts ON wp_posts.id = wp_postmeta.post_id
    SET wp_postmeta.meta_value = 'no'
    WHERE (wp_posts.post_title = '4x6' AND wp_postmeta.meta_key = '_virtual')");
}
add_action( 'transition_post_status', 'on_product_publish', 10, 3 );