Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • send data into php using javascript and ajax

    @nasyia
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 1
    • 0
    • 0
    • 0
    • 793
    Answer it

    i need to send data into my database using ajax but i don't need to send duplicate data so how can i return false if the username or email already exist in my database or prevent submit also i need to prevent submit if the password fields are not matching 
    and direct after submit using ajax 

    sorry if you see any sloppy coding i'm still new to programming !!!

    1. <script type="text/javascript" src="functions.js"></script>
    2. <script type="text/javascript" src="jquery-1.12.3.min.js"></script>
    3. <?php require("connection.php"); ?>
    4. <?php
    5.  
    6. /*///////////////////////////////////
    7. ********
    8. ********
    9. ******** check username if it's exist in your Database
    10. ********
    11. ********
    12. *////////////////////////////////////
    13.  
    14. if(isset($_POST["check_name"]) && $_POST["check_name"] != ""){
    15.     $username = preg_replace('#[^a-z0-9]#i', '', $_POST['check_name']); 
    16.     $sql_uname_check = mysqli_query($link,"SELECT `examinee_id` FROM `examinee` WHERE `user_name`='$username' LIMIT 1"); 
    17.     $uname_check = mysqli_num_rows($sql_uname_check);
    18.     if (strlen($username) < 4) {
    19.         echo '4 - 15 characters please';
    20.         exit();
    21.     }
    22.     if (is_numeric($username[0])) {
    23.         echo 'First character must be a letter';
    24.         exit();
    25.     }
    26.     if ($uname_check < 1) {
    27.         echo '<strong>' . $username . '</strong> is OK';
    28.         exit();
    29.     } else {
    30.         echo '<strong>' . $username . '</strong> is taken';
    31.         exit();
    32.     }
    33. }
    34.  
    35. /*///////////////////////////////////
    36. ********
    37. ********
    38. ******** check E-mail if it's exist in your Database
    39. ********
    40. ********
    41. *////////////////////////////////////
    42.  
    43. if(isset($_POST["email_check"]) && $_POST["email_check"] != ""){
    44.     $email =  ($_POST['email_check']);/*preg_replace('#[^a-z0-9]#i', '',*/ 
    45.     $sql_uname_check = mysqli_query($link,"SELECT `examinee_id` FROM `examinee` WHERE `E-mail`='".$email."' LIMIT 1"); 
    46.     $uname_check = mysqli_num_rows($sql_uname_check);
    47.     if(!preg_match("^[a-zA-Z0-9_\.\-]+@[a-zA-Z0-9\-]+\.[a-zA-Z0-9\-\.]+$^",$email)){
    48.         echo 'invalid email format';
    49.        exit();
    50.     }
    51.     
    52.     if ($uname_check < 1) {
    53.         echo '<strong>' .  $email . '</strong> is OK';
    54.         exit();
    55.     } else {
    56.         echo '<strong>' . $email . '</strong> is taken';
    57.         exit();
    58.     }
    59. }
    60. /*///////////////////////////////////
    61. ********
    62. ********
    63. ******** Define variables
    64. ********
    65. ********
    66. *////////////////////////////////////
    67.  
    68. if( isset($user_name)&& isset($email) && isset(    $password  ) ){
    69.     
    70.     $user_name  =mysqli_real_escape_string($link,stripslashes($_POST['user_name'])) ;
    71.     $email = mysqli_real_escape_string($link,stripslashes($_POST['email']));
    72.     $password  = $_POST['password'];}  else{$password= "";
    73.     $confirmpassword = $_POST['confirmpassword']; 
    74.  
    75.     date_default_timezone_set('US/Eastern');
    76.     $currtime = time();
    77.     $date = date('Y-m-d', $currtime);
    78.     $salty = dechex($currtime).$password;
    79.     $salted = hash('sha1', $salty);
    80.  
    81.     $query = mysqli_query($link,"INSERT INTO `examinee`(`examinee_id`, `user_name`, `E-mail`, `password`, `date_of_registration`) 
    82.                                                    VALUES
    83.     (NULL,'".$user_name."','".$email."','".$salted."','".$date."' ) ") or die (mysqli_error($link));
    84.        
    85.      if($query){
    86.             
    87.             header("location:http://localhost/online_test/index.php");
    88.             echo "    <br>";
    89.     }
    90.         
    91.     else{
    92.             
    93.             echo "Error! <br>";
    94.     }
    95.  
    96.  }
    97. ?>

     

    1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    2. "http://www.w3.org/TR/html4/loose.dtd">
    3. <html xmlns="http://www.w3.org/1999/xhtml" dir="RTL" lang="Ar">
    4. <head>
    5. <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    6.  
    7. <link href="xxx.css" media="screen" rel="stylesheet" type="text/css" />
    8.  
    9. <meta name="viewport" content="width=device-width, initial-scale=1.0">
    10.  
    11.  
    12. <title></title>
    13.  
    14. <style>
    15.  
    16. #passwordStrength
    17. {
    18.     height:10px;
    19.     display:block;
    20.     float:right;
    21. }
    22.  
    23. .strength0
    24. {
    25.     *width:250px;
    26.     *background:#cccccc;
    27. }
    28.  
    29. .strength1
    30. {
    31.     width:50px;
    32.     background:#ff0000;
    33. }
    34.  
    35. .strength2
    36. {
    37.     width:100px;    
    38.     background:#ff5f5f;
    39. }
    40.  
    41. .strength3
    42. {
    43.     width:150px;
    44.     background:#56e500;
    45. }
    46.  
    47. .strength4
    48. {
    49.     background:#4dcd00;
    50.     width:200px;
    51. }
    52.  
    53. .strength5
    54. {
    55.     background:#399800;
    56.     width:250px;
    57. }
    58.  
    59. .error{
    60.     padding-left: 40px;
    61.     border:1px solid ;
    62. }
    63. </style>
    64. </head>
    65. <?php   require("processes.php");   ?>
    66. <body> 
    67.     <div class="continar">
    68.   <div><span id="error_message"></span></div>
    69.         <div  class="login">
    70.             <form method="post" action="" id="myform" >
    71.     
    72.                 <p>
    73.  
    74.                      <label> </label>
    75.      
    76.                      <input type="text" name="user_name" id="user_name" onBlur="checkusername()" maxlength="15">
    77.                      
    78.                      <span id="usernamestatus" class="error"></span>
    79.                      
    80.                 </p>
    81.     
    82.     
    83.                 <p>
    84.  
    85.                      <label> </label>
    86.      
    87.                      <input type="text" name="email" id="email" onBlur="check_Email()" maxlength="50">
    88.                      
    89.                      <span id="Emailstatus" class="error"></span>
    90.  
    91.                 </p>
    92.     
    93.     
    94.                 <p>
    95.  
    96.                 
    97.                       <label for="pass"> </label>
    98.                      
    99.                      <input type="password" name="password" id="mypassword" onkeyup="passwordStrength(this.value)"/>
    100.                        <label for="passwordStrength" class="error"></label>
    101.                         <div id="passwordDescription" class="error"></div>
    102.             
    103.                      <div id="passwordStrength" class="strength0" class="error"></div>
    104.              
    105.                 </p>
    106.                 
    107.                 
    108.                 
    109.                 <p>    
    110.                  
    111.                  
    112.                      <label>  </label>
    113.             
    114.                      <input type="password" name="passwordconfirm" id="passwordconfirm" onkeyup="mypasswordconfirm(); return false;">
    115.                      
    116.                      <span id="confirmMessage" class="error"></span>
    117.                      
    118.                 </p>
    119.                 
    120.  
    121.                 <p>
    122.      
    123.                      <input type="submit"  name="submit"  id="mysubmit"/>
    124.                        <span id="mysubmit_error" class="error"></span>
    125.                      
    126.                 </p>
    127.     
    128.             </form>
    129.         </div>    
    130.     </div>
    131.     <script src="script.js"></script>
    132.  
    133. </body>
    134. <html>
    1. // Check username if it's exist
    2. function checkusername(){
    3.     var status = document.getElementById("usernamestatus");
    4.     var username = document.getElementById("user_name").value;
    5.     if(username  != ""){
    6.         status.innerHTML = 'checking...';
    7.         var hr = new XMLHttpRequest();
    8.         hr.open("POST", "processes.php", true);
    9.         hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    10.         hr.onreadystatechange = function() {
    11.             if(hr.readyState == 4 && hr.status == 200) {
    12.                 status.innerHTML = hr.responseText;
    13.             }
    14.         }
    15.         var v = "check_name="+username ;
    16.         hr.send(v);
    17.     }
    18. }
    19.  
    20. // Check user email if it's exist
    21. function check_Email(){
    22.     var status = document.getElementById("Emailstatus");
    23.     var Email = document.getElementById("email").value;
    24.     if(Email != ""){
    25.         status.innerHTML = 'checking...';
    26.         var hr = new XMLHttpRequest();
    27.         hr.open("POST", "processes.php", true);
    28.         hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    29.         hr.onreadystatechange = function() {
    30.             if(hr.readyState == 4 && hr.status == 200) {
    31.                 status.innerHTML = hr.responseText;
    32.             }
    33.         }
    34.         var v = "email_check="+Email;
    35.         hr.send(v);
    36.     }
    37. }
    38.  
    39. // check password strength 
    40. function passwordStrength(mypassword){
    41.     
    42.     // var mypassword = document.getElementById("password");
    43.      
    44.     var desc = new Array();
    45.     desc[0] = "Very Weak";
    46.     desc[1] = "Weak";
    47.     desc[2] = "Better";
    48.     desc[3] = "Medium";
    49.     desc[4] = "Strong";
    50.     desc[5] = "Strongest";
    51.  
    52.     var score   = 0;
    53.  
    54.     //if password bigger than 6 give 1 point
    55.     if (mypassword.length > 6) score++;
    56.  
    57.     //if password has both lower and uppercase characters give 1 point    
    58.     if ( ( mypassword.match(/[a-z]/) ) && ( mypassword.match(/[A-Z]/) ) ) score++;
    59.  
    60.     //if password has at least one number give 1 point
    61.     if (mypassword.match(/\d+/)) score++;
    62.  
    63.     //if password has at least one special caracther give 1 point
    64.     if ( mypassword.match(/.[!,@,#,$,%,^,&,*,?,_,~,-,(,)]/) )    score++;
    65.  
    66.     //if password bigger than 12 give another 1 point
    67.     if (mypassword.length > 12) score++;
    68.  
    69.      document.getElementById("passwordDescription").innerHTML = desc[score];
    70.      document.getElementById("passwordStrength").className = "strength" + score;
    71.   
    72. }
    73.  
    74. // check password matching 
    75.     
    76.     function mypasswordconfirm(){  
    77.         
    78.         var mypassword = document.getElementById("mypassword");
    79.         var mypasswordconfirm = document.getElementById("passwordconfirm");
    80.         var message = document.getElementById("confirmMessage");
    81.        
    82.         
    83.         if(mypassword .value == mypasswordconfirm.value){
    84.             
    85.             message.innerHTML = "password matching";
    86.         }
    87.         else{
    88.           
    89.             message.innerHTML = "password do not match";
    90.             
    91.         }
    92.     }
    93.     
    94. // check empty fields
    95.  
    96. function  prepareEventHandlers(){
    97.       document.getElementById("myform").onsubmit = function(){
    98.       
    99.     var myusername        = document.getElementById("user_name");
    100.     var myemail           = document.getElementById("email");    
    101.     var myemailconfirm    = document.getElementById("emailconfirm");
    102.     var mypassword        = document.getElementById("password");
    103.     var mypasswordconfirm = document.getElementById("passwordconfirm");
    104.     var myerrormessage    = document.getElementById("error_message");
    105.     
    106.     if(myusername.value == "" || myemail.value == "" || myemailconfirm .value == "" || mypassword.value == "" || mypasswordconfirm.value == "" ){
    107.         myerrormessage.innerHTML = "   ";
    108.         return false ;
    109.     }
    110.     else{
    111.         document.getElementById("mysubmit").style.display = "none";    
    112.         document.getElementById("mysubmit_error").innerHTML = "please wait..........";
    113.         var request = new XMLHttpRequest ();
    114.         var url = "processes.php";
    115.         var variables = myusername+myemail+mypassword  ; 
    116.         request.open("POST",url,true) ;
    117.         request.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    118.         request.onreadystatechange = function(){
    119.             if(request.readyState == 4 && request.responseText == 200){
    120.                 var return_data = request.responseText ;
    121.                 document.getElementById("").innerHTML = return_data ;
    122.             }
    123.         }
    124.         
    125.         request.send(variables);
    126.     }
    127.     };
    128. }
    129. window.onload = function(){
    130.      prepareEventHandlers();
    131. }
    132.  

     

    php Javascript ajax
    Answer it

 1 Answer(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: