Can't read json elements from mysql query via ajax

Question

I need to add some geo-marker to my map. the markers are in my mysql table on altervista.org but my JavaScript says [object Object] every time i try...

here my php code:

require('connect.php');
$query = "SELECT latit, longit FROM segnalazioni";
$result = mysql_query($query);
$rows = array();
while ($row = mysql_fetch_assoc($result)){
     $rows[] = $row;
}
echo json_encode($rows);

it returns:

[{"latit":"12.34","longit":"12.34"},{"latit":"56.78","longit":"56.78"},...]

here my JavaScript:

function addMarker(mapobj) {
    $.getJSON( "http://####.altervista.org/map.php", function( data ) {
        var items = [];
        $.each( data, function( key1 , val1 ) {
            items.push( "<li id='" + key1 + "'>" + val1 + "</li>" );
                //next todo:
                //mapobj.marker([latit, longit]).addTo(map).bindPopup("hi");
            });
        $( "<ul/>", {
            "class": "my-new-list",
            html: items.join( "" )
        }).appendTo( "body" );
    });
}

and on the end of my [body] i can see only:

[object Object]
[object Object]
[object Object]
...

Please stop using mysql_* functions. These extensions have been removed in PHP 7. Learn about prepared statements for PDO and MySQLi and consider using PDO, it's really pretty easy. — Jay Blanchard
– Jay Blanchard, Commented Jul 11, 2016 at 18:21
you have an array of objects. your data is looping on the array, which means key1 is simply 0, 1, etc... and val1 is an OBJECT containing your lat/long values, not values themselves — Marc B
– Marc B, Commented Jul 11, 2016 at 18:23
I'm sorry for the deprecated functions ... unfortunately this is a project for academic purposes... — Eros Scoppiato
– Eros Scoppiato, Commented Jul 11, 2016 at 18:27

gaetanoM · Accepted Answer · 2016-07-11 18:44:49Z

1

According to jquery.each the parameters are

indexInArray , value and NOT key, value

So the code is:

$(function () {
  var data = [{"latit": "12.34", "longit": "12.34"}, {"latit": "56.78", "longit": "56.78"}];
  var items = [];
  $.each(data, function(indexInArray , value) {
    items.push( "<li id='" + indexInArray + "'>latit: " + value.latit + ' longit:' + value.longit + '  OR '+ JSON.stringify(value) + "</li>" );
    //next todo:
    //mapobj.marker([latit, longit]).addTo(map).bindPopup("hi");
  });
  $( "<ul/>", {
    "class": "my-new-list",
    html: items.join( "" )
  }).appendTo( "body" );
});

<script src="https://code.jquery.com/jquery-1.12.1.min.js"></script>

answered Jul 11, 2016 at 18:44

gaetanoM

42.1k6 gold badges45 silver badges63 bronze badges

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

Comments

Suman · Accepted Answer · 2016-07-11 18:29:15Z

1

Use this

$.each(result, function(key, value){
        $.each(value, function(key, value){
            console.log(key, value);
        });
    });

answered Jul 11, 2016 at 18:29

Suman

4015 silver badges15 bronze badges

1 Comment

Eros Scoppiato Over a year ago

ok, it's works... but... WHY? I tried to change the query in 'select latit from...' so the results were only one at a time in json... but doesn't works anyway!

Atul Jindal · Accepted Answer · 2016-07-11 18:44:01Z

1

I would also encourage to use header before sending JSON stream. It is always good to tell the content type sent in HTTP response. Use

header('Content-Type: application/json');

Before using

echo json_encode($rows);

answered Jul 11, 2016 at 18:44

Atul Jindal

9769 silver badges8 bronze badges

Collectives™ on Stack Overflow

Can't read json elements from mysql query via ajax

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related