Question

154

Check whether the email textbox value exists in database

rated 0 times [ 160] [ 6] / answers: 1 / hits: 20637 / 10 Years ago, tue, december 16, 2014, 12:00:00

I want to check the value in text box is present in database and clear the box if the value exists in the database without refreshing the whole page.

HTML:

<p>Email<input type=text name=email id=email size=18 maxlength=50 required></p>

Query:

$echeck=select email from register where email='$email';

$echk=mysql_query($echeck);

$ecount=mysql_num_rows($echk);

if($ecount!=0)

{

    echo (<SCRIPT LANGUAGE='JavaScript'>

    var asign=document.getElementById(email);   //now show null value

    asign.value=;                

    </SCRIPT>);

}

If I use alert it will refresh the page.

window.alert('Email Id already exist');

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

andrewb

Add To Favorites

Follow

Total Points: 259

Total Questions: 124

Total Answers: 90

Location: Ivory Coast

Member since Sun, Mar 7, 2021

3 Years ago

andrewb questions

1 How can i access child component method in parent component using ref in Vue3?

Sun, Jun 12, 22, 00:00, 2 Years ago

1 TypeError: Cannot destructure property 'eligibleURLPatterns' of 'Yt' as it is null

Sun, May 1, 22, 00:00, 2 Years ago

1 Error [ERR_PACKAGE_PATH_NOT_EXPORTED]: No exports main defined in package.json

Sat, Oct 16, 21, 00:00, 3 Years ago

1 Is it okay to dispatch slice's action from another action in redux-toolkit?

Wed, Apr 21, 21, 00:00, 3 Years ago

1 Cannot find module axios - compatibility issue with typescript

Tue, Feb 2, 21, 00:00, 3 Years ago

View All

answered 10 Years ago lawrencem · Accepted Answer

try to implement something like this:

<script type=text/javascript>

function checkMailStatus(){

    //alert(came);

var email=$(#email).val();// value in field email

$.ajax({

    type:'post',

        url:'checkMail.php',// put your real file name 

        data:{email: email},

        success:function(msg){

        alert(msg); // your message will come here.     

        }

 });

}



</script>



  <p>Email<input type=text name=email id=email onblur=checkMailStatus()size=18 maxlength=50 required></p>

your php: checkMail.php

$echeck=select email from register where email=.$_POST['email'];

   $echk=mysql_query($echeck);

   $ecount=mysql_num_rows($echk);

  if($ecount!=0)

   {

      echo Email already exists;

   }