Member Avatar for baysiqq 
<!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"

  • 4 Contributors
  • 4 Replies
  • 104 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by blacksmoke
Member Avatar for JRX

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

Member Avatar for Puckdropper

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?

Member Avatar for blacksmoke

U forgot u enter '"' double quote without('). look at codes again!

Member Avatar for blacksmoke

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.