WP_Query checkbox array string error

• 

  • wecandoit

  • November 11, 2021 at 9:25 pm

  Hello,
  I try to build a form for my visitor to allow “filter” post. I have 2 fields with price and 1 with checkbox.

  Now that’s work but it’s too restrictiv. I have 3 checkbox with value “decoration”, “sport”, “jeux”. When I checked one it’s that’s return the right post. When I check 2 or more this return only post the values I want all the post with only 1 value correct not specially too.

  Exemple
  Post 1 = decoration, sport
  Post 2 = decoration, jeux
  Post 3 = jeux

  If I checked decoration
  Return Post 1 and 2 ok

  If I checked decoration and jeux
  Return Post 2 but I want numbers 2 and 3. I think it’s maybe a compare problem ?

  My code

  <form action=" <?php $term_link; ?>" method="get">
      <label>min:</label>
      <input type="number" name="minprice" value="<?php echo $minprice; ?>">
      <label>max:</label>
      <input type="number" name="maxprice" value="<?php echo $maxprice; ?>">
  
      <label>Hobbies:</label>
      <div>
       <p><input type="checkbox" id="aimerparlapersonne" name="passion[]" value="decoration">Décoration</p>
       <p><input type="checkbox" id="aimerparlapersonne" name="passion[]" value="sport">Sport</p>
       <p><input type="checkbox" id="aimerparlapersonne" name="passion[]" value="jeux">Jeux</p>
      </div>
  
      <button type="submit" name="">Filter</button>
  </form>
  
       <?php
              if($_GET['minprice'] && !empty($_GET['minprice']))
              {
                  $minprice = $_GET['minprice'];
              } else {
                  $minprice = 0;
              }
  
              if($_GET['maxprice'] && !empty($_GET['maxprice']))
              {
                  $maxprice = $_GET['maxprice'];
              } else {
                  $maxprice = 999999;
              }
  
              if($_GET['passion'] && !empty($_GET['passion']))
               {
                   $passion = $_GET['passion'];
  
                   // Get the selected options
                  $meta_query = array('passion' => 'OR');
                   foreach((array) $passion as $passions){
                     $meta_query[] = array(
                         'key'     => 'aimerparlapersonne',
                         'value'   => $passions,
                         'compare' => 'LIKE',
                     );
                  }
               }
  
              ?>
  
  <?php
         $qobjet = get_queried_object();
         $args = array(
                 'post_type' => 'post'
                 'posts_per_page' => 20	,
                 'tax_query' => array(
                                    array(
                                      'taxonomy' => $qobjet->taxonomy,
                                      'field' => 'id',
                                      'terms' => $qobjet->term_id,
                                        ),
                                      ),
                  'relation' => 'AND',
                  'meta_query' => array(
                                     array(
                                         'key' => 'prix',
                                         'type' => 'NUMERIC',
                                         'value' => array($minprice, $maxprice),
                                         'compare' => 'BETWEEN'
                                     ),
  
                   'meta_query' => $meta_query,
                                  ),
                      );
  
          $query = new WP_Query($args);?>
         <?php if ($query->have_posts() ) : while ($query->have_posts() ) : $query->	the_post(); // run the loop ?>
         <?php get_template_part( 'content-category', get_post_format() ); ?>
         <?php endwhile; ?>
       <?php endif;?>
   <?php wp_reset_query();?>
• 

  • wecandoit

  • November 12, 2021 at 9:04 am

  By the way a
  var_dump($_GET['passion']);

  Give me this

    0 => string 'decoration' (length=10)
    1 => string 'sport' (length=5)

  Hope I will have some help cause I really need this form 🙂
• 

  

  • John Huebner

  • November 12, 2021 at 10:57 am

  Your problem is here, you are trying to set the “meta_query” argument twice.

  
       'meta_query' => array(
                                     array(
                                         'key' => 'prix',
                                         'type' => 'NUMERIC',
                                         'value' => array($minprice, $maxprice),
                                         'compare' => 'BETWEEN'
                                     ),
  
                   'meta_query' => $meta_query,
  

  In this case “meta_query” will always be set to $meta_query and the part using “prix” will never happen. Your meta query also has other issues

  
  <?php
  
  $meta_query = array(
    'relation' => 'AND'
  );
  
  if($_GET['minprice'] && !empty($_GET['minprice'])) {
    $minprice = $_GET['minprice'];
  } else {
    $minprice = 0;
  }
  
  if($_GET['maxprice'] && !empty($_GET['maxprice'])) {
    $maxprice = $_GET['maxprice'];
  } else {
    $maxprice = 999999;
  }
  
  $meta_query[] = array(
    'key' => 'prix',
    'type' => 'NUMERIC',
    'value' => array($minprice, $maxprice),
    'compare' => 'BETWEEN'
  );
  
  if($_GET['passion'] && !empty($_GET['passion'])) {
    $passions = $_GET['passion'];
    $nested_query = array(
      'relation' => 'OR'
    );
    foreach((array) $passion as $passions){
      $nested_query[] =  array(
        'key'     => 'aimerparlapersonne',
        'value'   => $passions,
        'compare' => 'LIKE',
      );
    }
    $meta_query[] = $nested_query;
  }
  
  $args = array(
    'post_type' => 'post',
    'posts_per_page' => 20,
    'tax_query' => array(
      array(
        'taxonomy' => $qobjet->taxonomy,
        'field' => 'id',
        'terms' => $qobjet->term_id,
      ),
    ),
    'meta_query' => $meta_query
  );
  
  
• 

  

  • John Huebner

  • November 12, 2021 at 11:22 am

  I accidentally added an s here

  
  $passions = $_GET['passion'];
  

  this should have been

  
  $passion = $_GET['passion'];
  

  from your original code
• 

  • wecandoit

  • November 12, 2021 at 11:25 am

  You are my heros !
  Tahnks a lot 🙂
• 

  • wecandoit

  • November 12, 2021 at 12:57 pm

  @John
  I have another question. How to make to “checked” when I do a filter ?

  Now When I filter my post checkbox are still “uncheck”.
  Hope U will read this.
• 

  

  • John Huebner

  • November 12, 2021 at 1:03 pm

  
  <input type="checkbox" id="aimerparlapersonne" name="passion[]" value="decoration" <?php 
    if (!empty($_GET['passion']) && in_array('decoration', $_GET['passion'])) {
      echo 'checked="checked";
    }
  ?>>Décoration