Help with register, please?

[Loz]

Would someone kindly be able to help with this register?
I've edited the config to my server/database names, made the recommended changes the index file and added the the extensions to my PHP file, I'm not really sure what else to do now since I'm pretty new to this . The version I'm using is 7.4.19.

I'd really appreciate the help, thank you!

[MentaL]

[cMu]

chane your parameters and name them, for example:
$sth = $dbh->prepare("SELECT COUNT(*) FROM tUser WHERE sUserID = :uid");
$sth->bindParam(":uid", $_POST['uid'], PDO::PARAM_INT);

change ur fetchColumn() if to:
if(!$sth->rowCount()) {

there is no need to fetch the row cause u won't use it, u just check if the user exists.