我的mysql登录代码有什么问题？ [关闭]

Question

could you please help me? The problem is that everytime (also when I type in the right username and password combination) the error message "Failed 2" appears.

<?php
  if (isset($_POST["login-submit"])) {
    if(!empty($_POST["username"]) && !empty($_POST["password"])) {
      $username = $_POST["username"];
      $password = $_POST["password"];
      $username = mysql_set_charset($username);
      $password = mysql_set_charset($password);
      $username = stripcslashes($username);
      $password = stripcslashes($password);
      $username = mysql_real_escape_string($username);
      $password = mysql_real_escape_string($password);
      $result = mysql_query("select * from user where username = '$username' and password = '$password'");
      $row = mysql_fetch_array($result);
      if($row["username"] == $username && $row["password"] == $password) {
        //header("Location: index.php");
        echo "<p>Login</p>";
      } else {
        echo "<p>Failed 2</p>";
      }
    } else {
      echo "<p>Failed 1</p>";
    }
  }
?>

Answer 1

Thanks for your helpful answers. Especially mysql_set_charset caused the problem and I changed to mysqli. Now the code works. Here it is:

<?php
  if (isset($_POST["login-submit"])) {
    if(!empty($_POST["username"]) && !empty($_POST["password"])) {
      $username = $_POST["username"];
      $password = $_POST["password"];
      $username = stripcslashes($username);
      $password = stripcslashes($password);
      $username = mysqli_real_escape_string($db, $username);
      $password = mysqli_real_escape_string($db, $password);
      $login = "select * from user where username = '$username' and password = '$password'";
      $result = mysqli_query($db, $login);
      $count = mysqli_num_rows($result);
      if ($count == 1) {
        //header("Location: index.php");
        echo "<p>Login</p>";
      } else {
        echo "<p>Failed 2</p>";
      }
    } else {
      echo "<p>Failed 1</p>";
    }
  }
?>