testing users logging in ----- whats wrong with my code

[worldcomingtoanend]

the code below keeps outputting "login unsuccessful" even if I enter the correct username and password.  Where am I going wrong?  Sorry I am a newbie in PHP.  Thanks for helping me.

 

<?php

$username=$_POST['username'];
$password=$_POST['password'];

if ($username && $password) {

     $db = odbc_connect("xx","xxx","xxx") or die ("xxxxx");
     
      $sql = "SELECT * FROM logintest WHERE username='$username' AND password='$password'";
      $res = odbc_exec($db, $sql);
      $row = odbc_fetch_array($res);
     
         
      if(($username && $password) == ($row['username'] && $row['password'])) {
        
        echo "login successful";
        } else {
        echo "login unsuccessful";
        }
}
   odbc_free_result($res);

odbc_close($db);

?>       

[Festy]

Change your if statement as:

 

if(($username == $row[username]) && ($password == $row[password]))

[MasterACE14]

try changing it to this...

<?php

$username = $_POST['username'];
$password = $_POST['password']; // if the password is hashed in the database then hash this input md5($_POST['password']);

if (isset(!empty($username)) && isset(!empty($password))) {

     $db = odbc_connect("xx","xxx","xxx") or die ("xxxxx");
     
      $sql = "SELECT * FROM logintest WHERE username='$username' AND password='$password'";
      $res = odbc_exec($db, $sql);
      $row = odbc_fetch_array($res);
     
         
      if($username == $row['username'] && $password == $row['password']) 
        {
        echo "login successful";
        } else {
        echo "login unsuccessful";
        }
}
   odbc_free_result($res);

odbc_close($db);

?>  

 

Regards, ACE

[worldcomingtoanend]

i hv tried the above from ACE and Festy but its still displaying the same result.

[worldcomingtoanend]

Now i have echoed my variables $res and $num_rows and I get the following output

 

login unsuccessful, Resource id #3, 0