If post exists in the database - each time goes on `else`

Question

Firstly, I am a newbie when it comes to php. I have a plugin that periodically imports posts into my website. Normally, it should check if the post already exists, and if it does, it updates it. Otherwise it creates a new one. Now for some reason, it always takes the else path no matter what.

The if is like this:

if ( nmp_post_exists( $cam->username ) ) {

and the function is:

function nmp_post_exists($title) {
    global $wpdb;
    return $wpdb->get_row("SELECT * FROM wp_posts WHERE post_title = '" . $title . "'", 'ARRAY_A');
}   

Answer 1

I suspect that PHP considers the value of $wpdb->get_row("SELECT * FROM wp_posts WHERE post_title = '" . $title . "'", 'ARRAY_A'); to be true no matter what (see also this). You'll have to count the number of rows that are returned

Try something like this instead:

$query = "SELECT COUNT(*) FROM wp_posts WHERE post_title = '$title'";
$count = $wpdb->get_var($query);
return $count > 0;

Answer 2

The code was working fine. My problem was that I forgot that I changed the default prefix of the database. Sorry guys for wasting your time. Have a good one