Skip to content

Instantly share code, notes, and snippets.

@YOzaz

YOzaz/check.php

Last active December 3, 2018 12:31
Show Gist options
  • Save YOzaz/a16b75ba3ca7a382bebf4edab11a9104 to your computer and use it in GitHub Desktop.
Save YOzaz/a16b75ba3ca7a382bebf4edab11a9104 to your computer and use it in GitHub Desktop.
Download ZIP
Check if image exists using `wp_posts` table
Raw
check.php
<?php
global $wpdb;
$image_src = wp_upload_dir()['baseurl'] . '/' . _wp_relative_upload_path( $filename );
$query = "SELECT COUNT(*) FROM {$wpdb->posts} WHERE guid='$image_src'";
$count = intval($wpdb->get_var($query));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment