MYSQL Getting Data

[Avio]

I'm created a mysql like this

Table name : test

[IMG]https://image.prntscr.com/image/7zrVImmVShSmXrDC5UPFiA.png[/IMG]

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 ?

[G😹nz😻]

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

[iJohnny]

Follow [url=https://www.w3schools.com/php/php_mysql_select.asp]this[/url] tutorial. You can also use frameworks like [url=https://medoo.in/]Medoo[/url]

[Avio]

[QUOTE=gonzalolog;52620196]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[/QUOTE]

[QUOTE=iJohnny;52620472]Follow [url=https://www.w3schools.com/php/php_mysql_select.asp]this[/url] tutorial. You can also use frameworks like [url=https://medoo.in/]Medoo[/url][/QUOTE]

Thanks - SOLVED

[Alydus]

[QUOTE=Avio;52621608]Thanks - SOLVED[/QUOTE]

Consider using [URL="https://secure.php.net/manual/en/book.pdo.php"]PDO[/URL] instead of MySQLI. A good all around 'tutorial' for it is [URL="https://phpdelusions.net/pdo"]here[/URL].

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