Get Page ID by SHORTCODE in WordPress

For WordPress developer, sometimes we are required to know in which page the shortcode is placed and this example will show the function to get that page id/permalink within very small pieces of code.

Just paste the below code in functions.php file:

 

 

function wphats_get_page_url_by_shortcode($shortcode) {
 global $wpdb;

 $url = '';

 $sql = 'SELECT ID
  FROM ' . $wpdb->posts . '
  WHERE
   post_type = "page"
   AND post_status="publish"
   AND post_content LIKE "%' . $shortcode . '%"';

 if ($id = $wpdb->get_var($sql)) {
  $url = get_permalink($id);
 }

 return $url;
}

Now if you want to get the URL of your desired shortcode just call that function with SHORTCODE name. Example if your shortcode name is [CONTACT-FORM] then call the below function:

wphats_get_page_url_by_shortcode('[CONTACT-FORM]');

I hope this tutorial helps lots of WordPress developers to get a nice solution. If anything still you want to know, feel free to contact below.

Thanks.

This post has already been read 2763 times!