Databases
StackOverflow2013
Postsdbo
POajax and jquery display two different message on same div
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POajax and jquery display two different message on same div
    primarykey
    data
    text
    <p>My problem is that I have two messages:</p> <ul> <li><strong>error message</strong></li> <li><strong>success message</strong></li> </ul> <p>Here with the help of jQuery, I fetch the email field value and want to check whether email exits in the database or not.</p> <p>If exits then show success message, otherwise show error message.</p> <pre><code>$('#email').blur(function(){ var err_msg_css={"background-color":"#FDE4E1","border":"1px solid #FBD3C6","border-radius":"10px 4px 4px 10px","color":"#CB4721","font-size": "14px","float":"left","font-family":"Arial, Helvetica, sans-serif","font-size":"small","font-style":"oblique","height":"22px","margin-left":"6px","padding":"3px","width":"196px"}; var sucess_msg_css={"background-color":"#D5FFC6","border":"1px solid #C0F0B9","border-radius":"10px 4px 4px 10px","color":"#48A41C","font-size": "14px","float":"left","font-family":"Arial, Helvetica, sans-serif","font-size":"small","font-style":"oblique","height":"22px","margin-left":"6px","padding":"3px","width":"196px"}; var text = /[a-z]$/; var pattern = new RegExp(/^((([a-z]|\d|[!#\$%&amp;'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+(\.([a-z]|\d|[!#\$%&amp;'\*\+\-\/=\?\^_`{\|}~]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])+)*)|((\x22)((((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(([\x01-\x08\x0b\x0c\x0e-\x1f\x7f]|\x21|[\x23-\x5b]|[\x5d-\x7e]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(\\([\x01-\x09\x0b\x0c\x0d-\x7f]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))))*(((\x20|\x09)*(\x0d\x0a))?(\x20|\x09)+)?(\x22)))@((([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.)+(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|\.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])*([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])))\.?$/i); var email=$('#email').val(); if(!$('#email').val()){ $('#err_msg_9').html('&lt;img src="css/images/error.jpg"&gt;email field is empty').css(err_msg_css).show(); return false; }else{ if(!pattern.test(email)){ //console.log('qwerty') $('#err_msg_9').html('&lt;img src="css/images/error.jpg"&gt;email is not valid').css(err_msg_css).show(); return false; }else{ var Email=$("#email").val(); var datatype = 'email='+ Email; $.ajax ({ type: "POST", url: "ajax_centre.php", data: datatype, cache: false, success: function(html) { $("#err_msg_9").html(html); } }); //$('#err_msg_9').html('&lt;img src="css/images/success.jpg"&gt;sucessful').css(sucess_msg_css).show(); // return false; } } //$('#err_msg_1').hide(); return true; }); </code></pre> <p>PHP</p> <pre><code>if($_POST['email']) { $email=$_POST['email']; $counter=0; $sql=mysql_query("SELECT `email` FROM `form_value` WHERE `email`='$email'"); while($row = mysql_fetch_array($sql)){ if($email == $row['email']){ $counter = 1; //echo "email is already in use"; }else{ //echo "email is unique"; } } } //error message $('#err_msg_9').html('&lt;img src="css/images/error.jpg"&gt;email is not valid').css(err_msg_css).show(); //success message $('#err_msg_8').html('&lt;img src="css/images/success.jpg"&gt;sucessful').css(sucess_msg_css).show(); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPranav 웃
    1. USAnkur Saxena
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POajax and jquery display two different message on same div
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POajax and jquery display two different message on same div
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COAs an English note: it's "message", not ["massage"](http://en.wikipedia.org/wiki/Massage). :-)
      singulars
      1. POajax and jquery display two different message on same div
      1. USJames Donnelly
    2. COSo where is the problem you are facing ?
      singulars
      1. POajax and jquery display two different message on same div
      1. USAmar Banerjee
    3. COChange your `Email` to `email` and in your Ajax call, you are only adding the message, successful or not, to the same id `#err_msg_9`, you need to check what is the message first and than you decide where to put it
      singulars
      1. POajax and jquery display two different message on same div
      1. USGerep
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload