PHP - Simple ajax to send query to server

Question

Forgive my ignorance, but I can't figure out how to do a simple ajax request in PHP. I understand the principles of client-server communication in other languages/libraries, but PHP eludes me for some reason.

Here's what I'm trying to do:

Send a request from here, utilizing jQuery:

$(document).on('click', '#uploadAll', function() {
    $.ajax({
        url: '/ExamplePhpFile.php',
        type: "POST",
        data: {query:'INSERT INTO Assets SELECT * FROM Uploads'},
        success: function(respose){
            console.log("POST successful");
        }
    });
});

Get the query string in the data attribute here:

if(isset($_POST{'data'})) {
    $query = $_POST['data'];
    foreach($query as $value) {
        echo 'here is your crap: '.$value;
    }
}

Then I will use the passed query in another function to run an action on the server (this part works). Obviously I have something wrong, as the $_POST['data'] bit doesn't return a value. And monitoring $_POST by itself just gives me an array object (JSON_encode() doesn't do the trick on that either)

Can anyone offer me guidance, and save me some hair pulling? :)

Also it is a REALLY bad security vulnerability to send SQL statements across web requests. — Taplar
– Taplar, Commented May 24, 2018 at 17:42
I forgot them in the post, they're there in the file. I'll edit to reflect :) — Jensen010
– Jensen010, Commented May 24, 2018 at 17:43
Also your parameters will not have data as a key. It will have query as a key. $_POST['query'] — Taplar
– Taplar, Commented May 24, 2018 at 17:44
Turns out you can actually use the {} as in isset($post{'data'}) ... lol who knew. — ArtisticPhoenix
– ArtisticPhoenix, Commented May 24, 2018 at 17:48
@ArtisticPhoenix As I just pointed out, data will not be a key in the $_POST associative array — Taplar
– Taplar, Commented May 24, 2018 at 17:49

R B · Accepted Answer · 2018-05-24 17:50:34Z

1

You are passing your data key as query and using $_POST['data'] so how it will work replace like $_POST['data'] to $_POST['query'] it will work.

answered May 24, 2018 at 17:50

R B

6564 silver badges12 bronze badges

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

5 Comments

Jensen010 Over a year ago

hmmm, I tried that, and when I echo it, i get nothing :(

R B Over a year ago

Show us var_dump($_POST) output

Jensen010 Over a year ago

its empty? this confuses me

Máté Safranka Over a year ago

Try echoing file_get_contents('php://input') to see what the raw HTTP request body is. Might be some clues in there.

Jensen010 Over a year ago

That's empty too, something appears to be wrong with the client side of things?

Rick Calder · Accepted Answer · 2018-05-24 17:59:29Z

1

You need to send a valid JSON object back

if(isset($_POST['query'])) {
    $query = $_POST['query'];
    $data = [];
    $x = 0;
    foreach($query as $value) {
        $data[$x] = 'here is your crap: '.$value;
        $x++;
    }
    print(json_encode($data));
}

edited May 24, 2018 at 17:59

answered May 24, 2018 at 17:51

Rick Calder

18.8k3 gold badges27 silver badges41 bronze badges

4 Comments

Rick Calder Over a year ago

What difference do you think that makes? He clearly said he is not getting a response, it's because he's not returning a valid JSON object. Maybe read the actual question and the response before downvoting everyone? Just a thought

Rick Calder Over a year ago

He also clearly said his queries work, it's the response to the AJAX call he isn't getting.

Rick Calder Over a year ago

What part of the issue do you think it isn't addressing? He wants to know how to get a response from the server when the AJAX call is done.

Rick Calder Over a year ago

Now I see where you were going with that. Sorry, long day.

Collectives™ on Stack Overflow

PHP - Simple ajax to send query to server

2 Answers 2

5 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related