snipt

Ctrl+h for KB shortcuts

PHP

Wordpress search by custom fields

//one way
<?php query_posts('meta_key=movie&meta_value='.$s); ?>

//second way
    global $wpdb;
    // If you use a custom search form
    // $keyword = sanitize_text_field( $_POST['keyword'] );
    // If you use default WordPress search form
    $keyword = get_search_query();
    $keyword = '%' . like_escape( $keyword ) . '%'; // Thanks Manny Fleurmond
    // Search in all custom fields
    $post_ids_meta = $wpdb->get_col( $wpdb->prepare( "
    SELECT DISTINCT post_id FROM {$wpdb->postmeta}
    WHERE meta_value LIKE '%s'
    ", $keyword ) );
    // Search in post_title and post_content
    $post_ids_post = $wpdb->get_col( $wpdb->prepare( "
    SELECT DISTINCT ID FROM {$wpdb->posts}
    WHERE post_title LIKE '%s'
    OR post_content LIKE '%s'
    ", $keyword, $keyword ) );
    $post_ids = array_merge( $post_ids_meta, $post_ids_post );
    // Query arguments
    $args = array(
    'post_type' => 'post',
    'post_status' => 'publish',
    'post__in' => $post_ids,
    );
    $query = new WP_Query( $args );
    if ( $query->have_posts() ): while ( $query->have_posts() ) : $query->the_post();
    // Do loop here
    endwhile; endif;


//for pagination    
	$args['paged'] = max( get_query_var( 'paged' ), 1 );
    $query = new WP_Query( $args );
https://snipt.net/embed/0c8fce42bc64cecc07b2f2265bc8372a/
/raw/0c8fce42bc64cecc07b2f2265bc8372a/
0c8fce42bc64cecc07b2f2265bc8372a
php
PHP
39
2019-07-22T14:38:49
True
False
False
/api/public/snipt/57396/
wordpress-search-by-custom-fields
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a> <a href="#L-13">13</a> <a href="#L-14">14</a> <a href="#L-15">15</a> <a href="#L-16">16</a> <a href="#L-17">17</a> <a href="#L-18">18</a> <a href="#L-19">19</a> <a href="#L-20">20</a> <a href="#L-21">21</a> <a href="#L-22">22</a> <a href="#L-23">23</a> <a href="#L-24">24</a> <a href="#L-25">25</a> <a href="#L-26">26</a> <a href="#L-27">27</a> <a href="#L-28">28</a> <a href="#L-29">29</a> <a href="#L-30">30</a> <a href="#L-31">31</a> <a href="#L-32">32</a> <a href="#L-33">33</a> <a href="#L-34">34</a> <a href="#L-35">35</a> <a href="#L-36">36</a> <a href="#L-37">37</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="x">//one way</span> </span><span id="L-2"><a name="L-2"></a><span class="cp">&lt;?php</span> <span class="nx">query_posts</span><span class="p">(</span><span class="s1">&#39;meta_key=movie&amp;meta_value=&#39;</span><span class="o">.</span><span class="nv">$s</span><span class="p">);</span> <span class="cp">?&gt;</span><span class="x"></span> </span><span id="L-3"><a name="L-3"></a> </span><span id="L-4"><a name="L-4"></a><span class="x">//second way</span> </span><span id="L-5"><a name="L-5"></a><span class="x"> global $wpdb;</span> </span><span id="L-6"><a name="L-6"></a><span class="x"> // If you use a custom search form</span> </span><span id="L-7"><a name="L-7"></a><span class="x"> // $keyword = sanitize_text_field( $_POST[&#39;keyword&#39;] );</span> </span><span id="L-8"><a name="L-8"></a><span class="x"> // If you use default WordPress search form</span> </span><span id="L-9"><a name="L-9"></a><span class="x"> $keyword = get_search_query();</span> </span><span id="L-10"><a name="L-10"></a><span class="x"> $keyword = &#39;%&#39; . like_escape( $keyword ) . &#39;%&#39;; // Thanks Manny Fleurmond</span> </span><span id="L-11"><a name="L-11"></a><span class="x"> // Search in all custom fields</span> </span><span id="L-12"><a name="L-12"></a><span class="x"> $post_ids_meta = $wpdb-&gt;get_col( $wpdb-&gt;prepare( &quot;</span> </span><span id="L-13"><a name="L-13"></a><span class="x"> SELECT DISTINCT post_id FROM {$wpdb-&gt;postmeta}</span> </span><span id="L-14"><a name="L-14"></a><span class="x"> WHERE meta_value LIKE &#39;%s&#39;</span> </span><span id="L-15"><a name="L-15"></a><span class="x"> &quot;, $keyword ) );</span> </span><span id="L-16"><a name="L-16"></a><span class="x"> // Search in post_title and post_content</span> </span><span id="L-17"><a name="L-17"></a><span class="x"> $post_ids_post = $wpdb-&gt;get_col( $wpdb-&gt;prepare( &quot;</span> </span><span id="L-18"><a name="L-18"></a><span class="x"> SELECT DISTINCT ID FROM {$wpdb-&gt;posts}</span> </span><span id="L-19"><a name="L-19"></a><span class="x"> WHERE post_title LIKE &#39;%s&#39;</span> </span><span id="L-20"><a name="L-20"></a><span class="x"> OR post_content LIKE &#39;%s&#39;</span> </span><span id="L-21"><a name="L-21"></a><span class="x"> &quot;, $keyword, $keyword ) );</span> </span><span id="L-22"><a name="L-22"></a><span class="x"> $post_ids = array_merge( $post_ids_meta, $post_ids_post );</span> </span><span id="L-23"><a name="L-23"></a><span class="x"> // Query arguments</span> </span><span id="L-24"><a name="L-24"></a><span class="x"> $args = array(</span> </span><span id="L-25"><a name="L-25"></a><span class="x"> &#39;post_type&#39; =&gt; &#39;post&#39;,</span> </span><span id="L-26"><a name="L-26"></a><span class="x"> &#39;post_status&#39; =&gt; &#39;publish&#39;,</span> </span><span id="L-27"><a name="L-27"></a><span class="x"> &#39;post__in&#39; =&gt; $post_ids,</span> </span><span id="L-28"><a name="L-28"></a><span class="x"> );</span> </span><span id="L-29"><a name="L-29"></a><span class="x"> $query = new WP_Query( $args );</span> </span><span id="L-30"><a name="L-30"></a><span class="x"> if ( $query-&gt;have_posts() ): while ( $query-&gt;have_posts() ) : $query-&gt;the_post();</span> </span><span id="L-31"><a name="L-31"></a><span class="x"> // Do loop here</span> </span><span id="L-32"><a name="L-32"></a><span class="x"> endwhile; endif;</span> </span><span id="L-33"><a name="L-33"></a> </span><span id="L-34"><a name="L-34"></a> </span><span id="L-35"><a name="L-35"></a><span class="x">//for pagination </span> </span><span id="L-36"><a name="L-36"></a><span class="x"> $args[&#39;paged&#39;] = max( get_query_var( &#39;paged&#39; ), 1 );</span> </span><span id="L-37"><a name="L-37"></a><span class="x"> $query = new WP_Query( $args );</span> </span></pre></div> </td></tr></table>
custom, field, search, wordpress