How to search user login to search data in database?

Question

Good evening, everyone, I am using this command line, it worked perfectly with me typing the login of the person, but when I try to put to go based on the 'user_login' (logged in user) it does not go to page or even load when I try, I tried to use up to this here:

$current_user = wp_get_current_user();

$user_info = get_userdata($current_user->ID);

$username = $user_info->user_login;

But it didn’t work, could you help me? follows the page code:

?php

$host = "xxxx";
$db   = "xxx";
$user = "zzz";
$pass = "sddss";

$con = mysqli_pconnect($host, $user, $pass) or trigger_error(mysqli_error(),E_USER_ERROR); 

mysqli_select_db($db, $con);

$query = sprintf("SELECT valor FROM investimentos WHERE login= 'mirthrandir' ");

$dados = mysqli_query($query, $con) or die(mysqli_error());

$linha = mysqli_fetch_assoc($dados);

$total = mysqli_num_rows($dados);

?>


    
    Teste


?php
    // se o número de resultados for maior que zero, mostra os dados
    if($total > 0) {
        // inicia o loop que vai mostrar todos os dados
        do {
?>
            
?=$linha['valor']?> /
?php
        // finaliza o loop que vai mostrar os dados
        }while($linha = mysqli_fetch_assoc($dados));
    // fim do if 
    }
?>