get wordpress post by post title

问题:

i am using this code to show wordpress posts in an external website:

<?php
require('wp_blog/wp-blog-header.php');

    if($_GET["p"] > '') { ?>

    <?php query_posts('p='.$_GET["p"].''); ?>
    <?php while (have_posts()) : the_post(); ?>
        <h4><?php the_title(); ?></h4>
        <?php the_content(); ?>
    <?php endwhile; ?>
    <?php } else { ?>

    <?php
    $posts = get_posts('numberposts=10&order=ASC&orderby=post_title');
    foreach ($posts as $post) : setup_postdata( $post ); ?>
        <?php the_date(); echo "<br />"; ?>
        <?php the_title(); ?>    
        <?php the_excerpt(); ?> 
    <?php endforeach; ?>

    <?php } ?>

rather than selecting the post based on the ID, how can i make it select the post based on the post title?

回答1:

You can use get_page_by_title() to fetch post by title.Like this:

$page = get_page_by_title('About', OBJECT, 'post');
echo $page->ID

Details are here.

OR custom query like this :

$posttitle = 'About';
$postid = $wpdb->get_var( "SELECT ID FROM $wpdb->posts WHERE post_title = '" . $posttitle . "'" );
echo $postid;

回答2:

try this

$post_title = 'Contact';
$post_id = get_page_by_title($post_title, OBJECT, 'your_post_type_name');
echo $post_id->ID; // your id

回答3:

Add Function Like this

function get_page_by_post_name($post_name, $output = OBJECT, $post_type = 'post' ){
    global $wpdb;
    $page = $wpdb->get_var( $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_title = %s AND post_type= %s", $post_name, $post_type ) );

    if ( $page ) return get_post( $page, $output );

    return null;
}

 add_action('init','get_page_by_post_name');

And run like that:

 $page = get_page_by_post_name('hello-world', OBJECT, 'post');
 echo $page->ID;