pass an array of objects from jquery to php and save to database

Question

Hi I have been trying to pass an array of objects with geolocation data from jquery to a php script to save to a database. been up all night trying to get this working so may be missing something small from lack of sleep.

the jquery objects stucture is the following

var testData = [];            

        var coords = {
        lat: 12.6544885,
        lng: 23.545665
        };

        var pos = {
         timestamp: 1222355465,
          latlng: coords
            };

            testData.push(pos);


            var coords = {
        lat: 55.6544885,
        lng: 55.545665
        };

        var pos = {
         timestamp: 555,
          latlng: coords
            };

            testData.push(pos);

I am trying to post this via .ajax using the following

$.ajax({
            type: 'POST',
            data: JSON.stringify(testData),
            //change the url for your project
            url: 'www.mydomain.com/save2.php',
            success: function(data){
                console.log(data);
                alert('Sucess');
            },
            error: function(){
                console.log(data);
                alert('Error');
            }
        });

and I am decoding at the php side and attempting to place in a database using the following.

$myData = json_decode($_REQUEST['testData']);

$sql = "INSERT INTO walk (timestamp, latitude, longitude) ";
$sql .= "VALUES ($myData->timestamp, $myData->latlng->lat, $myData->latlng->lng)";

I would appriciate any input on this issue thanks.

have you tried $myData = json_decode($_POST['testData']) ? — pulsar
– pulsar, Commented Apr 13, 2013 at 14:32
Are you not using pdo or mysqli? Why insert those variables inside sql string? Use prepared statements. — hjpotter92
– hjpotter92, Commented Apr 13, 2013 at 14:37
@AxelA.Grazx I am quote new to jquery and php most of my proggramming experiance is console based. have to do this for a uni project. Could you tell me how I can run print_r and get an output as this script does not load the php page in the browser so would have to be reutned to the jquery script somehow thanks — Chao226
– Chao226, Commented Apr 13, 2013 at 15:11

ulentini · Accepted Answer · 2013-04-13 14:36:36Z

3

In ajax options, try changing data: JSON.stringify(testData), to

data: { 'testData': JSON.stringify(testData) },

otherwise you won't have a valid query string.

answered Apr 13, 2013 at 14:36

ulentini

2,4121 gold badge15 silver badges25 bronze badges

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

2 Comments

hjpotter92 Over a year ago

Beat me to it by less than a minute.

Sam Dufel Over a year ago

or better yet, get rid of the stringify call altogether. jquery will automatically convert the object into a query string, encoding it as json is unnecessary.

Collectives™ on Stack Overflow

pass an array of objects from jquery to php and save to database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related