Retrieve Attachment ID from Image URL
February 22, 2014What if you only have image URL, but you need attachment ID or different size of image? WordPress by default don’t have a function for retrieve attachment ID from Image URL, but with a few lines of code you can solve it
function get_image_id_by_url($image_url){ global $wpdb; $prefix = $wpdb->prefix; $attachment = $wpdb->get_col($wpdb->prepare("SELECT ID FROM " . $prefix . "posts" . " WHERE guid='%s';", $image_url )); return $attachment[0]; }
Usage in theme or plugin
$image_id = get_image_id_by_url($image_url); $image_thumb = wp_get_attachment_image_src($image_id, 'thumb-size'); echo '<img src="'.$image_thumb[0].'">';