WordPress Query Current User ID

June 6, 20233 Views

I would like to echo mysql data based on the current user that’s signed into WordPress.

Example:

SELECT * FROM wp_users WHERE wp_users.id=”current_signed_in_user”

So it will post all information from the table “wp_users” where the “wp_user.id” is the current signed in user’s ID.

Thanks in advance.

Post Views: 3

2 comments

Anonymous says:

June 6, 2023 at 1:10 pm

You should use <?php wp_get_current_user(); ?> but you still need to see ticket 14024
to play with it .

Resolved my issue by doing the following:

<?php
$current_user = wp_get_current_user();

$query ="SELECT * FROM wp_users, wp_devices, wp_readings WHERE wp_users.ID='$current_user->ID'

?>

🙂

Comments are closed.