Hi
I have notest that my skript are making mysql inserts blank values before registering the user why i do not know.
the funny part is that it the skript works but some where it executes the insert value before if record....
sow if any one coulde help me locat why it skips the if code that shoulde help.
if i hade not made the mysql table UNIQUE it woulde be many enty rows....
Here is the register.php... and sorry for the code bang
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd">
<html>
<head>
<title>flameline.com</title>
<META HTTP-EQUIV="CONTENT-LANGUAGE" CONTENT="English">
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=ISO-8859-1">
<META HTTP-EQUIV="IMAGETOOLBAR" CONTENT="NO">
<META NAME="TITLE" CONTENT="flameline.com">
<META NAME="DESCRIPTION" CONTENT="description">
<META NAME="KEYWORDS" CONTENT="keyword, keyword">
<style type="text/css" media="all">
@import "/includes/global.css";
@import "/includes/position.css";
body {
margin: 15px;
padding: 0px;
}
</style>
</head>
<body bgcolor="#FFFFFF">
<?php
$username = $POST["username"];
$password = $POST["password"];
$password2 = $POST["password2"];
$email = $POST["email"];
$set = $_POST["set"];
function emailsyntax_is_valid($email) {
$to_work_out = explode("@", $email);
if (!isset($to_work_out[0])) return FALSE;
if (!isset($to_work_out[1])) return FALSE;
$pattern_local = '([0-9a-z]([-|]?[0-9a-z]+))(([-|]?).([-|]?)[0-9a-z]([-|]?[0-9a-z]+)+)([-|_]?)$';
$pattern_domain = '([0-9a-z]+([-]?[0-9a-z]+))(([-]?).([-]?)[0-9a-z]([-]?[0-9a-z]+)+)*.[a-z]{2,4}$';
$match_local = eregi($pattern_local, $to_work_out[0]);
$match_domain = eregi($pattern_domain, $to_work_out[1]);
if ($match_local && $match_domain) {
return TRUE;
}
return FALSE;
}
if ($set=="set") {
$username_control = 1;
$username2_control = 1;
$username3_control = 1;
$password_control = 1;
$password2_control = 1;
$password3_control = 1;
$password4_control = 1;
$password5_control = 1;
$email_control = 1;
$email2_control = 1;
$main_control = 1;
$main_control2 = 0;
if($username == ""){
$empty_username = "Ooops! - You forgot to enter your username.";
$username_control = 0;
$main_control = 0;
}
elseif(strlen($username) < 4){
$empty_username = "Ooops! - Your username should be at least 4 letters long.";
$username2_control = 0;
$main_control = 0;
}
elseif(strlen($username) > 20){
$empty_username = "Ooops! - Your username can't be larger than 20 letters.";
$username3_control = 0;
$main_control = 0;
}
/*
elseif (!eregi("^[a-zA-Z0-9_\-]+$",$username)
$empty_username = 'Ooops! - You are only allowed to use these tecken:.';
}
*/
elseif($password == ""){
$empty_password = "Ooops! - You forgot to enter your password.";
$password_control = 0;
$main_control = 0;
}
elseif(strlen($password) < 4){
$empty_password = "Ooops! - Your password should be at least 4 letters long.";
$password4_control = 0;
$main_control = 0;
}
elseif(strlen($password) > 20){
$empty_password = "Ooops! - Your password can't be larger than 20 letters.";
$password5_control = 0;
$main_control = 0;
}
elseif($password2 == ""){
$empty_password2 = "Ooops! - You forgot to validate your password!";
$password2_control = 0;
$main_control = 0;
}
elseif($password2 !== "" && $password2 !== $password){
$empty_password2 = "Ooops! - The passwords don't match!";
$password3_control = "0";
$main_control = 0;
}
elseif($email == ""){
$empty_email = "Ooops! - You forgot to enter your e-mail.";
$email_control = 0;
$main_control = 0;
}
elseif(!emailsyntax_is_valid($email)) {
$empty_email = " Ooops! - Incorrect e-mail format.";
$email2_control = 0;
$main_control = 0;
}
elseif($main_control = 1){
$str = $username;
$str = strtolower($str);
require ('mysqlcon.php');
$result = mysql_query("SELECT * FROM reg_info", $starta);
while ($array = mysql_fetch_array($result)) {
if($str == $array["username"]) {
$empty_username = "Ooops! - The nickname you chose allready exists!";
$main_control2 = 1;
break;
mysql_close($starta);
}
}
}
}
if($main_control2 != 1 & $main_control = 1) {
[/color]
here is the problem
require ('mysqlcon.php');
$sqlquery=mysql_query("INSERT INTO reg_info (username, password, email) VALUES ('$str', '$password','$email')");
mysql_close($starta);
}
?>
[/COLOR]
<div class="ahem"><p>This site will work and look better in a browser that supports <a href="/upgrade.html" target="_blank">web standards</a>, but it is accessible to any browser or Internet device.<br></p></div>
<div id="playground">
<div id="header">
</div>
<div id="navigation" class="row">
<div class="spacer"></div>
<span class="left"><a href="#">Home</a> > <a href="#">Register User</a></span>
<span class="right"><?php echo date("F j, Y"); ?></span>
<div class="spacer"></div>
</div>
<div id="leftArea">
<div class="boxDottedBorder">
<div class="boxSideHeader">Main controls</div>
<div class="boxSide">
<ul>
<li class="sideBar"><a href="#">Create community</a></li>
<li class="sideBar"><a href="#">Edit community</a></li>
</ul>
<br>
<ul>
<li class="sideBar"><a href="#">About Flameline</a></li>
<li class="sideBar"><a href="#">Features</a></li>
<li class="sideBar"><a href="#">FAQ</a></li>
<li class="sideBar"><a href="#">Disclaimer</a></li>
</ul>
<br>
<ul>
<li class="sideBar"><a href="#">Staff</a></li>
<li class="sideBar"><a href="#">Contact us</a></li>
</ul>
</div>
</div>
<div class="boxDottedBorder">
<div class="boxSideHeader">Log in</div>
<div class="boxSide">
<form action="#" method="post" name="login">
Username:<br>
<input class="inputSidebar" type="text" name="username"<br>
Password:<br>
<input class="inputSidebar" type="password" name="password"><br>
<input class="button" type="submit" name="submit" value="Log in">
</form>
<br>
<a href="/login/register.php">Register!</a><br>
<a href="#">Lost password?</a>
</div>
</div>
<div id="footer">
</div>
</div>
<div id="mainArea">
<div class="boxMainHeader">Register New User</div>
<div class="boxMain">
<form action="register.php" method="post" name="hej">
Username:<br>
<input type="text" name="username" size="15" class="inputSidebar" value="<?php if($username_control != 0){ echo $_POST['username'];} elseif(username2_control !=0){ echo $_POST['username'];} elseif(username3_control !=0){ echo $_POST['username'];}else{ echo ''; } ?>"> <?php echo $empty_username; ?> <br>
Password:<br>
<input type="password" name="password" size="15" class="inputSidebar" value="<?php if($password_control != 0){ echo $_POST['password'];} elseif($password4_control !=0){ echo $_POST['password'];}elseif($password5_control !=0){ echo $_POST['password'];}else{ echo ''; } ?>"> <?php echo $empty_password; ?><br>
Verify Password:<br>
<input type="password" name="password2" size="15" class="inputSidebar" value="<?php if($password2_control != 0 && $password_control != 0){ echo $_POST['password2'];} else{ echo ''; } ?>"> <?php echo $empty_password2; ?><br>
E-mail (In case you lose your password):<br>
<input type="text" name="email" size="15" class="inputSidebar" value="<?php echo $_POST['email']; ?>"><?php echo $empty_email; ?><br><br>
<input class="button" type="submit" name="submit" value="Create User"> <?php echo $_POST['username']; ?>
<input type="hidden" name="set" value="set">
</form>
<p align="right"><a href="#"><img src="/images/up.gif" width="13" height="9" border="0" alt="up"></a></p>
</div>
<div class="boxMainHeader">Disclaimer!</div>
<div class="boxMain">
What to write here is beyond my imagination...Maybe we should make the text in here..more visible? a red color or something?
<p align="right"><a href="#"><img src="/images/up.gif" width="13" height="9" border="0" alt="up"></a></p>
</div>
</div>
<div id="rightArea">
<div class="boxDottedBorder">
<div class="boxSideHeader">Communities</div>
<div class="boxSide">
<ul>
<li class="menuExpand"><a href="#">Alternative</a></li>
<li class="menuExpand"><a href="#">Developer's</a></li>
<li class="menuExpand"><a href="#">18+</a></li>
<li class="menuCollapse"><a href="#">Music</a></li>
<li class="menuItem"><a class="menuItem" href="#">Cristina Aguilera</a></li>
<li class="menuItem"><a class="menuItem" href="#">Britney Spears</a></li>
<li class="menuItem"><a class="menuItem" href="#">Bla bla</a></li>
<li class="menuItem"><a class="menuItem" href="#">Some Other</a></li>
<li class="menuExpand"><a href="#">Movies</a></li>
</ul>
</div>
</div>
</div>
</div>
</body>
</html>
[/COLOR]
