Check Username ซ้ำ แต่มีปัญหาค่ะ ไม่ได้สักที ไม่ว่าจะใส่ username อันไหน ก็บอกว่าซ้ำหมดเลยทั้งๆที่ไม่ซ้ำค่ะ T^T
Code (PHP) <?php
session_start() ;
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$date = $_POST['date'];
$month = $_POST['month'];
$year = $_POST['year'];
$gender = $_POST['gender'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$postcode = $_POST['postcode'];
$phone = $_POST['phone'];
$username = $_POST['username'];
$pwd1 = $_POST['pwd1'];
$pwd2 = $_POST['pwd2'];
$email = $_POST['email'];
$Submit = $_POST['Submit'];
$ok = $_POST['ok'];
?>
<html>
<head>
<title>
</title>
</head>
<body>
<?php
include("./config.inc.php");
//check is there is correct input
if($firstname=="" || $lastname=="" || $phone=="" || $username=="" ||
$pwd1=="" || $email=="") {
echo "<meta http-equiv='refresh' content='0; url=memberRegister.php'>" ;
}
if((isset($ok)) and ($ok!="ok_pass")) {
echo "<meta http-equiv='refresh' content='0; url=memberRegister.php'>" ;
}
$signup = date("j/n/").(date("Y")) ;
$sql = "select username from memberlist where username='$username'" ;
$query = mysql_query($sql);
$num=mysql_num_rows($query);
if($num > 0){
echo "<br><br><center><font size='3' face='MS Sans Serif'>Same please
change" ;
echo "<br><br><input type='button' value='back to edit'
onclick='history.back();'></center></body></html>" ;
exit() ;
}
else{
$result = mysql_query("insert into memberlist
(id,firstname,lastname,date,month,year,gender,address,city,state,postcode,phone,username,pwd1,pwd2,email,signup)
values('','$firstname','$lastname','$date','$month','$year','$gender','$address','$city','$state','$postcode','$phone','$username','$pwd1',
'$pwd2','$email','$signup')");
$online_order = "../orderonline.html";
$register = "./memberRegister.php";
if($result) {
$_SESSION[login] = "true";
echo "<script type=\"text/javascript\">\n";
echo "alert('You are now The Member of Our Restuarant !');\n";
echo "window.location = ('$online_order');\n";
echo "</script>";
}
else
{
echo "<script type=\"text/javascript\">\n";
echo "alert('Could not add any infomation to the database !');\n";
echo "window.location = ('$register');\n";
echo "</script>";
}
}
?>
</body>
</html>
Tag PHP, MySQL
Date :
2011-09-07 12:11:17By :
annView :
931Reply :
6
Code (PHP) <?php
session_start() ;
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$date = $_POST['date'];
$month = $_POST['month'];
$year = $_POST['year'];
$gender = $_POST['gender'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$postcode = $_POST['postcode'];
$phone = $_POST['phone'];
$username = $_POST['username'];
$pwd1 = $_POST['pwd1'];
$pwd2 = $_POST['pwd2'];
$email = $_POST['email'];
$Submit = $_POST['Submit'];
$ok = $_POST['ok'];
?>
<html>
<head>
<title>
</title>
</head>
<body>
<?php
include("./config.inc.php");
//check is there is correct input
if($firstname=="" || $lastname=="" || $phone=="" || $username=="" ||
$pwd1=="" || $email=="") {
echo "<meta http-equiv='refresh' content='0; url=memberRegister.php'>" ;
}
if((isset($ok)) and ($ok!="ok_pass")) {
echo "<meta http-equiv='refresh' content='0; url=memberRegister.php'>" ;
}
$signup = date("j/n/").(date("Y")) ;
$sql = "select username from memberlist where username='$username'" ;
$query = mysql_query($sql);
$num=mysql_num_rows($query);
if($num > 0){
echo "<br><br><center><font size='3' face='MS Sans Serif'>Same please
change" ;
echo "<br><br><input type='button' value='back to edit'
onclick='history.back();'></center></body></html>" ;
exit() ;
}
else{
$result = mysql_query("insert into memberlist
(id,firstname,lastname,date,month,year,gender,address,city,state,postcode,phone,username,pwd1,pwd2,email,signup)
values('','$firstname','$lastname','$date','$month','$year','$gender','$address','$city','$state','$postcode','$phone','$username','$pwd1',
'$pwd2','$email','$signup')");
$online_order = "../orderonline.html";
$register = "./memberRegister.php";
if($result) {
$_SESSION[login] = "true";
echo "<script type=\"text/javascript\">\n";
echo "alert('You are now The Member of Our Restuarant !');\n";
echo "window.location = ('$online_order');\n";
echo "</script>";
}
else
{
echo "<script type=\"text/javascript\">\n";
echo "alert('Could not add any infomation to the database !');\n";
echo "window.location = ('$register');\n";
echo "</script>";
}
}
?>
</body>
</html>
Date :
2011-09-07 12:25:20By :
ppanchai
แหะๆๆ ขอบคุณมากนะคะ
Date :
2011-09-07 12:28:33By :
ann
Code (PHP) $sql = "select username from memberlist where username='$username'" ;
Code (PHP) $sql = "select count(username) as num from memberlist where username='".$username."';";
//แล้วลอง Fetch array (num) ออกมาดูครับ
Code (PHP) onclick='history.back();'></center></body></html>" ;
ประวัติการแก้ไข
Date :
2011-09-07 12:31:20By :
ppanchai
คุณต้อง กรุณ
Date :
2011-09-07 12:37:13By :
ann
^^ ได้แล้วค่ะ
Date :
2011-09-07 12:54:28By :
ann
Server 03
Load balance : Server 03
