help with login logic

im a beginner trying to make a small project, im using mysql for the database and pdo as the connector

ive been having difficulties trying to get this to work, if anyone wants to help please dm me