You may be able to use a WP_Query on nav_menu_item since it is its own post type. I’ve never done this but maybe it would work like you need it to, worth a shot. There are three other possibilities: Option 1 – Get Your Nav Menu Items There’s a functions called wp_get_nav_menu_items() which will return … Read more
One problem with the query is that the self-join with the ambiguous WHERE gives you a crossed dataset (which is masked by the DISTINCT), so it would be simpler to use wp_post as a base to attach the joins that precisely match the keys, eg SELECT p.ID, key1.meta_value as prog_ongoing, key2.meta_value as prog_date_start FROM $wpdb->posts … Read more
Maybe a bit late … add_action( ‘pre_get_posts’, function($query) { if ( !is_admin() && $query->is_main_query() && is_post_type_archive( ‘[your_post_type]’ ) ) { $query->set(‘meta_query’, array( ‘_property_price’ => array( ‘key’ => ‘_property_price’, ), ‘_property_featured’ => array( ‘key’ => ‘_property_featured’, ) )); $query->set(‘orderby’,array( ‘_property_price’ => ‘DESC’, ‘_property_featured’ => ‘DESC’ )); } return $query; } );
As @Howdy_McGee suggested and I made a quick test. Removing key do the trick so you can just remove the key and add compare LIKE if you do not want exact match. Example:- $posts = new WP_Query(array( ‘meta_query’ => array( array( ‘value’ => ‘meta_value’ ) ) )); This will produce the SQL like WHERE 1=1 … Read more
If you have access to remote MySQL, this MIGHT help you. I’ve done this a while ago when i had another issue with my hosting provider. Take a full backup of your WordPress files, but not your database. Copy them to your localhost. Now, instead of using a local database, in your wp-config.php file, set … Read more
I understand your confusion but you haven’t something to worry about as behinds the scenes WordPress make all the necessary steps to make it work. For example, take the following code from the class-wp-query.php // If querystring ‘cat’ is an array, implode it. if ( is_array( $q[‘cat’] ) ) { $q[‘cat’] = implode( ‘,’, $q[‘cat’] … Read more
You need to add a \ in front of the WP_Query call to tell PHP that it’s in the global namespace and not the namespace of this class. Try this: $query = new \WP_Query($args);
You can use the WP_Query(); to check that like this: $my_query = new WP_Query(); $my_query->query(array( ‘meta_key’ => ‘X’, ‘meta_value’ => ‘Y’)); if ( $my_query->have_posts() ){ //it exists } else { //it’s not here } Hope this helps.
You can use the http://managewp.com/ to maage all your sites from one dashboard. From site ManageWP helps you manage all your WordPress sites from one location, keeping them updated and secure.
array( ‘relation’ => ‘OR’, array( ‘key’ => ‘status’, ‘value’ => ”, //<— not required but necessary in this case ‘compare’ => ‘NOT EXISTS’, ), array( ‘key’ => ‘status’, ‘value’ => ‘new’, ‘compare’ => ‘=’, ), ); That should do it.