Guest User

Untitled

a guest
Sep 14th, 2018
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.37 KB | None | 0 0
  1. ajax call to check duplicate data
  2. <!DOCTYPE html>
  3.  
  4. <html>
  5. <head><title>Register new user!</title>
  6. <script src="jquery-1.7.1.min.js"></script>
  7. </head>
  8. <body>
  9. Username:
  10. <input type="text" name="username" id="username"/><span id="user"></span><br/>
  11. Password:
  12. <input type="password" name="password" id="password"/><br/>
  13. <input type="button" value="Register" name="submit" id="submit" onclick="register_user();"/>
  14. </body>
  15. <script>
  16. function register_user()
  17. {
  18. $.ajax(
  19. {
  20. type:"POST",
  21. data:username,
  22. url:"userexists.php"
  23. })
  24. .fail(function()
  25. {
  26. $('#user').html("This user already exists");
  27. }
  28. );
  29. }
  30. </script>
  31. </html>
  32.  
  33. <?php
  34. // connection to the db
  35. define(IPHOST,"localhost");
  36. define(DBPASSWORD,"");
  37. define(DBUSER,"root");
  38. define(DATABASE,"ajaxtest");
  39. define(TABLENAME,"at");
  40.  
  41. $conn=mysql_connect(IPHOST,DBUSER,DBPASSWORD) or die(mysql_error());
  42. mysql_select_db(DATABASE) or die(mysql_error());
  43. $username=$_POST('username');
  44. $sql="SELECT username FROM ".TABLENAME." WHERE username=".$username;
  45. $query=mysql_query($sql);
  46. if(0!=mysql_numrows($query))
  47. {
  48. //
  49. }
  50. else
  51. {
  52.  
  53. }
  54. ?>
  55.  
  56. <!DOCTYPE html>
  57.  
  58. <html>
  59. <head><title>Register new user!</title>
  60. <script src="jquery-1.7.1.min.js"></script>
  61. </head>
  62. <body>
  63. Username:
  64. <input type="text" name="username" id="username"/><span id="user"></span><br/>
  65. Password:
  66. <input type="password" name="password" id="password"/><br/>
  67. <input type="button" value="Register" name="submit" id="submit" onclick="register_user();"/>
  68. </body>
  69. <script>
  70. function register_user()
  71. {
  72. $.ajax({
  73. type: "POST",
  74. data: {
  75. username: $('#username').val(),
  76. },
  77. url: "userexists.php",
  78. success: function(data)
  79. {
  80. if(data === 'USER_EXISTS')
  81. {
  82. $('#user')
  83. .css('color', 'red')
  84. .html("This user already exists!");
  85. }
  86. else if(data === 'USER_AVAILABLE')
  87. {
  88. $('#user')
  89. .css('color', 'green')
  90. .html("User available.");
  91. }
  92. }
  93. })
  94. }
  95. </script>
  96. </html>
  97.  
  98. <?php
  99. // connection to the db
  100. define(IPHOST,"localhost");
  101. define(DBPASSWORD,"");
  102. define(DBUSER,"root");
  103. define(DATABASE,"ajaxtest");
  104. define(TABLENAME,"at");
  105.  
  106. $conn=mysql_connect(IPHOST,DBUSER,DBPASSWORD) or die(mysql_error());
  107. mysql_select_db(DATABASE) or die(mysql_error());
  108.  
  109. $username = mysql_real_escape_string($_POST['username']); // $_POST is an array (not a function)
  110. // mysql_real_escape_string is to prevent sql injection
  111.  
  112. $sql = "SELECT username FROM ".TABLENAME." WHERE username='".$username."'"; // Username must enclosed in two quotations
  113.  
  114. $query = mysql_query($sql);
  115.  
  116. if(mysql_num_rows($query) == 0)
  117. {
  118. echo('USER_AVAILABLE');
  119. }
  120. else
  121. {
  122. echo('USER_EXISTS');
  123. }
  124. ?>
  125.  
  126. $("#submit").click(function()
  127. {
  128. $.ajax({
  129. type: "POST",
  130. data: "username="+$("#username").val(),
  131. url: "userexists.php"
  132. })
  133. .done(function(response){
  134. $('#user').html(response);
  135. });
  136. });
  137.  
  138. <?php
  139. // connection to the db
  140. define(IPHOST,"localhost");
  141. define(DBPASSWORD,"");
  142. define(DBUSER,"root");
  143. define(DATABASE,"ajaxtest");
  144. define(TABLENAME,"at");
  145.  
  146. $conn = mysql_connect(IPHOST,DBUSER,DBPASSWORD) or die(mysql_error());
  147. mysql_select_db(DATABASE) or die(mysql_error());
  148.  
  149. $username = mysql_real_escape_string($_POST['username']); // Stop some MySQL injections
  150.  
  151. $sql="SELECT username FROM ".TABLENAME." WHERE username='$username'";
  152. $query=mysql_query($sql);
  153. if(mysql_numrows($query) == 0)
  154. {
  155. echo 'Username is available!'
  156. }
  157. else
  158. {
  159. echo 'Sorry, username is in use.';
  160. }
  161. ?>
  162.  
  163. .done(function ( data ) {
  164. if(data == "0")
  165. alert("Your username is OK");
  166. else
  167. alert("Your username is already used");
  168. });
  169.  
  170. if(0!=mysql_numrows($query))
  171. {
  172. echo "0";
  173. }
  174. else
  175. {
  176. echo "1";
  177. }
  178.  
  179. function register_user()
  180. {
  181. $.ajax(
  182. {
  183. type:"POST",
  184. data:username,
  185. url:"userexists.php"
  186. })
  187. .done(function(_return)
  188. {
  189. if(_return)
  190. {
  191. if(_return['status']=='yes')
  192. {
  193. $('#user').html(_return['msg']);
  194. }
  195. }
  196. })
  197. .fail(function());
  198. }
  199.  
  200. if(0!=mysql_numrows($query))
  201. {
  202. $return = array('status'=>'yes',
  203. 'msg'=>"User alredy exist");
  204.  
  205. echo json_encode($return);
  206. return true;
  207. }
Add Comment
Please, Sign In to add comment