|
|
Posted by Damien on 12/28/05 14:49
Ok ik heb dus het volgende script gebruikt alleen krijg ik een error
melding op regel 17 wat te maken heeft met die SQL query.
<?php
session_start();
if (!isset($_POST["submit"])) // checks wheter the page is called using
the login form
{
header("Location:login.html"); // the script sends the user to the
registration page
} else {
if ($_POST["username"] == NULL || $_POST["password"] == NULL) // check
wheter both username and password are filled
{
echo "<font color=\"red\">Not all fields were filled. Please go <a
href=\"login.html\">back</a> and fill them</font>";
} else {
include("DatabaseConfig.php");
$usernameexists = mssql_query("SELECT ID FROM tblusers WHERE
username"=.$_POST["username"]."' &&
password='".$_POST["password"]."'");
if (mssql_num_rows($usernameexists) != 0)
{
$_SESSION["mywebsite_userid"] = mssql_result($usernameexists,'',"ID");
?>
<font color="red">You are successfully logged in.</font><br>
Go to the secret page: <a href="secret.php">Secret page</a>
<?php
} else {
echo "<font color=\"red\">Wrong combination username/password. <a
href=\"login.html\">Try login again</a> or <a
href=\"register.html\">register</a></font>";
}
mssql_close();
}
}
?>
De fout zit dacht ik in deze regel:
$usernameexists = mssql_query("SELECT ID FROM tblusers WHERE
username"=.$_POST["username"]."' &&
password='".$_POST["password"]."'");
Ik weet niet meer wat ik moet doen :( Deze melding krijg ik:
Parse error: syntax error, unexpected '=' in
c:\inetpub\wwwroot\login.php on line 17
Heeft iemand tips of oplossing?
Navigation:
[Reply to this message]
|