Guest User

Untitled

a guest
Jan 22nd, 2019
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. $(document).ready(function()
  2.  
  3. {
  4.  
  5. $("#name").keyup(function()
  6.  
  7. {
  8. var name = $(this).val();
  9.  
  10. if(name.length > 3)
  11. {
  12. $("#result").html('checking...');
  13.  
  14. $.ajax({
  15.  
  16. type : 'POST',
  17. url : 'username-check.php',
  18. data : $(this).serialize(),
  19. success : function(data)
  20. {
  21. $("#result").html(data);
  22. }
  23. });
  24. return false;
  25.  
  26. }
  27. else
  28. {
  29. $("#result").html('');
  30. }
  31. });
  32.  
  33. });
  34.  
  35. <div class="form-group">
  36. <div class="row" style="margin-left:40%;">Nome: <input class="form-control" type="text" name="name" id="name" placeholder="Inserisci Nome" style="width:40%!important;margin-left:5px;height:20px;font-size:small;" required><div class="disponibile"><span id="result"></span></div></div>
  37. </div>
  38.  
  39. $host="localhost";
  40. $user="xxx";
  41. $pass="";
  42. $dbname="xxx";
  43.  
  44. $myconn = mysql_connect($host, $user, $pass) or die('Errore...');
  45. mysql_select_db($dbname, $myconn) or die('Errore...');
  46.  
  47. if($_POST)
  48. {
  49. $name = strip_tags($_POST['name']);
  50.  
  51. $stmt=$dbcon->prepare("SELECT * FROM utenti WHERE nome=:name");
  52. $stmt->execute(array(':name'=>$name));
  53. $count=$stmt->rowCount();
  54.  
  55. if($count>0)
  56. {
  57. echo "<span style='color:brown;'>Il nome è già attualmente in uso.</span>";
  58. }
  59. else
  60. {
  61. echo "<span style='color:green;'>Il nome è disponibile!
  62. </span>";
  63. }
  64. }
Add Comment
Please, Sign In to add comment