could you please say what is wrong here the error message says syntax error on line 26
<?php
$username=$_POST['username'];
$pass=$_POST['password'];
if($username && $pass)
{
$connect=mysql_connect("localhost","root","") or die("error");
mysql_select_db("phplogin") or die("db error");
$query=mysql_query("select * from users where username='$username'");
$numrows=mysql_num_rows($query);
echo $numrows;
if($numrows!=0)
{
while($row=mysql_fetch_assoc($query))
{
$dbusername=$row['username'];
$dbpasswords=$row['password'];
}
if($username==$dbusername&& $pass==$dbpasswords)
echo "you are in";
?>
syntax error
Moderator: General Moderators
Re: syntax error
Code: Select all
if ($username && $pass)
{Code: Select all
if ($numrows != 0)
{There's also a space missing before the && here:
Code: Select all
if($username==$dbusername&& $pass==$dbpasswords)Re: syntax error
hi again , i am sorry my poor english .i think its done but this time i am getting another error messages
"Notice: Use of undefined constant dbpasswords - assumed 'dbpasswords' in C:\wamp\www\loginsession\login.php on line 19"
"Notice: Use of undefined constant dbpasswords - assumed 'dbpasswords' in C:\wamp\www\loginsession\login.php on line 19"
Re: syntax error
Probably missing a $ before a variable name.
Re: syntax error
hi celauran ,you are probably right but i couldnt find any mistakes
<html>
<form action="login.php" method="post">
Username:<input name="username" type="text"><br>
Pssword:<input name="password" type="password"><br>
<input name="submit" type="submit" value=" login">
</form>
</html>
<?php
$username=$_POST['username'];
$pass=$_POST['password'];
if($username && $pass)
{
$connect=mysql_connect("localhost","root","") or die("error");
mysql_select_db("phplogin") or die("db error");
$query=mysql_query("select * from users where username='$username'");
$numrows=mysql_num_rows($query);
echo $numrows;
while($row=mysql_fetch_assoc($query))
{
$dbusername=$row['username'];
$dbpasswords=$row['password'];
}
if($username==$dbusername&&$pass==dbpasswords)
{
echo "log in";
}
}
?>
<html>
<form action="login.php" method="post">
Username:<input name="username" type="text"><br>
Pssword:<input name="password" type="password"><br>
<input name="submit" type="submit" value=" login">
</form>
</html>
<?php
$username=$_POST['username'];
$pass=$_POST['password'];
if($username && $pass)
{
$connect=mysql_connect("localhost","root","") or die("error");
mysql_select_db("phplogin") or die("db error");
$query=mysql_query("select * from users where username='$username'");
$numrows=mysql_num_rows($query);
echo $numrows;
while($row=mysql_fetch_assoc($query))
{
$dbusername=$row['username'];
$dbpasswords=$row['password'];
}
if($username==$dbusername&&$pass==dbpasswords)
{
echo "log in";
}
}
?>
Re: syntax error
Two mistakes right here:
Corrected:
Code: Select all
if($username==$dbusername&&$pass==dbpasswords)Code: Select all
if($username == $dbusername && $pass == $dbpasswords)Re: syntax error
thank you Celauran saved me again