首页 > 解决方案 > 如何使用带有 wordpress 插件的 PHP 获取日期

问题描述

我有一个插件,可以按照以下格式获取用户的生日:2021-08-04 (Y,M,D),但日期格式更改为 08/04/2021,如何在代码中更改?按照下面的代码:

private function show_widget() {
        /** @var $wpdb wpdb */
        global $wpdb;

        $results = $wpdb->get_results(
                        $wpdb->prepare(
                             "SELECT ID, display_name FROM wp_users
                            INNER JOIN wp_usermeta
                            ON wp_users.ID = wp_usermeta.user_id
                            WHERE meta_key = 'date_of_birth'
                            AND MONTH(meta_value) = %d
                            AND DAY(meta_value) = %d
                            ORDER BY display_name", date( 'n' ), date( 'j' )
                        )
        );

        if ( empty( $results ) ) {
            printf( '<p>%s</p>', __( 'Não há aniversariantes hoje...' ) );
        }

        foreach ( $results as $result ) {
            $user_id   = $result->ID;
            $user_name = $result->display_name;
            $user_url  = bp_core_get_user_domain( $user_id );

            printf(
                '<div class="userrow"><a href="%s">%s <span>%s</span></a></div>',
                $user_url,
                get_avatar( $user_id, 32, null, $user_name ),
                $user_name
            );
        }

    }

}

}

标签: phpwordpresspluginswordpress-plugin-creationmeta-key

解决方案


推荐阅读