11-11-2010, 18:13
witam
proszę o pomoc, jak sprawdzić czy nick jest wolny?
user.php
user.html
proszę o pomoc, jak sprawdzić czy nick jest wolny?
user.php
Kod PHP:
include 'config.php';
@mysql_connect($mysql_host, $mysql_user, $mysql_pass);
@mysql_select_db($mysql_db);
@mysql_query('SET CHARSET utf8');
$nick=$_POST['login'];
$zapytanie=mysql_query("SELECT nick FROM users WHERE nick='$nick'");
$ile=mysql_num_rows($zapytanie);
if($ile>0)
{echo '{"success":false,"error":"username_already_exists"}';}
else { echo '{"success":true}';}
user.html
Kod:
<!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=utf-8" />
<title>Rejestracja</title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="http://ajax.microsoft.com/ajax/jquery.validate/1.7/jquery.validate.min.js"></script>
<link rel="stylesheet" href="styles.css" />
<script type="text/javascript">
$(document).ready(function(){
$("#rejestracja").validate({
rules: {
login: {
required: true,
minlength: 4
},
haslo1: {
required: true,
minlength: 5
},
haslo2: {
required: true,
equalTo: "#haslo1"
},
email: {
required: true,
email: true
}
},
messages: {
login:{
required: "Proszê wpisaæ login!",
minlength: "Minimalne d³ugo¶æ to 4 znaki!"
},
haslo1:{
required: "Proszê wpisaæ has³o",
minlength: "Minimalna d³ugo¶æ to 5 znaków!"
},
haslo2:{
required: "Proszê wpisaæ has³o",
equalTo: "Has³a s± ró¿ne!"
},
email:{
required: "Wprowad¼ adres e-mail",
email: "Wprowad¼ poprawny adres e-mail"
}
},
success: function(label) {
label.html(" ").addClass("sprawdzony");
}
});
});
</script>
</head>
<body>
<form id="rejestracja" action="" method="post">
<p>
<label for="login">Login:</label>
<input type="text" name="login" id="login" />
</p>
<p>
<label for="haslo1">Has³o:</label>
<input type="password" name="haslo1" id="haslo1" />
</p>
<p>
<label for="haslo2">Powtórz has³o:</label>
<input type="password" name="haslo2" id="haslo2" />
</p>
<p>
<label for="email">Email:</label>
<input type="text" name="email" id="email" />
</p>
<p>
<input name="dodaj" class="wyslij" type="submit" value="Dodaj" />
</p>
</form>
</body>
</html>