Sending JSON to PHP using ajax, troubles with data

Question

my javascript won't go into my Database.php file. Anyone knows what's wrong?

I know there is another thread with this question but it just doesn't work for me.

I have this in javascript

   var Score = 5;

//Score insert
        var postData = 
    {
        "Score":Score
    }
                $.ajax({
                          type: "POST",
                          dataType: "json",
                          url: "Database.php",
                          data: {myData:postData},                    
                          success: function(data){
                                alert('Items added');
                          },
                          error: function(e){
                                console.log(e.message);
                          }
                });

and this in php

   function InsertScore(){  
    $table = "topscores";

    if(isset($_POST['myData'])){
     $obj = json_encode($_POST['myData']);

     $stmt = $conn->prepare("INSERT INTO " + $table + " VALUES (?)");
     $stmt->bind_param('s', $obj);
     $stmt->execute();
    }
    else{
        console.log("neen");
        }

    $result->close();

Markus Kottländer · Accepted Answer · 2013-12-02 20:43:12Z

5

change this line

success: function InsertScore(data){

to this

success: function(data){

the success parameter of jquerys ajax method has to be a anonymous function (without a name) or one defined in javascript but definitely not a php function.

answered Dec 2, 2013 at 20:43

Markus Kottländer

8,2844 gold badges42 silver badges61 bronze badges

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

6 Comments

Markus Kottländer Over a year ago

thanks, nontheless your answer and the one from @leemos are also important... :)

Markus Kottländer Over a year ago

I dont know if the e parameter has a message property, read the section for the error parameter in the jquery doc and try this: error: function(data, e){ console.log(e); } (sry for editing that often ^^)

Markus Kottländer Over a year ago

What happens when your Database.php only contains a var_dump($_POST); ? I suspect that there is still this InsertScore function in your php which does not get executed. Remember: the success: function(... part of your javascript has nothing to do with what is going on in your php file. It is just a javascript function which is executed at clientside when the server (Database.php) returns a 200 Ok Header.

user2827958 Over a year ago

I just tried the var_dump but it doesn't show up into the console. So the problem must be in the ajax statement. The Database.php is in the same folder as the js file.

Markus Kottländer Over a year ago

Then try the full url to your Database.php url: "http://yourdomain.com/and/path/to/Database.php",... Something with your paths could be wrong.

|

jeroen · Accepted Answer · 2013-12-02 20:38:54Z

3

You should read up on variable scope, your $table variable is not defined in the scope of your function.

You also have an sql injection problem and should switch to prepared statements with bound variables.

answered Dec 2, 2013 at 20:38

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

4 Comments

user2827958 Over a year ago

Thanks for your response. I updated the statement with prepared. However, My javascript file doesn't connect with my php file.

jeroen Over a year ago

@user2827958 Use the absolute path like how you would call it from the browser minus the url, so something like /Database.php.

user2827958 Over a year ago

$.post('Database.php', Score, function(response) { alert(response); I have this now and it returns my the Database.php literally. So with <?php ...?> but it has to process the php

jeroen Over a year ago

@user2827958 Can you run php files at all?

Community · Accepted Answer · 2023-11-21 15:10:29Z

You are trying to send an object to your PHP file instead of a JSON data type. Try 2 use JSON2 to stringify your object like this :

var scoreINT = 9000;
var usernameSTRING = "testJSON"

var scoreOBJ = {score:scoreINT,username:usernameSTRING};
var jsonData = JSON.stringify(scoreOBJ);

this would give you the following result "{"score":9000,"username":"testJSON"}"

You would be able to send this with your AJAX if you change ( if you follow my variable names ofcourse )

data: {myData:postData}

to

data: {myData:jsonData}

This would already succesfully transfer your data to your PHP file.

regarding your error messages and undefined. the message "e.message" does not exist. so thats the "undefined" you are getting. no worries here.

I noticed the succes and error are called incorrectly. I've just deleted them because there is no need to.

Next. moving up to your PHP.

you would rather like to "DECODE" then to encode your encoded JSON. you could use the following there :

$score = json_decode($_POST['json'],true);

the extra param true is so you are getting your data into an array ( link ) or you could leave the true so you are working with an object like you already are.

Greetings ySomic

Collectives™ on Stack Overflow

Sending JSON to PHP using ajax, troubles with data

3 Answers 3

6 Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related