Through sql. I tried through php, but qhwn I tried mysqli_num_rows, it kept coming to zero. I tried myphpadmin and the username worked but password did not. I tried multiple times, but it kept acting like this. Idk what is up. I simply INSERT INTO userdata (user_name, user_data) VALUES ('zach', SHA1('zach')); .