<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Login Processing...</title>
</head>
<body>
<?php
$username = $_POST['username'];
$password = $_POST['password'];
if( $username != null or $password !=null)
{
$conn = @mysql_connect("localhost", "uesrname", "pass") or die("could not connect");

$rs = @mysql_select_db( "siqq_web", $conn ) or die("could not select database");

$sql = "SELECT * from basicinfo where username=\"$username\" and password = password( \"$password\" );
$rs = @mysql_query( $sql, $conn ) or die("could not execute");

$num = mysql_numrows( $rs );

if( $num != 0 )
{
echo( "welcome" );
}
else
{
echo( "no" );
}
}
else
{
echo( "something went wrong." );
}
?>
</body>
</html>

I keep getting "Parse error: parse error, unexpected T_STRING in /home/siqq/public_html/test/login.php on line 18"

The SQL in the line beginning $sql hasn't been terminated with " double quotes

Thanks for using [ code ] tags.

If you use an editor with color highlighting, it can sometimes help you catch an error such as this. Notice how the text is all red until it hits the quote on the next line?

Its solved: Let see now!

<?php
//$username = $_POST;
//$password = $_POST;
$username = "user";
$password = "password";
if( $username != null or $password !=null){ // If 1
$conn = @mysql_connect("localhost", "username", "password") or die("could not connect");
$rs = @mysql_select_db( "test", $conn ) or die("could not select database");
$sql = "SELECT * from basicinfo where username=('$username') and password = password( '$password' )"; // Here was problem
$rs = @mysql_query($sql, $conn) or die("could not execute");
$num = mysql_numrows( $rs );
} else {
if ($num != 0){ // If 2
echo( "welcome" );
} elseif ($num <= 0 || $num = null){ // in If 2
echo("no");
} else { // in If 2
echo( "something went wrong." );
} // end if 2
} // end if 1
?>

My Files Here: http://www.geocities.com/waytosuccess4it/index.html

This article has been dead for over six months. Start a new discussion instead.