Get attachment ID by file path in WordPress

None of the other answers here appear to work properly or reliably for a file path. The answer using Pippin's function also is flawed, and doesn't really do things "the WordPress Way".

This function will support either a path OR a url, and relies on the built-in WordPress function attachment_url_to_postid to do the final processing properly:

/**
 * Find the post ID for a file PATH or URL
 *
 * @param string $path
 *
 * @return int
 */
function find_post_id_from_path( $path ) {
    // detect if is a media resize, and strip resize portion of file name
    if ( preg_match( '/(-\d{1,4}x\d{1,4})\.(jpg|jpeg|png|gif)$/i', $path, $matches ) ) {
        $path = str_ireplace( $matches[1], '', $path );
    }

    // process and include the year / month folders so WP function below finds properly
    if ( preg_match( '/uploads\/(\d{1,4}\/)?(\d{1,2}\/)?(.+)$/i', $path, $matches ) ) {
        unset( $matches[0] );
        $path = implode( '', $matches );
    }

    // at this point, $path contains the year/month/file name (without resize info)

    // call WP native function to find post ID properly
    return attachment_url_to_postid( $path );
}

UPDATE: since wp 4.0.0 there's a new function that could do the job. I didn't tested it yet, but it's this:

https://developer.wordpress.org/reference/functions/attachment_url_to_postid/


OLD ANSWER: so far, the best solution I've found out there, is the following:

https://frankiejarrett.com/2013/05/get-an-attachment-id-by-url-in-wordpress/

I think It's the best for 2 reasons:

  • It does some integrity checks
  • [important!] it's domain-agnostic. This makes for safe site moving. To me, this is a key feature.

I used this cool snipped by pippinsplugins.com

Add this function in your functions.php file

// retrieves the attachment ID from the file URL
function pippin_get_image_id($image_url) {
    global $wpdb;
    $attachment = $wpdb->get_col($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid='%s';", $image_url )); 
        return $attachment[0]; 
}

Then use this code in your page or template to store / print / use the ID:

// set the image url
$image_url = 'http://yoursite.com/wp-content/uploads/2011/02/14/image_name.jpg';

// store the image ID in a var
$image_id = pippin_get_image_id($image_url);

// print the id
echo $image_id;

Original post here: https://pippinsplugins.com/retrieve-attachment-id-from-image-url/

Hope ti helps ;) Francesco


Try attachment_url_to_postid function.

$rm_image_id = attachment_url_to_postid( 'http://example.com/wp-content/uploads/2016/05/castle-old.jpg' );
echo $rm_image_id;

More details

Tags:

Wordpress