Populate dropdown with JSON data using jquery & ajax

Question

I was able to succesfully get data from database in json format from controller, this is how it looks:

{
    "dealer":[
        ["1","himanshu"],
        ["2","bhola the dealer"],
        ["3","bhola the dealer"]
    ]
}

the problem is that I am not able to pass json data into the dropdown list in view from the controller.

Model Code:

 public function getName(){

     $this->db->select('dealerid,dealername');
    $query=$this->db->get('Dealer');
    $result=$query->result_array();
    //echo "<pre>";
    return $result;

    }

Controller Code:

  public function dealer_list()
{
    $list = $this->person->getName();
    $ddata = array();

    foreach ($list as $person) {

        $row = array();

        $row[] = $person['dealerid'];
        $row[] = $person['dealername'];
        $ddata[] = $row;
    }

    $output = array(

        "dealer" => $ddata,
            );
    //output to json format


   echo json_encode($output);

}

View Code:

                   //get a reference to the select element
                        $select = $('#select');
                        //request the JSON data and parse into the select element
                        $.ajax({
                            url: "<?php echo site_url('dealer_controller/dealer_list')?>"
                            , dataType: 'JSON'
                            , success: function (data) {
                                //clear the current content of the select
                                $select.html('');
                                //iterate over the data and append a select option
                                $.each(data.dealer, function (key, val) {
                                    $select.append('<option id="' + val.id + '">' + val.name + '</option>');
                                })
                            }
                            , error: function () { <strong>
                                //if there is an error append a 'none available' option
                                $select.html('<option id="-1">none available</option>');
                            }
                        });

ImClarky · Accepted Answer · 2016-03-15 11:53:58Z

1

Your json output doesn't have the keys id or name for each dealer. Therefore val.id and val.name won't work.

In your Controller change:

$row[] = $person['dealerid'];
$row[] = $person['dealername'];

to:

$row["id"] = $person['dealerid'];
$row["name"] = $person['dealername'];

This adds the keys id and name to the php array, and when converted to json should output something like the following:

{"dealer":[{"id": "1", "name": "himanshu"}, {...}]}

These can then be retrieved in your $.each with val.id and val.name

edited Mar 15, 2016 at 11:53

answered Mar 15, 2016 at 11:09

ImClarky

1,9632 gold badges27 silver badges31 bronze badges

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

2 Comments

Himanshu Over a year ago

still not getting anything into dropdown :(

Himanshu Over a year ago

it worked thanks man :) you saved my life ... previously i changed my view code a bit now its working perfectly:)

Mir Gulam Sarwar · Accepted Answer · 2016-03-15 11:12:21Z

0

Fiddle

 $.each(data.dealer, function (index, item) {
        $select.append(
            $('<option>', {
                value: item[0],
                text: item[1]
            }, '</option>'))
          }
         )
    })

answered Mar 15, 2016 at 11:12

Mir Gulam Sarwar

2,6482 gold badges27 silver badges39 bronze badges

Collectives™ on Stack Overflow

Populate dropdown with JSON data using jquery & ajax

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related