How to use posts_where filter in WordPress

posts_where filter

Filters the WHERE clause of the query.

To use posts_where filter, first you have to register it using add_filter. You can write this code into functions.php of your activated theme or in a custom WordPress Plugin.

We at Flipper Code, always prefer to create a custom WordPress Plugin while using hooks so nothing breaks when you update your WordPress Theme in the future.

In the below live example, we have defined a function modify_posts_where_defaults which takes 2 parameters and we registered using add_filter. The first parameter posts_where is name of the hook, The second parameter modify_posts_where_defaults is name of the function which need to be called, third parameter is the priority of calling the hook if same hook is used multiple times and the last parameter is the number of arguments (if any) to be passed in the registered function.

Sometime, you have to remove a registered hook so you can use remove_filter to remove posts_where filter.

Parameters

Below are the 2 parameters are required to use this hook.

• $where : (string) The WHERE clause of the query.
• $query : (WP_Query) The WP_Query instance (passed by reference).

Live Example

add_filter( 'posts_where' , 'posts_where' );
 function posts_where( $where ) {
     if( is_admin() ) {
        global $wpdb;
                 if ( isset( $_GET['author_restrict_posts'] ) && !empty( $_GET['author_restrict_posts'] ) && intval( $_GET['author_restrict_posts'] ) != 0 ) {
            $author = intval( $_GET['author_restrict_posts'] );
          ;

Below is an example how you can use this hook.

                        function modify_posts_where_defaults($where, $query) { 
   
                            // Update the $where variable according to your website requirements and return this variable. You can modify the $where variable conditionally too if you want.

                            return $where; 
                        }
                        // add the filter
                        add_filter( "posts_where", "modify_posts_where_defaults", 10, 2 );

To remove a hook callback, use the example below.

remove_filter( "posts_where", "modify_posts_where_defaults", 10, 2 );

Please make sure provide the same callback function name, priority and number of arguments while removing the hook callback.

Flipper Code is a Premium WordPress Plugins development company and integrating new functionalites into WordPress sites in form of custom WordPress Plugins since 2012. If you’re having any trouble using this hook, please contact our WordPress Development Team and we’d be happy to assist you.