PHP array to jquery select box

Question

How to pass php array value to jquery select box.

My Table

i tried like

$sql_customer = mysql_query("select * from tbl order by customer_name");
while($row_customer = mysql_fetch_array($sql_customer)){
    $customer_arr[$row_customer['id']] = $row_customer['customer_name'];
}

And pass into jquery as json encoded value

var customerarray = ;

var seloption = '';
$.each(customerarray, function (i, elem) {
    seloption += '<option value="'+customerarray[i]+'">'+customerarray[i]+'</option>'; 
});

How can i get table id in option value, now its getting customer name

Dhara Parmar · Accepted Answer · 2016-07-19 09:35:40Z

1

Just set i as option value as it contains key of an array which is cutomer id.Try:

var seloption = '';
$.each(customerarray, function (i, elem) {
    seloption += '<option value="'+i+'">'+customerarray[i]+'</option>'; 
});

answered Jul 19, 2016 at 9:35

Dhara Parmar

8,1231 gold badge19 silver badges27 bronze badges

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

Comments

feeela · Accepted Answer · 2016-07-19 09:36:02Z

0

i is the customer ID!

var seloption = '';
$.each(customerarray, function (i, elem) {
    seloption += '<option value="'
        + i + '">'
        + customerarray[i] + '</option>'; 
});

answered Jul 19, 2016 at 9:36

feeela

30k7 gold badges61 silver badges73 bronze badges

Comments

Nishant Ghodke · Accepted Answer · 2016-07-19 09:55:30Z

0

How about doing it without concatenation and quick workarounds?

$(customerarray).each(function(i, e) {
  var o = new Option(e.customer_name, e.customer_id);
  $('#select-tag').append(o);
});

answered Jul 19, 2016 at 9:55

Nishant Ghodke

9231 gold badge12 silver badges21 bronze badges

Collectives™ on Stack Overflow

PHP array to jquery select box

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related