Insert Data From Database With validation - Ajax
<html>
<head></head>
<body>
<h1>Registration Form</h1>
<form id="regform" action="" method="post">
<fieldset style="width:40%">
<legend>Register Here..</legend>
<span id="error"></span>
<br/>
<p>Name :<input type="text" name="name"/>
<span id="name"></span>
</p>
<p>Father Name :<input type="text" name="fname"/>
<span id="fname"></span>
</p>
<p>Mobile :<input type="text" name="mobile"/>
<span id="mobile"></span>
</p>
<p>Email:<input type="email" name="email"/>
<span id="email"></span>
</p>
<p>Password:<input type="password" name="pass"/>
<span id="pass"></span></p>
<p>Gender :Male<input type="radio" name="gender" value="male" />
Female<input type="radio" name="gender" value="fimale" />
<br/><span id="gender"></span>
</p>
<input type="submit" id="btn" name="btn"/>
</fieldset>
</form>
<script type="text/javascript" src="jquery-3.6.0.min.js"></script>
<script type="text/javascript">
$('#regform').on('submit',function(e){
$.ajax({
url:"regsubmit1.php",
type:'POST',
data:$('#regform').serialize(),
success:function(response){
if (response.code==201) {
$('#name').html(response.massage);
}
if (response.code==202) {
$('#fname').html(response.massage);
}
if (response.code==203 || response.code==204) {
$('#mobile').html(response.massage);
}
if (response.code==205) {
$('#email').html(response.massage);
}
if (response.code==206) {
$('#pass').html(response.massage);
}
if (response.code==207) {
$('#gender').html(response.massage);
}
if (response.code==200) {
$('#error').html(response.massage);
$('#regform')['0'].reset();
$('#btn').val('Submit');
$('#btn').attr('daisabled',false);
}
}
});
e.preventDefault();
});
</script>
</body>
</html>
regsubmit1.php
<?php
header("Content-Type:Application/json");
$name=isset($_POST['name'])?$_POST['name']:Null;
$fname=isset($_POST['fname'])?$_POST['fname']:Null;
$mobile=isset($_POST['mobile'])?$_POST['mobile']:Null;
$email=isset($_POST['email'])?$_POST['email']:Null;
$pass=isset($_POST['pass'])?$_POST['pass']:Null;
$gender=isset($_POST['gender'])?$_POST['gender']:Null;
if (is_null($name) or empty($name)) {
print_r(json_encode(['code'=>"201","massage"=>"Name Is Not Empty"]));
exit;
}
if (is_null($fname) or empty($fname)) {
print_r(json_encode(['code'=>"202","massage"=>"Father Name Is Not Empty"]));
exit;
}
if (is_null($mobile) or empty($mobile)) {
print_r(json_encode(['code'=>"203","massage"=>"mobile is Not empty"]));
exit;
}
if (!preg_match("/^[6-9]{1}[0-9]{9}$/",$mobile)) {
print_r(json_encode(['code'=>"204","massage"=>"mobile is Not Valid"]));
exit;
}
if (is_null($email) or empty($email)) {
print_r(json_encode(['code'=>"205","massage"=>"email is Not empty"]));
exit;
}
if (is_null($pass) or empty($pass)) {
print_r(json_encode(['code'=>"206","massage"=>"Password is Not empty"]));
exit;
}
if (is_null($gender) or empty($gender)) {
print_r(json_encode(['code'=>"207","massage"=>"gender Could Not be selected"]));
exit;
}
$con=mysqli_connect("localhost:3308","root","","ajax_db") or die("Connection Error".mysqli_connect_error($con));
$sql="Insert into user(name,father_name,mobile,email,password,gender) values('$name','$fname','$mobile','$email','$pass','$gender')";
$res=mysqli_query($con,$sql);
if ($res) {
print_r(json_encode(['code'=>"200","massage"=>"Recorcd Inserted"]));
}else{
print_r(json_encode(['code'=>"300","massage"=>"Recorcd Not Inserted"]));
}
0 Comments