Using AJAX to pass variable to PHP and retrieve those using AJAX again

Question

I want to pass values to a PHP script so i am using AJAX to pass those, and in the same function I am using another AJAX to retrieve those values.

The problem is that the second AJAX is not retrieving any value from the PHP file. Why is this? How can I store the variable passed on to the PHP script so that the second AJAX can retrieve it?

My code is as follows:

AJAX CODE:

$(document).ready(function() {    
    $("#raaagh").click(function(){    
        $.ajax({
            url: 'ajax.php', //This is the current doc
            type: "POST",
            data: ({name: 145}),
            success: function(data){
                console.log(data);
            }
        });  
        $.ajax({
            url:'ajax.php',
            data:"",
            dataType:'json',
            success:function(data1){
                var y1=data1;
                console.log(data1);
            }
        });
    });
});

PHP CODE:

<?php
$userAnswer = $_POST['name'];    
echo json_encode($userAnswer);    
?>

There is no need of second ajax, you can get data in first ajax itself. — Mahendra
– Mahendra, Commented Mar 26, 2013 at 12:32

Rohan Kumar · Accepted Answer · 2016-11-10 04:53:43Z

27

Use dataType:"json" for json data

$.ajax({
     url: 'ajax.php', //This is the current doc
     type: "POST",
     dataType:'json', // add json datatype to get json
     data: ({name: 145}),
     success: function(data){
         console.log(data);
     }
});

Read Docs http://api.jquery.com/jQuery.ajax/

Also in PHP

<?php
  $userAnswer = $_POST['name']; 
  $sql="SELECT * FROM <tablename> where color='".$userAnswer."'" ;
  $result=mysql_query($sql);
  $row=mysql_fetch_array($result);
  // for first row only and suppose table having data
  echo json_encode($row);  // pass array in json_encode  
?>

edited Nov 10, 2016 at 4:53

answered Mar 26, 2013 at 12:30

Rohan Kumar

40.7k11 gold badges81 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

jibin dcruz Over a year ago

see data is the value which i sent to the php. What if i am retrieving another value from the php based on the variable which i sent. For example i am sending value blue, and in php i am using a mysql condition select * from cars where color="blue"; how will i get the value for this using the same ajax?

Rohan Kumar Over a year ago

Check the above I have changed.

jibin dcruz Over a year ago

So you are saying that single AJAX call would even give me the json_encoded value from the database? but isn't data in AJAX the value we are passing on to the PHP script?

Rohan Kumar Over a year ago

Yes, in a single call of ajax you can get data from database.Also you can pass multiple data at once in ajax, like data:{color:'blue',name:'ABC',age:15}

Rohan Kumar Over a year ago

Suppose you are passing data:{color:'blue',name:'ABC',age:15} this data in ajax and at server side you query can be like:

$sql="SELECT * FROM <tablname> where color='".$_POST['color']."' and name='".$_POST['name']."' and age='".$_POST['age']."'";

|

Aks1357 · Accepted Answer · 2013-03-26 13:00:21Z

$(document).ready(function() {
    $("#raaagh").click(function() {
        $.ajax({
            url: 'ajax.php', //This is the current doc
            type: "POST",
            data: ({name: 145}),
            success: function(data) {
                console.log(data);
                $.ajax({
                    url:'ajax.php',
                    data: data,
                    dataType:'json',
                    success:function(data1) {
                        var y1=data1;
                        console.log(data1);
                    }
                });
            }
        });
    });
});

Use like this, first make a ajax call to get data, then your php function will return u the result which u wil get in data and pass that data to the new ajax call

user1646111 · Accepted Answer · 2013-03-26 12:32:03Z

1

No need to use second ajax function, you can get it back on success inside a function, another issue here is you don't know when the first ajax call finished, then, even if you use SESSION you may not get it within second AJAX call.

SO, I recommend using one AJAX call and get the value with success.

example: in first ajax call

    $.ajax({
        url: 'ajax.php', //This is the current doc
        type: "POST",
        data: ({name: 145}),
        success: function(data){
            console.log(data);
            alert(data);
            //or if the data is JSON
            var jdata = jQuery.parseJSON(data);
        }
    });

answered Mar 26, 2013 at 12:32

user1646111

4 Comments

jibin dcruz Over a year ago

so how to call the data from the php file? Because what i was planning to do is pass this variable so that it can be used in a mysql query to fetch data from the database. Could you help me on how to call the data back on first ajax itself? And is there any way to make the passed value to be stored in the php script so that it can keep on querying if i keep a timeout.

user1646111 Over a year ago

see the example, once you send the parameter to your PHP then work on it, and on same time, at the end, you can print the output back to the ajax...

jibin dcruz Over a year ago

see data is the value which i sent to the php. What if i am retrieving another value from the php based on the variable which i sent. For example i am sending value blue, and in php i am using a mysql condition select * from cars where color="blue"; how will i get the value for this using the same ajax?

user1646111 Over a year ago

yes, echo the output on same php file, and use the code above :)

Sam Hanley · Accepted Answer · 2015-12-10 19:44:42Z

1

In your PhP file there's going to be a variable called $_REQUEST and it contains an array with all the data send from Javascript to PhP using AJAX.

Try this: var_dump($_REQUEST); and check if you're receiving the values.

edited Dec 10, 2015 at 19:44

Sam Hanley

4,7557 gold badges39 silver badges65 bronze badges

answered Dec 10, 2015 at 18:48

Juan Martínez

512 bronze badges

Comments

Sathish Kumar D · Accepted Answer · 2015-08-12 04:38:03Z

0

you have to pass values with the single quotes

$(document).ready(function() {    
    $("#raaagh").click(function(){    
        $.ajax({
            url: 'ajax.php', //This is the current doc
            type: "POST",
            data: ({name: '145'}), //variables should be pass like this
            success: function(data){
                console.log(data);
                           }
        });  
        $.ajax({
    url:'ajax.php',
    data:"",
    dataType:'json',
    success:function(data1){
            var y1=data1;
            console.log(data1);
            }
        });

    });
});

try it it may work.......

answered Aug 12, 2015 at 4:38

Sathish Kumar D

2746 silver badges21 bronze badges

Collectives™ on Stack Overflow

Using AJAX to pass variable to PHP and retrieve those using AJAX again

5 Answers 5

7 Comments

Comments

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

7 Comments

Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related