Passing variable from .js to PHP and then receiving a new var back in response?

Question

I'm creating variables on server 1 and then sending them via post to a mySQL database on server 2 using PHP file located on server 2.

Javascript on server 1...

$.post( "http://www.website.com/xxx/update.php", { vote:currentVote, page:currentmatch, round:roundNumber, team1: firstTeam, team2: secondTeam });

PHP to receive post, located on server 2...

$round = $_POST['round'];
//etc...

//I then set the query and insert the data, no problem.

After that, and on the same PHP file, counting rows and assigning total to variable...

$result = $connection->query("SELECT * FROM {$page} WHERE 'vote' = {$team1}")) {
    $team1Count = $result->num_rows;
}

How can I send that updated $team1Count variable back to the original page?

Thanks!

Whoa there, you're escaping $page and $team1, right? php.net/manual/en/security.database.sql-injection.php — jjm
– jjm, Commented Mar 12, 2014 at 2:41

Ohgodwhy · Accepted Answer · 2014-03-12 02:47:45Z

2

jQuery's .post() has a call back feature you can supply as an argument.

$.post( "http://www.website.com/xxx/update.php", { 
    vote:currentVote, 
    page:currentmatch, 
    round:roundNumber, 
    team1: firstTeam, 
    team2: secondTeam }, 
    function(data){
        //the call back, data contains your return from your php script
        console.log(data);
});

Just simply echo that variable from your php script

echo $team1Count;

edited Mar 12, 2014 at 2:47

answered Mar 12, 2014 at 2:39

Ohgodwhy

50.8k11 gold badges86 silver badges114 bronze badges

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

Comments

Abhishek Prakash · Accepted Answer · 2014-03-12 02:43:42Z

0

Try to echo the updated variable from the php. Something like this -

$result = $connection->query("SELECT * FROM {$page} WHERE 'vote' = {$team1}")) {
    $team1Count = $result->num_rows;
    echo $team1Count;
}

answered Mar 12, 2014 at 2:43

Abhishek Prakash

9642 gold badges10 silver badges24 bronze badges

Collectives™ on Stack Overflow

Passing variable from .js to PHP and then receiving a new var back in response?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related