Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ajax call to check duplicate data
- <!DOCTYPE html>
- <html>
- <head><title>Register new user!</title>
- <script src="jquery-1.7.1.min.js"></script>
- </head>
- <body>
- Username:
- <input type="text" name="username" id="username"/><span id="user"></span><br/>
- Password:
- <input type="password" name="password" id="password"/><br/>
- <input type="button" value="Register" name="submit" id="submit" onclick="register_user();"/>
- </body>
- <script>
- function register_user()
- {
- $.ajax(
- {
- type:"POST",
- data:username,
- url:"userexists.php"
- })
- .fail(function()
- {
- $('#user').html("This user already exists");
- }
- );
- }
- </script>
- </html>
- <?php
- // connection to the db
- define(IPHOST,"localhost");
- define(DBPASSWORD,"");
- define(DBUSER,"root");
- define(DATABASE,"ajaxtest");
- define(TABLENAME,"at");
- $conn=mysql_connect(IPHOST,DBUSER,DBPASSWORD) or die(mysql_error());
- mysql_select_db(DATABASE) or die(mysql_error());
- $username=$_POST('username');
- $sql="SELECT username FROM ".TABLENAME." WHERE username=".$username;
- $query=mysql_query($sql);
- if(0!=mysql_numrows($query))
- {
- //
- }
- else
- {
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head><title>Register new user!</title>
- <script src="jquery-1.7.1.min.js"></script>
- </head>
- <body>
- Username:
- <input type="text" name="username" id="username"/><span id="user"></span><br/>
- Password:
- <input type="password" name="password" id="password"/><br/>
- <input type="button" value="Register" name="submit" id="submit" onclick="register_user();"/>
- </body>
- <script>
- function register_user()
- {
- $.ajax({
- type: "POST",
- data: {
- username: $('#username').val(),
- },
- url: "userexists.php",
- success: function(data)
- {
- if(data === 'USER_EXISTS')
- {
- $('#user')
- .css('color', 'red')
- .html("This user already exists!");
- }
- else if(data === 'USER_AVAILABLE')
- {
- $('#user')
- .css('color', 'green')
- .html("User available.");
- }
- }
- })
- }
- </script>
- </html>
- <?php
- // connection to the db
- define(IPHOST,"localhost");
- define(DBPASSWORD,"");
- define(DBUSER,"root");
- define(DATABASE,"ajaxtest");
- define(TABLENAME,"at");
- $conn=mysql_connect(IPHOST,DBUSER,DBPASSWORD) or die(mysql_error());
- mysql_select_db(DATABASE) or die(mysql_error());
- $username = mysql_real_escape_string($_POST['username']); // $_POST is an array (not a function)
- // mysql_real_escape_string is to prevent sql injection
- $sql = "SELECT username FROM ".TABLENAME." WHERE username='".$username."'"; // Username must enclosed in two quotations
- $query = mysql_query($sql);
- if(mysql_num_rows($query) == 0)
- {
- echo('USER_AVAILABLE');
- }
- else
- {
- echo('USER_EXISTS');
- }
- ?>
- $("#submit").click(function()
- {
- $.ajax({
- type: "POST",
- data: "username="+$("#username").val(),
- url: "userexists.php"
- })
- .done(function(response){
- $('#user').html(response);
- });
- });
- <?php
- // connection to the db
- define(IPHOST,"localhost");
- define(DBPASSWORD,"");
- define(DBUSER,"root");
- define(DATABASE,"ajaxtest");
- define(TABLENAME,"at");
- $conn = mysql_connect(IPHOST,DBUSER,DBPASSWORD) or die(mysql_error());
- mysql_select_db(DATABASE) or die(mysql_error());
- $username = mysql_real_escape_string($_POST['username']); // Stop some MySQL injections
- $sql="SELECT username FROM ".TABLENAME." WHERE username='$username'";
- $query=mysql_query($sql);
- if(mysql_numrows($query) == 0)
- {
- echo 'Username is available!'
- }
- else
- {
- echo 'Sorry, username is in use.';
- }
- ?>
- .done(function ( data ) {
- if(data == "0")
- alert("Your username is OK");
- else
- alert("Your username is already used");
- });
- if(0!=mysql_numrows($query))
- {
- echo "0";
- }
- else
- {
- echo "1";
- }
- function register_user()
- {
- $.ajax(
- {
- type:"POST",
- data:username,
- url:"userexists.php"
- })
- .done(function(_return)
- {
- if(_return)
- {
- if(_return['status']=='yes')
- {
- $('#user').html(_return['msg']);
- }
- }
- })
- .fail(function());
- }
- if(0!=mysql_numrows($query))
- {
- $return = array('status'=>'yes',
- 'msg'=>"User alredy exist");
- echo json_encode($return);
- return true;
- }
Add Comment
Please, Sign In to add comment