Undefined index: username

[lopis]

my php is giving me this error

Notice: Undefined index: username in C:\xampp\htdocs\login\login.php on line 23

 

 

here is the code from login.php

 

 

<?php

 

$username=$_POST['username'];

$password=$_POST['password'];

 

if($username&&$password)

{

 

    $ligacao=mysql_connect('localhost','root','') or die("Problema na ligacao ao servidor MySql");

    mysql_select_db("site")or die("Problema na ligacao ao servidor MySql");

 

   

    $query = mysql_query("SELECT * FROM login WHERE user = '$username' and password = '$password'");

   

    $numrows = mysql_num_rows($query);

   

    if($numrows!=0)

    {

      // codigo para login

     

        while($row = mysql_fetch_assoc($query))

        {

            $dbusername=$row['username'];  <---- Line 23

            $dbpassword=$row['password'];

        }

        // verificar se coicidem

       

        if($username==$dbusername&&$password==$dbpassword)

        {

            echo"Benvindo!";

        }

        else

            echo"Username ou Password erradas!";

 

    }

    else

        die("Esse utilizador nao existe!");

   

}

else

    die("Por favor insira um username e password!");

 

?>

[lopis]

Already fixed, sry for this post guys

[lopis]

But now its giving me a stupid error

 

Notice: Undefined index: user in C:\xampp\htdocs\login\login.php on line 3

 

 

 

$username=$_POST['user']; <--- Line 3

[lopis]

Ok, i already fixed that errors, but then other one appeared :s

 

Notice: Undefined index: user in C:\xampp\htdocs\login\login.php on line 33

 

 

 

<?php

 

session_start();

 

$username=$_POST['user'];

$password=$_POST['password'];

 

if($username&&$password)

{

 

    $ligacao=mysql_connect('localhost','root','') or die("Problema na ligacao ao servidor MySql");

    mysql_select_db("site")or die("Problema na ligacao ao servidor MySql");

 

   

    $query = mysql_query("SELECT * FROM login WHERE user = '$username' and password = '$password'");

   

    $numrows = mysql_num_rows($query);

   

    if($numrows!=0)

    {

      // codigo para login

     

        while($row = mysql_fetch_assoc($query))

        {

            $dbusername=$row['user'];

            $dbpassword=$row['password'];

        }

        // verificar se coicidem

       

        if($username==$dbusername&&$password==$dbpassword)

        {

            echo"Benvindo!<a href='member.php'>Click</a> aqui para ir para a sua página";

            $_SESSION['user']==$dbusername;  <--- Line 33

        }

        else

            echo"Username ou Password erradas!";

 

    }

    else

        die("Esse utilizador nao existe!");

   

}

else

    die("Por favor insira um username e password!");

 

 

 

?>

 

 

how can i fix it  help please

[dragon_sa]

if you are trying to set the SESSION['user'] to be $dbusername it should be like this

 

$_SESSION['user']=$dbusername;

[lopis]

I fixed that problem, but now its keep saying that user does not exist, and i already inserted users in my db

 

 

 

<?php

 

session_start();

 

$username=$_POST['user'];

$password=$_POST['password'];

 

if($username&&$password)

{

 

    $ligacao=mysql_connect('localhost','root','') or die("Problema na ligacao ao servidor MySql");

    mysql_select_db("site")or die("Problema na ligacao ao servidor MySql");

 

   

    $query = mysql_query("SELECT * FROM login WHERE user = '$username' and password = '$password'");

   

    $numrows = mysql_num_rows($query);

   

 

 

    if($numrows!=0)

    {

      // codigo para login

     

        while($row = mysql_fetch_assoc($query))

        {

            $dbusername=$row['user'];

            $dbpassword=$row['password'];

        }

        // verificar se coicidem

       

        if($username==$dbusername&&md5($password)==$dbpassword)

        {

            echo"Benvindo!<a href='member.php'>Click</a> aqui para ir para a sua página";

            $_SESSION['user']=$username;

        }

        else

            echo"Username ou Password erradas!";

 

    }

    else

        die("Esse utilizador nao existe!");

 

}

else

    die("Por favor insira um username e password!");

 

?>

 

 

i think the problem its comming from the num rows

[redarrow]

Dont forget, the password in the database is md5 know, so you need to post the password in md5 format.

 

 

that a clue.