You are saying “…doesn’t exist in the WordPress uploads directory” but you are actually using the WP_CONTENT_URL directory to determine it, which is wrong.
I keep the uploads directory outside the content directory as a rule for all my websites, and this would fail.

You should use UPLOADS instead.

It seems not work with old wordpress multisites when the files are saved on “wp-content/blogs.dir” directory because I have urls like http://*.domain.com/files/2014/08/image.jpg What do you recommend?

I’m running into trouble using this code coupled with the fact that my media is physically stored in an AWS s3 bucket. However it still is linked in my database and can be attached to posts with all the normal wordpress functions.

the way you have this set up it will return nothing because it see’s my media being stored elsewhere. Is there any way around that.

I tried commenting out the line:

if ( ! isset( $parsed_url[1] ) || empty( $parsed_url[1] ) || ( $this_host != $file_host ) ) {
return;
}
But it still returns nothing. Here is a sample of the url going into your function

http://momentsafterdark.s3-us-west-2.amazonaws.com/wp-content/uploads/2015/04/28032252/IMG_7584.jpg

You can see it’s attachment url here : http://www.momentsafterdark.ca/?attachment_id=1259

Any idea’s?

Thanks you. I used for get a cropped version of the current image url.

This code solves the problem of images like:
…/MyAmazingImage-250×150.jpg
and also use the UPLOADS folder 🙂


function get_attachment_id_by_url($url) {
global $wpdb;
// Get the upload directory paths
$upload_dir_paths = wp_upload_dir();

// Split the $url into two parts with the wp-content directory as the separator
$parsed_url = explode( parse_url( $upload_dir_paths['baseurl'], PHP_URL_PATH ), $url );
// Get the host of the current site and the host of the $url, ignoring www
$this_host = str_ireplace( 'www.', '', parse_url( home_url(), PHP_URL_HOST ) );
$file_host = str_ireplace( 'www.', '', parse_url( $url, PHP_URL_HOST ) );
// Return nothing if there aren't any $url parts or if the current host and $url host do not match
if ( ! isset( $parsed_url[1] ) || empty( $parsed_url[1] ) || ( $this_host != $file_host ) ) {
return;
}
// Now we're going to quickly search the DB for any attachment GUID with a partial path match
// Example: /uploads/2013/05/test-image.jpg
$parsed_url[1] = preg_replace('/-[0-9]{1,4}x[0-9]{1,4}.(jpg|jpeg|png|gif|bmp)$/i', '.$1', $parsed_url[1]);
$attachment = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM {$wpdb->prefix}posts WHERE guid RLIKE %s;", $parsed_url[1] ) );
// Returns null if no attachment is found
return $attachment[0];
}


Hi,

Some plugins use your code but this is not very optimised for big websites with a lot of images.

A query is made on all posts of the table wp_posts, or he would already be easier to target only attachments. #better #faster #stronger 😀

https://gist.github.com/asadowski10/496068291ec5ca5f3016

Thanks