Definition:
function post_exists($title, $content = '', $date = '') {}
Determine if a post exists based on title, content, and date
Parameters
- string $title: Post title
- string $content: Optional post content
- string $date: Optional post date
Return values
returns:Post ID if post exists, 0 otherwise.
Source code
function post_exists($title, $content = '', $date = '') { global $wpdb; $post_title = stripslashes( sanitize_post_field( 'post_title', $title, 0, 'db' ) ); $post_content = stripslashes( sanitize_post_field( 'post_content', $content, 0, 'db' ) ); $post_date = stripslashes( sanitize_post_field( 'post_date', $date, 0, 'db' ) ); $query = "SELECT ID FROM $wpdb->posts WHERE 1=1"; $args = array(); if ( !empty ( $date ) ) { $query .= ' AND post_date = %s'; $args[] = $post_date; } if ( !empty ( $title ) ) { $query .= ' AND post_title = %s'; $args[] = $post_title; } if ( !empty ( $content ) ) { $query .= 'AND post_content = %s'; $args[] = $post_content; } if ( !empty ( $args ) ) return $wpdb->get_var( $wpdb->prepare($query, $args) ); return 0; }
2571
No comments yet... Be the first to leave a reply!