Hello All,
I am Simple Learn How to check email already exit. I am create code and check if
email already exit then you cannot submit and also also validation of email.
I am give the code for that you can check it and use it.
you have to create to file
1)email.php
2)check.php
in your email.php wriite this code
<script src="//code.jquery.com/jquery-1.11.3.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#myform").submit(function(){
if(!emailok)
{
alert('check your email');
return false;
}
});
$('#email').blur(function(){
alert($('#email').val());
$.ajax({
type:"post",
data:"email="+$('#email').val(),
url:"check.php",
beforeSend:function(){
$("#email_info").html("checking email...");
},
success:function(data){
if(data == "invalid"){
$("#email_info").html("check your Email");
emailok = false;
}else if(data !="0"){
$("#email_info").html("email already exit");
}else{
emailok = true;
$("#email_info").html("email ok");
}
}
});
});
});
</script>
<form id="myform" method="post">
<input type="text" id="email" name="email"/>
<input type="submit" />
</form>
<div id="email_info"></div>
second file is check.php
add this code
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db('blog',$conn);
$email = $_POST['email'];
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$sql = mysql_query('select email from email where email="'.$email.'"' );
$result = mysql_fetch_array($sql);
echo $num = mysql_num_rows($sql);
}else{
echo "invalid";
}
mysql_close($conn);
?>
table code
--
-- Table structure for table `email`
--
CREATE TABLE IF NOT EXISTS `email` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(200) NOT NULL,
`password` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `email`
--
INSERT INTO `email` (`id`, `email`, `password`) VALUES
(1, 'test@gmail.com', 'test'),
(2, 'teset@gmail.com', 'test');
I am Simple Learn How to check email already exit. I am create code and check if
email already exit then you cannot submit and also also validation of email.
I am give the code for that you can check it and use it.
you have to create to file
1)email.php
2)check.php
in your email.php wriite this code
<script src="//code.jquery.com/jquery-1.11.3.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#myform").submit(function(){
if(!emailok)
{
alert('check your email');
return false;
}
});
$('#email').blur(function(){
alert($('#email').val());
$.ajax({
type:"post",
data:"email="+$('#email').val(),
url:"check.php",
beforeSend:function(){
$("#email_info").html("checking email...");
},
success:function(data){
if(data == "invalid"){
$("#email_info").html("check your Email");
emailok = false;
}else if(data !="0"){
$("#email_info").html("email already exit");
}else{
emailok = true;
$("#email_info").html("email ok");
}
}
});
});
});
</script>
<form id="myform" method="post">
<input type="text" id="email" name="email"/>
<input type="submit" />
</form>
<div id="email_info"></div>
second file is check.php
add this code
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db('blog',$conn);
$email = $_POST['email'];
if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
$sql = mysql_query('select email from email where email="'.$email.'"' );
$result = mysql_fetch_array($sql);
echo $num = mysql_num_rows($sql);
}else{
echo "invalid";
}
mysql_close($conn);
?>
table code
--
-- Table structure for table `email`
--
CREATE TABLE IF NOT EXISTS `email` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(200) NOT NULL,
`password` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `email`
--
INSERT INTO `email` (`id`, `email`, `password`) VALUES
(1, 'test@gmail.com', 'test'),
(2, 'teset@gmail.com', 'test');
