Insert unique number without refresh page in jquery ajax tutorial

HTML, PHP 0 Comments

How to insert unique number and data into Database using jquery ajax tutorial in PHP and Ajax Syntax. How to send and pass the more than one variable and value in jquery ajax PHP.  Submit Form without Refreshing Page with ajax  and Jquery in PHP.How to form submit with AJAX passing form data to PHP without page refresh and insert data in MySQL and other database using  u jquery ajax tutorial in PHP.

 

More than one variable and value pass  in jquery  ajax php.

$.post(“action.php”,{name:name,email:emailid,phoneno:phoneno},function(data){});

 

How to insert data in database without refresh page in jquery ajax tutorial

Check Insert unique number without refresh page in ajax tutorial MySQL

insert-unique-number-without
insert-unique-number-without

 

First-page name is index.php

<html>

<head>

<title>The jQuery Example</title>

<script type = “text/javascript” src = “https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js”></script>

<script type = “text/javascript” >

$(document).ready(function(){

$(“#sub”).click(function() {

var name = $(“#name”).val();

var emailid = $(“#emailid”).val();

var phoneno = $(“#phoneno”).val();

$.post(“action.php”,{name:name,email:emailid,phoneno:phoneno},function(data){

$(“#result”).html(data);

});

});

});

</script>

</head>

<body>

<div class=”container”>

<div class=”main”>

<form  method=”POST” name=”form” action=””>

<input type=”text” name=”name” value=”” id=”name”/> <br />

<input type=”text” name=”emailid” value=”” id=”emailid”/> <br />

<input type=”text” name=”phoneno” value=”” id=”phoneno”/> <br />

<input type=”button” value=”submit” name=”sub” id=”sub”/>

</form>

</div>

<div id=”result” ></div>

</div>

</body>

</html>

 

Second page name is action.php

<?php

include(‘db.php’);

$name = $_POST[‘name’];

$email = $_POST[’email’];

$phoneno = $_POST[‘phoneno’];

echo “SELECT * FROM comment where phone  = ‘$phoneno'”;

$check = mysql_query(“SELECT * FROM comment where phone  = ‘$phoneno’ “);

$checkno = mysql_num_rows($check);

//echo $checkno;

if($checkno == 1){

echo “already eexits”;

}else{

$addno =  mysql_query(“insert into comment(name,msg,phone) values (‘$name’,’$email’,’$phoneno’)”);

if($addno){

echo “enter phone number and data”;

}

}

?>

 

——————————————-

More than one variable and value pass  in jquery  ajax php.

Check Insert unique number without refresh page in ajax tutorial

Check Ajax Syntax:

$.ajax({

name:value,

name:value, … })

Example 1.

$.ajax({

url:’action.php’,

data:{name:name,email:emailid,phoneno:phoneno},

type:’POST’,

success:function(data){

$(“#result”).html(data);

}

});

 

Example 2

$(“#sub”).click(function(){

$.ajax({

url: “demo_test.txt”,

success: function(result)

{

$(“#div14”).html(result);

}});

});

 

First-page name is index.php for use ajax code used 

<html>

<head>

<title>The jQuery Example</title>

<script type = “text/javascript” src = “https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js”></script>

<script type = “text/javascript” >

//            Jquery synatx

$(document).ready(function(){

$(“#sub”).click(function() {

var name = $(“#name”).val();

var emailid = $(“#emailid”).val();

var phoneno = $(“#phoneno”).val();

 

/*$.post(“action.php”,{name:name,email:emailid,phoneno:phoneno},function(data){

$(“#result”).html(data);

});*/

$.ajax({

url:’action.php’,

data:{name:name,email:emailid,phoneno:phoneno},

type:’POST’,

success:function(data){

$(“#result”).html(data);

}

});

});

});

</script>

</head>

<body>

<div class=”container”>

<div class=”main”>

<form  method=”POST” name=”form” action=””>

<input type=”text” name=”name” value=”” id=”name”/> <br />

<input type=”text” name=”emailid” value=”” id=”emailid”/> <br />

<input type=”text” name=”phoneno” value=”” id=”phoneno”/> <br />

<input type=”button” value=”submit” name=”sub” id=”sub”/>

</form>

</div>

<div id=”result” ></div>

</div>

</body>

</html>

 

Second-page same as it used action.php and same database show in upper side

Download code script for Insert unique number without refresh page in jquery ajax tutorial

 

 


Bank PO clerk, SSC, Railway (RRB), IBPS, UPSC, IAS, RAS, SBI, 1st 2nd 3rd grade teacher,REET, TET, Rajasthan police SI, Delhi police, के महत्वपूर्ण सवाल जवाब के लिए रजिस्टर करे
आप करेंट अफेयर्स, Job, सामन्य ज्ञान ओर सभी exams संबंधित Study Material की जानकारी हैतु इस पेज को Like and Visit करे
https://www.facebook.com/myshort.Trick
and WWW.myshort.in

share..Share on Facebook0Share on Google+0Tweet about this on TwitterShare on LinkedIn0