wp_query 显示以某些字符开头的页面 [英] wp_query to show pages that starts with some character

问题描述

对 wordpress 中的 wp-query 功能有疑问.我的问题是，是否可以只显示以某些字符开头的页面.例如，我想显示所有以字符 A 开头的页面，并且该页面是某个父页面的子页面.我知道如何显示一些全名的子页面:

$query = new WP_Query('pagename=contact_us/canada');

现在我想要类似的东西:

$query = new WP_Query('pagename=contact_us/c%');

那么所有名称以 c 开头的页面?我尝试使用 SQL 逻辑进行此操作，并将 % 用于任何字符.但这对我不起作用.

解决方案

我想出了这个，如果有人会遇到同样的问题，这里是解决方案:

get_results("SELECT * FROM $wpdb->posts WHERE post_title like 'T%' AND post_parent = '746' AND post_status='publish'");?><?php if ( $child_pages ) : foreach ( $child_pages as $pageChild ) : setup_postdata( $pageChild );?><div class="leksikon_rezultat"><span><?php echo $pageChild->post_title;?></span><a href="<?php echo get_permalink($pageChild->ID); ?>"rel="bookmark" title="<?php echo "Opširnije"; ?>"><?php echo "Opširnije";?></a>

<?php endforeach;万一;

因此，通过 $wpdb(wordpress 类 wpdb 的对象)，您可以使用经典 SQL 从 wordpress 数据库中的任何表中获取任何数据.

have question about wp-query function in wordpress. My question is, is it possible to show just pages that starts with some char. For example I want show all pages that starts with char A and also that page is child of some parent page. I know how to show child page with some full name:

$query = new WP_Query( 'pagename=contact_us/canada' );

Now I want something like:

$query = new WP_Query( 'pagename=contact_us/c%' ); 

So all pages that name begins with c ? I try this with with SQL logic and use % for any char. But it is not work for me.

解决方案

I figure out this and if someone will have same issue here is the solution:

<?php
    $child_pages = $wpdb->get_results("SELECT *    FROM $wpdb->posts WHERE post_title like 'T%' AND post_parent = '746' AND post_status='publish'");    ?>
    <?php if ( $child_pages ) : foreach ( $child_pages as $pageChild ) : setup_postdata( $pageChild ); ?>
    <div class="leksikon_rezultat">

            <span><?php echo $pageChild->post_title; ?></span>
            <a href="<?php echo  get_permalink($pageChild->ID); ?>" rel="bookmark" title="<?php echo "Opširnije"; ?>"><?php echo "Opširnije"; ?></a>
    </div>
    <?php endforeach; endif;

So with $wpdb (object of wordpress class wpdb) you can use classic SQL to get any data from any table in wordpress database.

这篇关于wp_query 显示以某些字符开头的页面的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！