user-meta - Read For Learn

I cannot find the difference between these wp_capabilities values in wp_usermeta

You’ve posted some serialized arrays. The first entry, a:1:{s:13:”administrator”;s:1;} is corrupted – that’s not a valid serialized array. The second entry, a:1:{s:13:”administrator”;s:1:”1″;} looks like this when unserialized: array ( ‘administrator’ => ‘1’, ) The third entry, a:1:{s:13:”administrator”;b:1;} looks like this when unserialized: array ( ‘administrator’ => true, ) In my setup, capabilities are stored like … Read more

Add additional Fields for users and get value

Meta table? (wp_usermeta or wp_postmeta)? You can get any meta of user by get_user_meta

award points to a user each time they update their cpt post

The save_post action fires when a post is updated and/or published, including when a new post is inserted. You can use it for custom post types also. Assume that your CPT is book. add_action( ‘save_book’, ‘wpse63478_save’ ); function wpse63478_save() { //Your Code to give point to user }

how to search all user meta data that have value like “vivek”

As you said data is stored inside meta_value as serialized format. You can match your string among the serialized string like data. $args = array( ‘meta_query’ => array( array( ‘key’ => ‘submitted’, ‘value’ => sprintf(‘:”%s”;’, ‘vivek’), ‘compare’ => ‘LIKE’ ) ) ); $query = new WP_User_Query( $args ); Hope this help!

Add user meta after a user has registered and logged In [closed]

You can add user meta after login by using the wp_login hook. Make sure to set a higher priority (99 – the default is 10) to make sure to get the data after everything has processed in the core wp_signon() function. From the Codex … function add_my_user_meta_after_login( $user_login, $user ) { //Add my user meta … Read more

Recovering the table wp_usermeta from users

Try it: INSERT INTO `wp_usermeta` VALUES (NULL, ‘1’, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’); INSERT INTO `wp_usermeta` VALUES (NULL, ‘1’, ‘wp_user_level’, ’10’);

Query Nickname rather than Display Name in custom Woocommerce plugin

I had a similar problem and solved it similar to this: add_filter(‘pre_user_display_name’,’default_display_name’); function default_display_name($display_name) { if ( isset( $_POST[‘billing_first_name’] ) ) { $display_name = sanitize_text_field( $_POST[‘billing_first_name’] ); } return $name; } I think, the new woocommerce changes the disyplay_name on every checkout to First_Name Last_Name. With the ‘pre_user_display_name’ you can change your own way.

Search users with custom meta data

try : $users = new WP_User_Query(array( ‘s’ => $yoursearchquery, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘billing_last_name’, ‘value’ => $yoursearchquery, ‘compare’ => ‘LIKE’ ), array( ‘key’ => ‘billing_first_name’, ‘value’ => $yoursearchquery, ‘compare’ => ‘LIKE’ ) ) ));

How can get all users by current user meta?

You can achieve this using get_users function and its meta_key argument as displayed below. $users = get_users(array( ‘meta_key’ => ‘blocking_users’, )); var_dump( $users ); To retrieve it for current user and print it, please use below code. $user_id = get_current_user_id(); $key = ‘blocking_users’; $single = false; $blocking_users = get_user_meta( $user_id, $key, $single ); echo ‘<p>The … Read more

Get emails from users by custom field SQL

I would do it this way: $args = array( ‘meta_query’ => array( array( ‘key’ => ‘options_futures’, ‘value’ => ‘Options’, ‘compare’ => ‘=’ ) ) ); $users = get_users($args);

+ More