user-meta - Read For Learn

Display sortable User meta column in admin panel user’s page

I replaced //make the new column sortable function user_sortable_columns( $columns ) { $columns[‘login_level’] = ‘login_level’; return $columns; } add_filter( ‘manage_users_sortable_columns’, ‘user_sortable_columns’ ); //set instructions on how to sort the new column function my_user_query($userquery){ if(‘login_level’ == $userquery->query_vars[‘orderby’]) { global $wpdb; $userquery->query_from .= ” LEFT OUTER JOIN $wpdb->usermeta AS alias ON ($wpdb->users.ID = alias.user_id) “;//note use of … Read more

Querying Email Addresses for a List of Users with Same Last Name?

Hi @Holidaymaine: Here’s the query you are looking for: <?php include( ‘../wp-load.php’ ); $sql =<<<SQL SELECT DISTINCT u.user_email AS user_email, um.meta_value AS user_lastname FROM {$wpdb->users} AS u LEFT JOIN {$wpdb->usermeta} AS um ON u.ID = um.user_id LEFT JOIN {$wpdb->posts} AS p ON u.ID = p.post_author LEFT JOIN {$wpdb->term_relationships} AS tr ON p.ID = tr.object_id LEFT … Read more

SQL query equivalent to WP User Query

Calling a method from functions.php on a click of a button

You could use AJAX if you don’t want to reload the current page — i.e. upon clicking the “Accept” button, make an AJAX request to update the user metadata, all without leaving the current page. However, the solution I’m proposing is not using AJAX; instead, we simply submit the form (set its action attribute value) … Read more

Plugin that would allow WordPress Authors to “follow” other Authors and query “Activity Info” from that

Just a plugin concept … Add a form with a button to each user profile, post or wherever you want it named Follow or Unfollow. Show the button only if is_user_logged_in(). You may use a widget for the form. On form submit update a user meta named follows for the user who clicked the button … Read more

Adding Custom User Profile data based upon Categories

here is an example //create the user category fields add_action( ‘show_user_profile’, ‘add_user_categories’ ); add_action( ‘edit_user_profile’, ‘add_user_categories’ ); function add_user_categories($user ){ ?> <table class=”form-table”> <tr> <th><label for=”user_categories”><?php _e(“User categories”); ?></label></th> <td> <?php $data = get_the_author_meta( ‘user_categories’, $user->ID ); $args = array( ‘hide_empty’ =>0, ‘taxonomy’=> ‘category’); $categories= get_categories($args); if ($categories){ foreach ( $categories as $category ){ if(in_array($category->term_id,(array)$data)) … Read more

Is there a limit to the length/size of serialized data that can be stored as user meta?

According to the DB schemea, the meta_value column is of type longtext, and that has a maximum size of 4GB, however you’re unlikely to reach that. Eitherway storing large quantities of data in a single field is bad both from a practical point of view, a performance point of view, and data storage. I advise … Read more

wp_get_current_user in custom file returns 0

The problem with your code is that you want to get current user to early. wp_get_current_user is using global current_user variable. But this variable isn’t set from the beginning. And if you want to use this function straight in the script file, then it’s to early. You should wait for init action to get current … Read more

Searching user meta using WP_User_Query

Try this: $yoursearchquery = ‘This is my search’; $users = new WP_User_Query(array( ‘search’ => $yoursearchquery, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘shoe_size’, ‘value’ => $yoursearchquery, ‘compare’ => ‘LIKE’ ), array( ‘key’ => ‘shoe_color’, ‘value’ => $search_operation, ‘compare’ => ‘LIKE’ ), array( ‘key’ => ‘shoe_maker’, ‘value’ => $yoursearchquery, ‘compare’ => ‘=’ ) ) … Read more

Where to Store Custom User Fields

I know this question is very old, but I wanted to share my experience with working with large databases and storing custom user data. Basically wp_usermeta is the default and easiest option to store user meta and it works really well for smaller databases, where you might want to store a few extra fields for … Read more

+ More