Created
November 24, 2016 22:42
-
-
Save marcelotorres/40dd6784dfd5b71b881765be4d73d403 to your computer and use it in GitHub Desktop.
WordPress - get attachment id by guid/URL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// Pegar id do arquivo/imagem pela url | |
function get_attachment_id_by_guid( $attachment_url = '' ) { | |
global $wpdb; | |
$attachment_id = false; | |
// If there is no url, return. | |
if ( '' == $attachment_url ) | |
return; | |
// Get the upload directory paths | |
$upload_dir_paths = wp_upload_dir(); | |
// Make sure the upload path base directory exists in the attachment URL, to verify that we're working with a media library image | |
if ( false !== strpos( $attachment_url, $upload_dir_paths['baseurl'] ) ) { | |
// If this is the URL of an auto-generated thumbnail, get the URL of the original image | |
$attachment_url = preg_replace( '/-\d+x\d+(?=\.(jpg|jpeg|png|gif)$)/i', '', $attachment_url ); | |
// Remove the upload path base directory from the attachment URL | |
$attachment_url = str_replace( $upload_dir_paths['baseurl'] . '/', '', $attachment_url ); | |
// Finally, run a custom database query to get the attachment ID from the modified attachment URL | |
$attachment_id = $wpdb->get_var( $wpdb->prepare( "SELECT wposts.ID FROM {$wpdb->prefix}posts wposts, {$wpdb->prefix}postmeta wpostmeta WHERE wposts.ID = wpostmeta.post_id AND wpostmeta.meta_key = '_wp_attached_file' AND wpostmeta.meta_value = '%s' AND wposts.post_type = 'attachment'", $attachment_url ) ); | |
} | |
return $attachment_id; | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment