• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
WooCommerce a2z

WooCommerce a2z

WooCommerce

  • Home
  • Plugins
  • Blocks
  • Shortcodes
  • APIs
  • Classes
  • Files
  • Hooks
  • Sitemap
  • Blog
Home / APIs / WC_Query::get_main_search_query_sql() – Based on WP_Query::parse_search

You appear to be a bot. Output may be restricted

Description

Based on WP_Query::parse_search

Usage

WC_Query::get_main_search_query_sql();

Parameters

Returns

void

Source

File name: woocommerce/includes/class-wc-query.php
Lines:

1 to 31 of 31
  public static function get_main_search_query_sql() {
    global $wpdb;

    $args         = self::$product_query->query_vars;
    $search_terms = isset( $args['search_terms'] ) ? $args['search_terms'] : array();
    $sql          = array();

    foreach ( $search_terms as $term ) {
      // Terms prefixed with '-' should be excluded.
      $include = '-' !== substr( $term, 0, 1 );

      if ( $include ) {
        $like_op  = 'LIKE';
        $andor_op = 'OR';
      } else {
        $like_op  = 'NOT LIKE';
        $andor_op = 'AND';
        $term     = substr( $term, 1 );
      }

      $like = '%' . $wpdb->esc_like( $term ) . '%';
      // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
      $sql[] = $wpdb->prepare( "(($wpdb->posts.post_title $like_op %s) $andor_op ($wpdb->posts.post_excerpt $like_op %s) $andor_op ($wpdb->posts.post_content $like_op %s))", $like, $like, $like );
    }

    if ( ! empty( $sql ) && ! is_user_logged_in() ) {
      $sql[] = "($wpdb->posts.post_password = '')";
    }

    return implode( ' AND ', $sql );
  }
 

 View on GitHub View on Trac

Published: 26th November 2019 | Last updated: 21st August 2020

Primary Sidebar

Information

Function name: WC_Query::get_main_search_query_sql
Class ref: WC_Query
Plugin ref: WooCommerce
Version: 5.2.2
Sourcefile: includes/class-wc-query.php
File ref: includes/class-wc-query.php
Deprecated?: No
API Letters: G,M,Q,S,W

Footer

WooCommerce a2z
WooCommerce a2z
WooCommerce
WordPress 5.7.1
WordPress a2z
WordPress core a2z
Genesis Theme Framework a2z
Jetpack a2z
WordPress develop tests
Easy Digital Downloads a2z
WooCommerce a2z
Yoast SEO a2z
WordPress Blocks

Site:  woocommerce.wp-a2z.org
© Copyright WooCommerce a2z 2014-2021. All rights reserved.


Website designed and developed by Herb Miller
Proudly powered by WordPress and oik plugins

  • Home
  • Blog
  • Sitemap
  • Sites