Ticket #35246: post_exists.php

<?php

function post_exists($title, $content = '', $date = '') {
        global $wpdb;

        $post_title = wp_unslash( sanitize_post_field( 'post_title', $title, 0, 'db' ) );
        $post_content = wp_unslash( sanitize_post_field( 'post_content', $content, 0, 'db' ) );
        $post_date = wp_unslash( sanitize_post_field( 'post_date', $date, 0, 'db' ) );

        $query = "SELECT ID FROM $wpdb->posts WHERE ";
        $where = array();
        $args = array();

        if ( !empty ( $date ) ) {
                $where[] = 'post_date = %s';
                $args[] = $post_date;
        }

        if ( !empty ( $title ) ) {
                $where[] = 'post_title = %s';
                $args[] = $post_title;
        }

        if ( !empty ( $content ) ) {
                $where[] = 'post_content = %s';
                $args[] = $post_content;
        }

        $query .= implode( ' AND ', $where );

        if ( !empty ( $args ) )
                return (int) $wpdb->get_var( $wpdb->prepare($query, $args) );

        return 0;
}