here is a rewritten version of your full script.
I have added some suggestions from other posters
and some of my own.
I can not promise it will work without a few corrections,
but I think it can be worth trying.
some changes:
<?php
// debug setting, remove later
error_reporting(2047);
$error_message = ""; // will display if submitted data was not correct
// makes sure they filled it in
$uname = trim($_POST['username']); // put POST into some variables
$passw = trim($_POST['pass']); // trim eventual spaces
//$email = trim($_POST['email']);// disabled as form has no email submit
// will set action go back here
?>
<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">
<?php // if is an error, display in red below form
if (isset($error_message)){
echo '<span style="color:red">';
echo $error_message;
echo '</span>';
}
?>
Here is script:
<?php
// Connects to your Database
mysql_connect("localhost", "spaodesi_admin", "greybeau") or die(mysql_error());
mysql_select_db("spaodesi_clients") or die(mysql_error());
// Checks if there is a login cookie
if(isset($_COOKIE['ID_my_site'])){ // if there is, it logs you in and directes you to the members page
$username = $_COOKIE['ID_my_site'];
$pass = $_COOKIE['Key_my_site'];
$check = mysql_query("SELECT * FROM users WHERE username = '$username'")or die(mysql_error());
while($info = mysql_fetch_array($check)){
if ($pass == $info['password']){
header("Location: client.php");
exit;
}
}
}
// debug setting, remove later
error_reporting(2047);
// if the login form is submitted
if (isset($_POST['submit'])){ // if form has been submitted
$error_message = "";
// makes sure they filled it in
$uname = trim($_POST['username']);
$passw = trim($_POST['pass']);
//email = trim($_POST['email']);
if(empty($uname) || empty($passw)){
$error_message = 'Please fill in all the fields.';
}else{
// checks it against the database
//if (!get_magic_quotes_gpc()){
// $email = addslashes($email);
//}
$check = mysql_query("SELECT * FROM users WHERE username = '" . $uname . "'")or die(mysql_error());
// Gives error if user dosen't exist
$check2 = mysql_num_rows($check);
if ($check2 == 0){
$error_message = 'That user does not exist in our database.';
}else{
while($info = mysql_fetch_array($check)){
$passw = stripslashes($passw);
$info['password'] = stripslashes($info['password']);
$passw = md5($passw);
// gives error if the password is wrong
if ($passw != $info['password']){
$error_message = 'Incorrect password, please try again.';
}else{
// if login is ok then we add a cookie
$uname = stripslashes($uname);
$hour = time() + 3600;
setcookie(ID_my_site, $uname, $hour);
setcookie(Key_my_site, $passw, $hour);
// then redirect them to the members area
header("Location: members.php");
exit;
}
}
}
}
}else{
// if they are not logged in
?>
<!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>Untitled Document</title>
<style type="text/css">
<!--
#background {
position:absolute;
left:0px;
top:0px;
width:854px;
height:640px;
z-index:0;
background-image: url(images/background.jpg);
}
#clientform {
position:absolute;
left:691px;
top:534px;
width:117px;
height:95px;
z-index:2;
}
#navbg {
position:absolute;
left:607px;
top:199px;
width:228px;
height:440px;
z-index:1;
background-image: url(images/nav_bg.png);
}
#navigation {
position:absolute;
left:613px;
top:198px;
width:217px;
height:301px;
z-index:3;
}
body {
background-image: url(images/canvas.jpg);
}
-->
</style>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
</head>
<body>
<div id="background" onload="MM_preloadImages('login/images/background.jpg')"></div>
<div id="clientform">
<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">
<table width="120" border="0" cellspacing="8" cellpadding="0">
<tr>
<td><label>
<input name="username" type="text" id="username" size="15" />
</label></td>
</tr>
<tr>
<td><label>
<input name="pass" type="password" id="pass" size="15" />
</label></td>
</tr>
<tr align=right>
<td><label>
<input type="submit" name="Submit" value="Login" />
</label></td>
</tr>
</table>
</form>
<?php
if (isset($error_message)){
echo '<span style="color:red">';
echo $error_message;
echo '</span>';
}
?>
</div>
<div id="navbg"></div>
<div id="navigation">
<script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0','width','217','height','301','src','flash/home nav','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','wmode','transparent','movie','flash/home nav' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="217" height="301">
<param name="movie" value="flash/home nav.swf" />
<param name="quality" value="high" />
<param name="wmode" value="transparent" />
<embed src="flash/home nav.swf" width="217" height="301" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" wmode="transparent"></embed>
</object>
</noscript></div>
</body>
</html>
<?php
}
?>