It was actually much easier than I originally thought – just doing a WP_User_Query for a meta value (meta arrays are supported as well, like for the other query classes). public function on_deactivate() { $meta_key = ‘tools_page_tsi_per_page’; $query = new WP_User_Query( array( ‘meta_key’ => $meta_key ) ); if ( empty( $query->results ) ) return; foreach … Read more
When executing the generated SQL statement in MySQL it gave me The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay To fix that I had to call $wpdb->query( ‘SET OPTION SQL_BIG_SELECTS = 1’ ); right before calling WP_User_Query.
the most basic wordpress user query […] is displaying that it has not found any users You’re passing an empty array of query arguments and there’s an explicit check for that in the WP_User_Query constructor: /** * PHP5 constructor. * * @since 3.1.0 * * @param null|string|array $query Optional. The query variables. */ public function … Read more
The problem here is that this query has pagination by default, and what you’re asking for is not scalable. For example, this query fetches 5 posts at a time, and displays the 6th page of users: $user_query = new WP_User_Query( array( ‘number’ => 5, ‘offset’ => 25 ) ); You can pass -1 to fetch … Read more
I gave it a test run. First, I added a custom capability to a specific user, using following code $user = new WP_User( $user_id ); $user->add_cap( ‘team_member’ ); Luckily, this user can be retrieved using below code, as you suggested $args = array( ‘role’ => ‘team_member’ ); get_users( $args ); Which implicitly work like below … Read more
The problem is that you can’t use the value for the LIKE comparison as you’ve mentioned. The generated SQL will look something along the lines of: AND CAST(wp_usermeta.meta_value AS CHAR) LIKE ‘%B%’ which means that the query is set to look for every occurrence of letter B in our case. Of course this is not … Read more
Combining a meta query with a search for a keyword will return posts which match both the search query and the result of the meta query (even if you’re using relation => OR in the meta query). This answer covers a way to achieve your expected outcome for posts, which – you need to modify … Read more
The ID column if the wp_users table is the Primary Key and auto-incremented. If your table isn’t set that way then something must’ve gone wrong while it was getting created. Try deleting all the tables from the database and re-installing WordPress.
It looks like you’re searching for the first_name meta keys with empty string meta values: $options = array( ‘meta_query’ => array( array( ‘key’ => ‘first_name’, ‘value’ => ”, ‘compare’ => ‘=’, ), ) ); $users = get_users( $options ); that generates this kind of SQL query: SELECT wp_users.* FROM wp_users INNER JOIN wp_usermeta ON ( … Read more
I was able to find a solution: if(!empty($search)){ $query = $wpdb->prepare( “SELECT DISTINCT user_id FROM wp_usermeta WHERE meta_key = ‘pie_address_3’ AND meta_value LIKE %s “, ‘%’ . $search . ‘%’ ); $ids = $wpdb->get_results($query); ?> <ul class=”author-list”> <?php foreach ($ids as $id) { ?> <li> <img width=”90″ height=”90″ src=”https://wordpress.stackexchange.com/questions/182955/<?php echo get_user_meta($id->user_id,”pie_profile_pic_5″, true); ?>” class=”attachment-agent-image wp-post-image”> … Read more