Wordpres 元查询

Question

我正在尝试从数据库中获取带有post_titlelike的帖子%Weapon%。

我尝试了下面的代码，但是single.php死了。

            $args = array(

                'numberposts'  => 20,

                'category'     => 4,

                'meta_query' => array(

                    array(

                    'key' => 'title',

                    'value' => "Weapon",

                    'compare' => 'LIKE'

                    )

                )

            );

            // $posts = get_posts($args);

            query_posts( $args );

我想从数据库所在的帖子得到post_title就好%Weapon%。

Answer 1

希望下面的代码对你有帮助<?php&nbsp;&nbsp; &nbsp; global $wpdb;&nbsp; &nbsp; $title = 'Weapon';&nbsp; &nbsp; $myposts = $wpdb->get_col( $wpdb->prepare("SELECT * FROM $wpdb->posts WHERE post_status = 'publish' AND&nbsp; post_title LIKE '%s'", '%'. $wpdb->esc_like( $title ) .'%'&nbsp; ) );&nbsp; &nbsp; foreach ( $myposts as $mypost )&nbsp;&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $post = get_post( $mypost );&nbsp; &nbsp; &nbsp; &nbsp; //run your output code here&nbsp; &nbsp; &nbsp; &nbsp; echo $post->post_title;&nbsp; &nbsp; }&nbsp;?>