PHP中的登录系统无法正常工作

Question

for some reason my login script in php keeps returning invalid results, I'm using PHPMYADMIN to handle the database and mysqli to connect however whenever I submit the data though a HTML form the values always return false even if the correct username and password combo is working.

<?php
$username = $_POST["username"];
$password = $_POST["password"];
$con = mysql_connect("localhost","cnathanielwcol","","login");
if(! $con){die('Connection Failed'.mysql_error());}

$result = mysqli_query("SELECT * FROM login");
$row = mysql_fetch_array($result);
var_dump($row);


if ($row["username"]==$username) {
  echo "Correct Username<br>";
} else {
  echo "Wrong Username<br>";
}


if ($row["password"]==$password) {
  echo "Correct Password<br>";
} else {
  echo "Wrong Password<br>";
}

echo "<br><br>Username Submited Via HTML: <b>" . $username . "</b>";
echo "<br>Password Submited Via HTML: <b>" . $password . "</b>";
?>

Answer 1

Change

$con = mysql_connect("localhost","cnathanielwcol","FKxIHHoWWtd4Q","login");

With

$con = mysqli_connect("localhost","cnathanielwcol","FKxIHHoWWtd4Q","login");

Your are trying to fetch the data with mysqli and your database connection is established by mysql

your full code:

$username = $_POST["username"];
$password = $_POST["password"];
$con = mysqli_connect("localhost","cnathanielwcol","","login") or die('connection is not establised'.mysqli_error($con));

$result = mysqli_query($con,"SELECT * FROM login WHERE username='$username' AND password='$password'");
$rowCheck=mysqli_num_rows($result);
if ($rowCheck>0) {
    // fetch all data
    //start session
    echo "you are logged in ";
}
else{
    echo 'username or password did not match';
}

Use hash password.your code is not safe.