How to know if get_posts() failed?

by

So I see that get_posts() function return an array of posts.

  1. If there are posts, it returns an array of posts.

  2. If there are no posts it returns an empty array().

  3. If there are posts, but the querying of the database fails (and let’s say, 99.999% times it returns correct, but this time it fails for some reason), it returns an empty array. (Important: I’m not sure of this, this is what I understand when I read how this function works).

My question is this: If I use this function, when do I know if the function failed? (Like there are some functions which returns an WP_Error.)

1 Answer
1

Here’s one way to check if there was an DB error within get_posts():

global $EZSQL_ERROR;

$before = isset( $EZSQL_ERROR ) ? count( $EZSQL_ERROR ) : 0;
$posts  = get_posts( $args );
$after  = isset( $EZSQL_ERROR ) ? count( $EZSQL_ERROR ) : 0;

if ( empty( $posts ) && $before < $after ) {
    // ... DB error(s) within get_posts() when it returns an empty array.
}

Here we check the number of wpdb errors before and after the get_posts() call from the global $EZSQL_ERROR errors collector (src).

But I can imagine that this might give a false positive in some cases though, e.g. if we hook a bad db calls within get_posts() that might not be the reason for empty posts array.

Update. I tested this and noticed that $wpdb->last_error is restored after each $wpdb call. I noticed the global $EZSQL_ERROR array within wpdb::print_error() that is not restored but collects the errors. I therefore updated the answer and replaced $wpdb->last_error with $EZSQL_ERROR.

Leave a Comment