WordPress.org

Make WordPress Core

Ticket #16283: idea.txt

File idea.txt, 926 bytes (added by piyushmishra, 4 years ago)

txt of a supposed idea

Line 
1function post_exists($title, $content = '', $date = '', $status = 'publish') {
2        global $wpdb;
3
4        $post_title = stripslashes( sanitize_post_field( 'post_title', $title, 0, 'db' ) );
5        $post_content = stripslashes( sanitize_post_field( 'post_content', $content, 0, 'db' ) );
6        $post_date = stripslashes( sanitize_post_field( 'post_date', $date, 0, 'db' ) );
7        $post_status = stripslashes( sanitize_post_field( 'post_status', $status, 0, 'db' ) );
8
9        $query = "SELECT ID FROM $wpdb->posts WHERE post_status=%s";
10        $args = array();
11        $args[] = $post_status;
12        if ( !empty ( $date ) ) {
13                $query .= ' AND post_date = %s';
14                $args[] = $post_date;
15        }
16
17        if ( !empty ( $title ) ) {
18                $query .= ' AND post_title = %s';
19                $args[] = $post_title;
20        }
21
22        if ( !empty ( $content ) ) {
23                $query .= 'AND post_content = %s';
24                $args[] = $post_content;
25        }
26
27        if ( !empty ( $args ) )
28                return $wpdb->get_var( $wpdb->prepare($query, $args) );
29
30        return 0;
31
32}