$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
After I connect to my database server, I check user credential for valid user
//query database for user
$sql = "SELECT * FROM users";
$result = $conn->query($sql);
$row = $result->fetch_assoc()
Here the error comes, I use if else statement to check, but i get an error
if($row['username'] == $username && $row['password'] == $password){
echo "Login Success !! Welcome ".$row['username'];
} else{
echo "Failed to login";
}