Sir, something is wrong.. I tried but could not find the solution.
Registration is working fine but username is not showing up in database and shows sign up error(No account found with that username). Please help with this issue.

And other simple problem which i am able to fix was.. in the line 42 of Register.php

Error was: Fatal error: Uncaught Error: Call to a member function close() on boolean in C:\xampp\htdocs\login\register.php:42 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\register.php on line 42

The statement $stmt->close(); is executing even if the condition is false.. it is because the statement is outside the if condition. So when i put it inside the IF condition it worked fine.

PS: I really don't know if this section is for such issues.. as i cant reach u in viber or linkedin. So I am posting this.