<?php $username = $_POST['username']; $password = $_POST['password']; if ($username&&$password) { $connect = mysql_connect("sql-4.zerver.","bakugan609","s026y8pjtl"); mysql_select_db("bakugan609"); $query = mysql_query("SELECT * FROM members WHERE username='$username'") $naumrows = mysql_num_rows($query); if ($numrows!=0) { while ($row = mysql_fetch_assoc($query)) { $dbusername = $row['username']; $dbpassword = $row['password']; } if ($username&&$dbusername&&$password&&$dbpassword) { } else echo "Неверный пароль!"; } else die ("Несуществует такого пользователя!"); echo $numrows } else { echo die ("Неверный логин или пароль!"); } ?>

If you look in the source code, nothing is written there! Writes that the file is not found!

  • 3
    The question is similar: Here I have a code, everything seems to be correct .. .... code ... So, why doesn’t my refrigerator turn on? - Alex Kapustin

2 answers 2

After $query = mysql_query("SELECT * FROM members WHERE username='$username' LIMIT 1") $naumrows = mysql_num_rows($query) do not forget to put ";" , and then write this:

 if (mysql_num_rows>0){ $row = mysql_fetch_assoc($query)) if ($password == $row['password']){ //Тут код успешного входа } else { echo "Неверный пароль"; } } else { echo "Нет такого пользователя"; }
  • And do not forget to add LIMIT 1 to the request - DemoS

Why don't you take advantage

 WHERE login='$login' AND password='$password'

How to go through the whole base?