How to do WP_User_Query for Nested Array value Inside Nested Array field
How to do WP_User_Query for Nested Array value Inside Nested Array field
wp-user-query
How to display replies to his comments in user profile of current user
I also have a page where I list comments and replies to the current user comments. I might not be able to explain the answer very well, but this is what I did. I listed all the comments of the current user and listed again the comments with the parent_id of the current user’s comments. … Read more
Find count of WordPress users by role and search string for user name
Adding this as an answer here for reference for anyone searching for WP_User_Query stuff: As per the docs The search field on WP_User_Query uses * for wildcard text search, and will search on login, nicename, email and URL, unless specified otherwise. E.g. to match any name containing bob you need: $args = array( ‘search’ => … Read more
Getting user data via ajax
Once you get the id of the user in members variable. You then have to use get_post_meta to get the custom data of members because ACF uses meta boxes. After that merge the data with the members variable and then pass the variable to WP_REST_Response class. I would have commented but that reputation, so posted … Read more
SQL to join u3g_users & u3g_meta_value with repeating data
SQL to join u3g_users & u3g_meta_value with repeating data
I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
Look up user_registered in your database and set a valid value. This should be a datetime type, as described in the WordPress Codex. Press CMD/CTRL + F and lookup user_registered to quickly navigate.
How to grab data after wp user search is complete
How to grab data after wp user search is complete
Cannot update newly added User field using wp_update_user
Cannot update newly added User field using wp_update_user
SQL to set Display Name to First Name + Last Name
Figured out the SQL query that can be used to reset the display_name to first_name + last_name. And it’s simpler than the JOINs that I was trying when I posted the question. UPDATE wp_users SET display_name = Concat( (SELECT meta_value FROM wp_usermeta WHERE meta_key = ‘first_name’ AND user_id = id ), ‘ ‘, (SELECT meta_value … Read more
Display the list of user’s comments + the post title + date
add this snippet for according your needed: add_shortcode ( ‘show_recent_comments’, ‘show_recent_comments_handler’ ); function show_recent_comments_handler( $atts, $content = null ) { extract( shortcode_atts( array( “count” => 10, “pretty_permalink” => 0 ), $atts )); $output=””; // this holds the output if ( is_user_logged_in() ) { global $current_user; get_currentuserinfo(); $args = array( ‘user_id’ => $current_user->ID, ‘number’ => $count, … Read more