Check Live Email address

Hello,

I have this code but it does check if the email address is already registered in the database.

The register page code is


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Live Username Check on registration form Using PHP/jQuery</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.0/jquery.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function()//When the dom is ready 
{
$("#email").change(function() 
{ //if theres a change in the email textbox

var email = $("#email").val();//Get the value in the email textbox
if(email.length > 3)//if the lenght greater than 3 characters
{
$("#availability_status").html('<img src="loader.gif" align="absmiddle">&nbsp;Checking availability...');
//Add a loading image in the span id="availability_status"

$.ajax({  //Make the Ajax Request
    type: "POST",  
    url: "ajax_check_username.php",  //file name
    data: "email="+$(this).attr("value"),  //data
    success: function(server_response){  
   
   $("#availability_status").ajaxComplete(function(event, request){ 

	if(server_response == '0')//if ajax_check_username.php return value "0"
	{ 
	$("#availability_status").html('<img src="available.png" align="absmiddle"> <font color="Green"> Available </font>  ');
	//add this image to the span with id "availability_status"
	}  
	else  if(server_response == '1')//if it returns "1"
	{  
	 $("#availability_status").html('<img src="not_available.png" align="absmiddle"> <font color="red">Not Available </font>');
	}  
   
   });
   } 
   
  }); 

}
else
{

$("#availability_status").html('<font color="#cc0000">Username too short</font>');
//if in case the username is less than or equal 3 characters only 
}



return false;
});

});
</script>
<style type="text/css">
body {
	font-family:Arial, Helvetica, sans-serif
}
#availability_status {
	font-size:11px;
	margin-left:10px;
}
input.form_element {
	width: 221px;
	background: transparent url('bg.jpg') no-repeat;
	color : #747862;
	height:20px;
	border:0;
	padding:4px 8px;
	margin-bottom:0px;
}
label {
	width: 125px;
	float: left;
	text-align: left;
	margin-right: 0.5em;
	display: block;
}
.style_form {
	margin:3px;
}
#content {
	margin-left: auto;
	margin-right: auto;
	width: 600px;
	margin-top:200px;
}
#submit_btn {
	margin-left:133px;
	height:30px;
	width: 221px;
}
</style>
</head>
<body>
<div id="content">
<a href="http://youhack.me/2010/05/04/username-availability-check-in-registration-form-using-jqueryphp/">Go Back to Tutorial </a>
  <form action="register.php" method="get">
    <div class="style_form">
      <label for="username">Username :</label>
      <input type="text" name="username" id="username" class="form_element"/>
       </div>
    <div class="style_form">
      <label for="full_name">Full Name :</label>
      <input type="text" name="full_name" id="full_name" class="form_element"/>
    </div>
    <div class="style_form">
      <label for="email">Email  :</label>
      <input type="text" name="email" id="email" class="form_element"/>
     <span id="availability_status"></span> </div>
    <div class="style_form">
      <input name="submit" type="submit" value="submit" id="submit_btn" />
    </div>
  </form>
</div>
</body>
</html>

The php code to check the code is


<?php
include('database_connection.php');
//Include The Database Connection File 

if(isset($_POST['email']))//If a username has been submitted 
{
$username = mysql_real_escape_string($_POST['email']);//Some clean up :)

$check_for_username = mysql_query("SELECT userid FROM member WHERE email='$email'");
//Query to check if username is available or not 

if(mysql_num_rows($check_for_username))
{
echo '1';//If there is a  record match in the Database - Not Available
}
else
{
echo '0';//No Record Found - Username is available 
}

}

?>

My database connection is


<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "register";
$prefix = "";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Opps some thing went wrong");
mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");

?>

Can anyone help with this code or if they have a better code that would be appreciated.

Thanks

Started: December 31, 2011 Latest Activity: September 13, 2018 PHP AJAX PHPMySQL

can you tell me what is the error exactly
December 31, 2011

No error is shown. It just does not check if email is in the database or even if email given is valid email address. I was hoping my code could be amended to check for valid email address and to check if email already exists in the database. Thanks
January 1, 2012

13 Answers

Мы предлагаем Вам классный сервис для оптимизации строительных расчетов, снижения расхода материалов, повышения точности проекта и экономии времени. Попробуйте удобные строительные калькуляторы онлайн с 3D визуализацией расчетов и чертежами. *Расчеты лестниц https://kalk.pro/stairs-wooden/, *Калькуляторы крыш https://kalk.pro/roofs/, *Расчеты фундамента https://kalk.pro/concrete-base/, *множество других.

Сделайте бизнес прибыльнее прямо сегодня!

We offer you great service to reduce material waste, improve design accuracy and cut estimating time. Increase efficiency in the field or in the office with fast, accurate solutions for Stairs, Roof, Basement calculations and much more at https://kalk.pro/. Built-in functions quickly and accurately estimate material requirements for your project and create 3D visualization!