- Messages
- 307
- Reaction score
- 11
- Points
- 28
- Thread Starter
- #561
Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
Check mo lang before saving to database
pwede mo rin lagyan mo xa ng button like "Check username availability" after ng textbox ng username.. tas dun mo ilagay ang code for checking username
mag tatanung lang poh sana aku sir. panu poh mag bigay nang limit para sa register.. ung pag na register na ung username or password na un ay dina pwding eregister ulit.. tnx poh
Check mo lang before saving to database
Code:
if(isset($_POST['submit'])){
$username = $_POST['username'];
$sql = mysql_query("SELECT * FROM usertable WHERE username='$username' LIMIT 1");
$count_sql = mysql_num_rows($sql);
if ($count_sql==0){
//pag hindi pa nakaregister ung username save it to database
$insert_user = mysql_query("INSERT INTO usertable(username, password, name)VALUES('$username','$password','$name')");
if(!$insert_user){
echo "Unable to save the data " .mysql_error();
}else{
echo "User has been added";
}
}else{
echo "Username is already is used";
}
}
pwede mo rin lagyan mo xa ng button like "Check username availability" after ng textbox ng username.. tas dun mo ilagay ang code for checking username
Last edited: