Fill array with json response

Question

I'm trying to populate array in my validation code with distinct values from one column, and logic was that on focus on certain element I would send ajax request and populate array with JSON response. But I'm still a novice in JQuery and it seems I cant get it right, so if anyone can help.

$('input#search').on("focus", function(){

        $.ajax({
                type:"get",
                dataType: "json",
                url:"ajax_php/get_distinct_cities.php",
                    success:function(data){
                        $.each( data.city, function( i, itemData ) {
                           cities[i] = itemData;
                        });
                    }
                 });

    });

PHP:

<?php

    mysql_connect("localhost","root","");
    mysql_select_db("pickante");

    $sql = "SELECT DISTINCT city FROM uc_items";

    $result = mysql_query($sql);

    $cities = array();

    while($row = mysql_fetch_assoc($result))
    {
       $cities[] = $row;
    }

    echo json_encode($cities);
    ?>

JSON Print:

[{"city":"Belgrade"},{"city":"Novi Sad"}]

data is an array, it doesn't have a .city property. $.each(data, function(i, itemData){ cities[i] = itemData.city; });. — gen_Eric
– gen_Eric, Commented Mar 24, 2014 at 15:13

tymeJV · Accepted Answer · 2014-03-24 15:14:23Z

1

Just loop the array and push

for (var i = 0; i < data.length; i++) {
    cities.push(data[i].city);
}

answered Mar 24, 2014 at 15:14

tymeJV

105k14 gold badges165 silver badges158 bronze badges

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

Comments

Eduardo Quintana · Accepted Answer · 2014-03-24 15:20:01Z

0

As timeJV said just loop the array and add the cities to you array, here is an example of how it will be using the $.each, but the previous answer will do the work.

 $.each(data, function( i, itemData ) {
                     cities.push(itemData.city);
          });

answered Mar 24, 2014 at 15:20

Eduardo Quintana

2,3881 gold badge16 silver badges20 bronze badges

Collectives™ on Stack Overflow

Fill array with json 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