WordPress get post ID by post title

February 15th, 2011 at 11:34am Jason 3,009 views

When I was making MR J DICT, I want to get post id by title,but there is no template tags (get_post_by_title)directly to realize it. If you know a post id ,you can get the post title or content or slug very easily by using get_post($post_id).Still,if you want to Get page ID by title,you can use get_page_by_title.

BUT if you want to get the post id by title?When you have get or know the post title,how to get the post id? Here the codes below for you to test in sidebar.php of your template.

Firstly Get post ID by post title through querying the wordpress database,then you can use get_post($post_id) to get whatever you want to echo.

<?php
$posttitle = 'Hello world!';
$postid = $wpdb->get_var( "SELECT ID FROM $wpdb->posts WHERE post_title = '" . $posttitle . "'" );
echo $postid;
?>

<?php
$getpost= get_post($postid);
$postcontent= $getpost->post_content;
echo $postcontent;
?>

In order to make you understand how to query the database, here are two more samples just the same way as step 1.

<?php
$posttitle = 'Hello world!';
$post_slug_name = $wpdb->get_var( "SELECT post_name FROM $wpdb->posts WHERE post_title = '" . $posttitle . "'" );
echo $post_slug_name;
?>

<?php
$posttitle = 'Hello world!';
$post_content = $wpdb->get_var( "SELECT post_content FROM $wpdb->posts WHERE post_title = '" . $posttitle . "'" );
echo $post_content;
?>

Thanks get-wordpress-post-id-from-post-title

Entry Filed under: WordPress Tagged with: wordpress

Share This Post 丨 Subscribe 丨  Print This Post 丨 Save As PDF