JQuery ajax post problem with PHP

Question

I have a list of records which loop from mysql table, for each record i had assigned an onclick function in order to pass the data for mysql query use to avoid page refresh whenever it was call,

<a href='javascript:void(0)' onclick='PlayMV(\"".$rows["v_type"]."\",\"".$rows["v_id"]."\");'>Play</a>

below is passing values to jquery function:

<script type="text/javascript">
function PlayMV(data1, data2){
$.post("mtv.php", { var1: "data1", var2: "data2" },
    function(data){
    $('#result').html(data);
});
}
</script>

here comes the problem, the "$('#result').html(data);" was always returned me a whole page in source code instead of held only the values, what I want is only able to post 'data1' and 'data2' and assigned into a php variable and mysql query like below:

$var1 = data1;
$var2 = data2;
$q = mysql_query("SELECT * FROM table WHERE mvtype='".$var1."' AND mvid='".$var2."'");

how to use JSON to pass those data into mysql query to retrieve the final result, can anyone help?

Thanks very much.

Brian · Accepted Answer · 2011-07-18 09:13:55Z

2

your script mtv.php will recieve them in the $_POST global.

you should be able to get the params with $_POST['var1'], $_POST['var2']

Script should be:

<script type="text/javascript">
    function PlayMV(data1, data2){
        $.post("mtv.php", { var1: data1, var2: data2 },
            function(data){
                alert("Data Loaded: " + data);
        });
    }
</script>

You had quotes round the values.

EDIT

Oh, if you want some data BACK from php, you can return XML or JSON, simply alert(data) to see what IS being returned just now.

In mtv.php, use json_encode() and echo it, this will get returned as 'data' which you can then do something liek this:

Example return JSON: {'thing': 1234}

var myObject = $.parseJSON(data);    

alert(myObject.thing);

The alert would display 1234.

edited Jul 18, 2011 at 9:13

answered Jul 18, 2011 at 9:03

Brian

8,6212 gold badges27 silver badges32 bronze badges

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

2 Comments

Stefan H Singer Over a year ago

I think he actually just set the variables to those strings for the sake of the example/test.

Brian Over a year ago

Nope... they are parameters of the function, check his Q you will see they are quoted... while his call is passing in alternative data $rows["v_type"] and $rows["v_id"].

Stefan H Singer · Accepted Answer · 2011-07-18 09:03:56Z

1

How do you retrieve the data in php? You should be able to fetch it like so:

$var1 = $_POST['var1'];
$var2 = $_POST['var2'];

answered Jul 18, 2011 at 9:03

Stefan H Singer

5,4942 gold badges27 silver badges26 bronze badges

2 Comments

kenneth conmen Over a year ago

Hi, i can retrieve the data properly assigned in php variable, this is the hardest part for me to parse into mysql query, function(data){ $('#result').html(data); } please advise me for more json sample on how to use it.

Stefan H Singer Over a year ago

Ah, your question did not exactly state that this was the issue :) Just put your results into a php array, then do a json_encode on that array and echo out the result. You can then use that result from javascript.

Collectives™ on Stack Overflow

JQuery ajax post problem with PHP

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related