To do this you need to use named meta query clauses according to the official developer docs for WP_Query: ‘orderby’ with multiple ‘meta_key’s If you wish to order by two different pieces of postmeta (for example, City first and State second), you need to combine and link your meta query to your orderby array using … Read more
After a lot of trial and error I learnt that WP_User_Query takes an argument fields which can be set to ‘all_with_meta’. This reduces number of queries to two for any number of users that are fetched in a single go and also provides benefits of caching. Usage would look like: $user_query = new WP_User_Query( array(‘include’ … Read more
You shouldn’t be passing in $users[“results”] directly to a foreach without checking that $users is an array, and that it has a ‘results’ key. What if $users is empty, or false, and a WP_Error object? In this case, it isn’t an array, it’s a WP_User_Query object. Casting it to an array won’t fix that. Instead … Read more
You can find any additional information in the usermeta table as meta_key meta_value pairs. Wordpress doesn’t create additional database columns for custom fields. That’s one of the great concepts that make WordPress so smart and flexible.
Method 1, SQL Notes about your SQL [Unknown column ‘wp_usermeta.meta_key’ in ‘where clause’] This is solved by adding this to the JOIN part of the query: JOIN wp_usermeta ON ( wp_usermeta.user_id = wp_users.ID ) You could check the value of the JOINS and, if false === strpos( ‘wp_usermeta’, $joins ), adding it yourself. When getting … Read more
You should use a total_users property: $query = new WP_User_Query( $args ); $query->total_users; or get_total method: $query = new WP_User_Query( $args ); $query-> get_total(); Docs are your friend: https://codex.wordpress.org/Class_Reference/WP_User_Query
You’re just seeing the indices (indexes). <?php $array = array( 1,2,3,4 ); print_r( $array); /* outputs: Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 ) */
It’s failing because WordPress isn’t loaded. Instead of making AJAX requests directly to PHP files in your theme, make them to a REST API endpoint. For example: add_action( ‘rest_api_init’, function () { register_rest_route( ‘petebolduc/v1’, ‘/test/’, array( ‘callback’ => ‘petebolduc_ajax’ ) ); } ); function petebolduc( $parameters ) { $foo = $parameters[‘foo’]; return “foo is ” … Read more
Edit: to clarify, the answer to How can I merge them together for results? Is that you really can’t, not without a lot of custom SQL and using filters. The complexity of going that route far outweighs any perceived benefits and wouldn’t be very future-proof. I’d recommend using the solution below and putting it all … Read more
I don’t see an “orderby Rand()” parameter for either get_users or WP_User_Query. There is a filter called pre_user_query that could be used but I am not sure I see the benefit of that when shuffle will randomize the array you already have. $args = array( ‘fields’ => ‘all_with_meta’, ‘exclude’ => array(1), ); $users = get_users( … Read more