query

WP_Query not ordering correctly

Question

I have two custom user meta fields created with ACF. One is quantidade_corretas_dia_4 (Numeric, integer) and another tempo_dia_4 (Numeric, decimal). I am using WP_User_Query to get users ordered by both this values like this:

custom-field, plugin-development, query, rest-api, wp-query joann2555 3 years 0 Answers 66 views

How do you query wordpress posts using a math formula between multiple meta field values?

Question

The following scenario is entirely fictitious, but it illustrates what I'm working on perfectly. Imagine that you have a school syllabus set up in WordPress. The students can turn in assignments early and get graded on them. Once they have a grade on it, if they are still well before the deadline

query, query-posts, wp-query Nicholas Cardot 3 years 0 Answers 52 views

Creating a view vs running query- speed, security?

Question

I am programming in wordpress and using a lot of MYSQL queries for custom dashboards and other information. I think I know the answer but is it better to create a number of Views in MYSQl and store them there or query everything from WP custom shortcodes? Obviously no matter what I have to call t

mysql, php, query Ted 3 years 0 Answers 48 views

How can I modify standard search query to include also ACF custom fields values?

Question

I have to check if word the user is looking for is also contained in a ACF custom fields. So I modify the standard query to search also into meta_query field I need: function modifica_search( $query ) { if ( $query->is_search() && $query->is_main_query() ) { $me

advanced-custom-fields, meta-query, query, search, wp-query Fabio 3 years 0 Answers 55 views

Get posts by category with pure SQL query

Question

I have a meeting post type, whose titles automatically get set to a date of the form m/d/Y. I have the below query which gets all unique years from the post titles by selecting distinct values after the last / inside the post title. SELECT DI

query, query-posts, sql chrispytoes 3 years 0 Answers 65 views

How to run select query of post with category and tags?

Question

I want to fetch multiple posts with categories and tags currently I'm using this query: $pagesize = 20; $pageNumber = 1; $mysql = mysqli_query($con,"SELECT p.post_title, p.ID, p.post_content, p.post_date, p.post_name as url, t.name as category_name FROM

categories, posts, query, sql Mohnish 3 years 0 Answers 47 views

Show first posts with custom field not empty and order all by title

Question

I have a custom post type called "products". My goal is to make my custom query that I have on homepage and also the search query show first the posts that have a custom field called "id_number" not empty and then the other posts that have the "id_number" empty. All should be ordered by title.

custom-field, custom-post-types, order, query Raul 3 years 0 Answers 51 views

How to create algorithm for ordering posts in WordPress?

Question

I have a news feed in my website where all the blog posts are displayed. Wordpress default is to dislay these in order "latest first". Using Elementor and Likebtn I have learned how to order the posts based on likes by creating a query ID "sort_by_likes" in Elementor Post Widget and inputting the

functions, php, plugins, query raen 3 years 0 Answers 48 views

Check if post exists

Question

How can I check if post with name for example Weather exists? If not I want to create it. function such_post_exists($title) { global $wpdb; $p_title = wp_unslash( sanitize_post_field( 'post_title', $title, 0, 'db' ) ); if ( !empty ( $title ) ) { return (int) $wpdb->query(

posts, query kilogram 3 years 0 Answers 52 views

custom query to get posts

Question

I want to create custom links like mydomain.com/custom_page/cat=ABC&tag=XYZ So that when a user clicks on the link s/he can see all posts in the category 'ABC' having tag 'XYZ' For this I've created a custom template with the following code

query, query-posts, wp-query Gaurav Srivastava 3 years 0 Answers 52 views

1 2 … 21

Register Now

Login

Lost Password

Add question

Login

Register Now