MYSQL Getting Data

I’m created a mysql like this

Table name : test

i want to add player rank in loading screen ,

eg: player name Avio (getting with steam web api $userNickname)

how can i echo avio’s rank with php ?

You shouldnt use nickname, you have to use steamid and store it rank, then in your loading screen you have to fetch the SQL data

Follow this tutorial. You can also use frameworks like Medoo

Thanks - SOLVED

Consider using PDO instead of MySQLI. A good all around ‘tutorial’ for it is here.

EDIT: I see the page provided on W3Schools also includes PDO, sorry. I’ll keep this here for informational purposes.