Wordpress how to prevent duplicate post by checking if post title exist before running "wp_insert_post"?

Question

I have a wordpress site that connects to a soap server. The problem is every time I run the script the wp_insert_post is using the same result again.

I would like to check if existing post_title matches the value from $title then if they match, prevent wp_insert_post from using the same value again.

Here's the code:

try {
    $client = new SoapClient($wsdl, array('login' => $username, 'password' => $password));
    } catch(Exception $e) {
      die('Couldn\'t establish connection to weblink service.');
    }
$publications = $client->GetPublicationSummaries();
foreach ($publications->GetPublicationSummariesResult->PublicationSummaries->PublicationSummary as $publication_summary) {

    // get the complete publication from the webservice
    $publication = $client->getPublication(array('PublicationId' => $publication_summary->ID))->GetPublicationResult->Publication;
    
    // get all properties and put them in an array
    $properties = array();
    foreach ($publication->Property as $attribute => $value) {
        $properties[$attribute] = $value;
    }
    
    // Assemble basic title from properties
    $title = $properties['Address']->Street . ' ' . $properties['Address']->HouseNumber . $properties['Address']->HouseNumberExtension . ', ' . $properties['Address']->City->_;
}

$my_post = array(
    'post_title'=>$title,
    'post_content'=>'my contents',
    'post_status'=>'draft',
    'post_type'=>'skarabeepublication',
    'post_author'=>1,
);
wp_insert_post($my_post);

Thank you for any help.

Berget

you should try this code. require( dirname(FILE) . '/wp-load.php' ); global $wpdb; echo $count = $wpdb->get_var("select COUNT(*) from $wpdb->posts where post_title like '$title' "); – Hosier

Answer 1

Sorry for the late response. I used what Robot says in the comment and this solved my problem. Thanks

$post_if = $wpdb->get_var("SELECT count(post_title) FROM $wpdb->posts WHERE post_title like '$title_from_soap'");
if($post_if < 1){
    //code here
}

Berget

Answer 2

You can use get_page_by_title() as it supports custom post types now.

if (!get_page_by_title($title, OBJECT, 'skarabeepublication')) :

    $my_post = array(
        'post_title'=>$title,
        'post_content'=>'my contents',
        'post_status'=>'draft',
        'post_type'=>'skarabeepublication',
        'post_author'=>1,
    );
    wp_insert_post($my_post);

endif;

Codex information here

Lacteous

I like this method for taking advantage of built-in functions for the best results. I believe the first line should be: "if (! get_page_by_title($title, OBJECT, 'skarabeepublication') ) :" – Adon

OBJECT shouldn't have apostrophes, but otherwise this method works perfectly and is still valid as of WordPress 4.7.3. – Amish

It will also returning the draft and trash posts. – Oralla

Answer 3

Surprised not to see mention of post_exists function in wp-includes/post.php. See entry on wpseek. There is no entry in the codex. At it's simplest it works like get_page_by_title but returns a post id (or 0 if not found) instead of the object (or null).

$post_id = post_exists( $my_title );
if (!$post_id) {
    // code here
}

Cantlon

There is now an entry on post_exists in the Wordpress Developer Code Reference. – Cantlon

Answer 4

sampler:

if( !get_page_by_path('mypageslug',OBJECT,'post') ){
  //your codes
}

Bernettabernette