How to get user email from wp-user table in wordpress?
$user = get_user_by( 'login', 'admin' );
echo 'User is ' . $user->user_email.;
It's Not working.
Thanx & Regards
EDIT Since you want to retrieve a user based on username and get_user_by is not working you can try this:
global $wpdb;
$username = 'admin';
$email = $wpdb->get_var( $wpdb->prepare("
SELECT user_email
FROM $wpdb->users
WHERE user_login = %s
",
$username
) );
echo "$username's email is: $email";
You can get user data by field and data
$user = get_user_by( $field, $value );
For example: you get user date with email is example@gmail.com
$user = get_user_by( 'email', 'example@gmail.com' );
echo 'User is ' . $user->first_name . ' ' . $user->last_name;
To get more user data, you use to print_r
$user = get_user_by( 'email', 'example@gmail.com' );
print_r($user);