Associate user data according to "/profile/username" url

Question

Hello I’m a beginner in php and mysql, I’ve searched everything that is singing and I still can’t understand how to associate my user url to id. I would like to know how to associate and display user data according to your url and not logged in user, I need this data to be public.

I use wordpress and the basis of the url is: /Author/user/
I used a wp_rewrite Function to leave it like this: /profile/user/

The code works well but displays data of all usernames...

<?php

$id = $_GET['id'];

$pdo = new PDO('mysql:host=localhost;dbname=', '', '');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$consulta = $pdo->query("SELECT user_nicename FROM users WHERE id= '$id' ");
while ($exibir = $consulta->fetch(PDO::FETCH_ASSOC)) {
    
    // minha consulta
	echo "fullname: {$exibir['user_nicename']} <br/>";
}
?>

Answer 1

Hello! Being your users authors, then you can pick up the nickname by URL. This code needs to stay in the PHP file, Author.php. You find the default template on: Codex.wordpress.org/Author_templates

Use get_the_author_meta() to retrieve the author’s requested data.

$usuario = get_the_author_meta('user_nicename');

Retrieve user information for a given field, so you have the user ID. With the author nickname recovered from the URL, then use get_user_by().

Thus, you recover the user ID. Not from the logged in user, but from the author(nickname) that is in the URL

$user = get_user_by('slug',$usuario);
print_r($user->ID);

So retrieve the email:

echo $user->user_email;

Other option:

<?php
        global $wp_query;
        $curauth = $wp_query->get_queried_object();

        echo "Nome: " . $curauth->first_name . "<br />" .
             "Sobrenome: " . $curauth->last_name;   
/*   
    $curauth->aim;
    $curauth->description;
    $curauth->display_name;
    $curauth->first_name;
    $curauth->ID;
    $curauth->jabber;
    $curauth->last_name;
    $curauth->nickname;
    $curauth->user_email;
    $curauth->user_login;
    $curauth->user_nicename;
    $curauth->user_registered;
    $curauth->user_url;
    $curauth->yim;
*/