<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0052AC" VLINK="#0052AC" ALINK="#0052AC">
<CENTER><TABLE WIDTH="700" CELLPADDING="0" CELLSPACING="0" BGCOLOR="#FFFFFF">
<TR><TD>
<TABLE WIDTH="100%" CELLPADDING="2" CELLSPACING="0" BGCOLOR="#000000"><TR BGCOLOR="#000000"><TD BGCOLOR="#000000">
<TABLE WIDTH="100%" CELLPADDING="1" CELLSPACING="0" BGCOLOR="#FFFFFF">
<TR BGCOLOR="#FFFFFF"><TD BGCOLOR="#FFFFFF">
<TABLE WIDTH="100%" CELLPADDING="4" CELLSPACING="1">
<TR>
<TD BGCOLOR="#F7F7F7">
<FONT FACE="Verdana, Arial, Tahoma" SIZE="2" COLOR="#000000">
<B>Web Turns</B><BR>
</FONT><FONT FACE="Verdana, Arial, Tahoma" SIZE="1" COLOR="#000000">
</FONT>
</TD>
</TR>
<TR>
<TD BGCOLOR="#DDDDDD">
<FONT FACE="Verdana, Arial, Tahoma" SIZE="1" COLOR="#000000">
</FONT>
</TD>
</TR>
</TABLE>
</TD></TR>
</TABLE>
</TD></TR>
</TABLE>
<BR>
</FONT>
<BR><BR>
<TABLE WIDTH="100%" CELLPADDING="2" CELLSPACING="0" BGCOLOR="#000000"><TR BGCOLOR="#000000"><TD BGCOLOR="#000000">
<TABLE WIDTH="100%" CELLPADDING="1" CELLSPACING="0" BGCOLOR="#FFFFFF">
<TR BGCOLOR="#FFFFFF"><TD BGCOLOR="#FFFFFF">
<TABLE WIDTH="100%" CELLPADDING="4" CELLSPACING="1">
<TR>
<TD BGCOLOR="#DDDDDD">
<FONT FACE="Verdana, Arial, Tahoma" SIZE="2" COLOR="#000000">
<B>Turn Login</B>
</FONT><BR>
<FONT FACE="Verdana, Arial, Tahoma" SIZE="1" COLOR="#000000">
Please enter your username and password.
</FONT>
</TD>
</TR>
<TR>
<TD BGCOLOR="#F7F7F7">
<FONT FACE="Verdana, Arial, Tahoma" SIZE="2" COLOR="#000000">
<FORM METHOD="POST" ACTION="<?=$PHP_SELF?>">
<TABLE BORDER="0" CELLPADDING="3" CELLSPACING="0">
<TR><TD ALIGN="RIGHT">
<FONT FACE="Verdana, Arial, Tahoma" SIZE="2" COLOR="#000000">
<B>User Name:</B>
</FONT>
</TD><TD>
<INPUT TYPE="TEXT" NAME="username" SIZE="25">
</TD></TR>
<TR><TD ALIGN="RIGHT">
<FONT FACE="Verdana, Arial, Tahoma" SIZE="2" COLOR="#000000">
<B>Password:</B>
</FONT>
</TD><TD>
<INPUT TYPE="PASSWORD" NAME="password" SIZE="25">
</TD></TR>
<TR><TD ALIGN="RIGHT">
<FONT FACE="Verdana, Arial, Tahoma" SIZE="2" COLOR="#000000">
</FONT>
</TD><TD>
<INPUT TYPE="SUBMIT" name=login VALUE="Login">
<INPUT TYPE="RESET" VALUE="Reset">
</TD></TR>
</FORM></TABLE>
<?
if ($login) {
require("config.php");
mysql_select_db($DB_NAME);
$loginquery = mysql_query("SELECT * FROM user WHERE username = '".$username."' AND password = '".$password."'");
// was it correct?
$exist = mysql_num_rows($loginquery);
while ($v = mysql_fetch_array($loginquery)) {
$uname = $v[0];
$pwd = $v[1];
$uid = $v[2];
$admin = $v[3];
$fn = $v[4];
$ln = $v[5];
$email = $v[6];
if($exist > 0) {
setcookie("usid", "$uid");
setcookie("admin", "$admin");
setcookie("user", "$uname");
setcookie("pass", "$pwd");
setcookie("first", "$fn");
setcookie("last", "$ln");
setcookie("email", "$email");
echo "<META http-equiv=\"refresh\" content=\"1; URL=today.php\">";
}
}
}
?>
There is the login page code, which fails if I run it with the cookie code. If it is removed, it works without a problem.