How to fetch the records from the database with a custom field using where clause?

Question

I have 20 posts on my page and each post has a custom field called is_feature_home. I have to fetch the post where is_feature_home checked.

I tried the below code but I am not getting the correct output

function getpagecompany(){
  global $post;
   $args = array(  
        'post_type' => 'company',
        'post_status' => 'publish',
        'posts_per_page' => 8, 
        'is_feature_home'=>1,
    );

    $loop = new WP_Query( $args ); 
        
    while ( $loop->have_posts() ) : $loop->the_post(); 
        $tid=$loop->ID;

        print_r(the_title);
        // print_r(post_content);

    endwhile;

  wp_reset_postdata(); 
}

@CBroe, Thanks for sharing the link. This is a great link to learn. — Naren Verma
– Naren Verma, Commented Jun 7, 2021 at 11:54

wpdevloper_j · Accepted Answer · 2021-06-07 11:44:19Z

1

/* you must fetch post by meta key so please change your code with below */

function getpagecompany(){
  global $post;
   $args = array(  
        'post_type' => 'company',
        'post_status' => 'publish',
        'posts_per_page' => 8, 
        'meta_key'       => 'is_feature_home',
        'meta_value'     => '1',
        'meta_compare'   => '=' // default operator is (=) equals to 
      );

    $loop = new WP_Query( $args ); 
        
    while ( $loop->have_posts() ) : $loop->the_post(); 
        $tid=$loop->ID;

        print_r(the_title);
        // print_r(post_content);

    endwhile;

  wp_reset_postdata(); 
}

answered Jun 7, 2021 at 11:44

wpdevloper_j

3402 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Naren Verma Over a year ago

Let me try this answer

Naren Verma Over a year ago

Yes, it's displaying the correct output. If I have to use the more than 1 custom field then I have to repeat the meta_key code.. right?

wpdevloper_j Over a year ago

like: 'meta_query' => array( array( 'key' => 'key1', 'value' => 'value1' ) )

wpdevloper_j Over a year ago

let me know if you need more clarification for multiple fields

Naren Verma Over a year ago

Thanks for the help. i tried get_the_title() and get_the_content() and it's working.

|

Collectives™ on Stack Overflow

How to fetch the records from the database with a custom field using where clause?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related