WordPress: Get post id by meta key and value
<?php | |
if (!function_exists('get_post_id_by_meta_key_and_value')) { | |
/** | |
* Get post id from meta key and value | |
* @param string $key | |
* @param mixed $value | |
* @return int|bool | |
* @author David Mårtensson <david.martensson@gmail.com> | |
*/ | |
function get_post_id_by_meta_key_and_value($key, $value) { | |
global $wpdb; | |
$meta = $wpdb->get_results("SELECT * FROM `".$wpdb->postmeta."` WHERE meta_key='".$wpdb->escape($key)."' AND meta_value='".$wpdb->escape($value)."'"); | |
if (is_array($meta) && !empty($meta) && isset($meta[0])) { | |
$meta = $meta[0]; | |
} | |
if (is_object($meta)) { | |
return $meta->post_id; | |
} | |
else { | |
return false; | |
} | |
} | |
} |
This comment has been minimized.
This comment has been minimized.
For WP version >= 3.6, use esc_sql() instead of $wpdb->escape and it should not throw any notice. |
This comment has been minimized.
This comment has been minimized.
Thanks for it |
This comment has been minimized.
This comment has been minimized.
For WP version >= 3.6 use in line 12 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This comment has been minimized.
is this code get the ID is the last post when have more result?