PHP dropdown populated by database to be use javascript

Question

I have this php code that get items from the database and i have to use this drop-down in my JavaScript code to duplicate the same drop-down when a button is clicked

function dup(){  
     }

 <?php 
  include('view/connect.php');

  $sql="SELECT ss_code FROM ss WHERE sn_id = 1";

  $result =mysql_query($sql);
  $dropdown = "<select name='users'>";

  while($row = mysql_fetch_assoc($result)) {
     $b = $row['ss_code'];
     $dropdown .= "\r\n<option value='{$b}'>{$b}</option>";

  }

  $dropdown .= "\r\n</select>";

  echo $dropdown;

 ?>

Ignacio Vazquez-Abrams · Accepted Answer · 2012-09-07 05:42:30Z

1

Put all your items in an array and then set a JavaScript variable to the value returned by encoding it as JSON.

var iarray = <?php echo json_encode($items); ?>;

Then iterate over the resultant array and create the pulldown from that.

answered Sep 7, 2012 at 5:42

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

Comments

techie_28 · Accepted Answer · 2012-09-07 05:44:00Z

0

What do you mean same drop down?If you want same dropdown without any change on a button click you can use jQuery .clone().

answered Sep 7, 2012 at 5:44

techie_28

2,1454 gold badges44 silver badges65 bronze badges

Collectives™ on Stack Overflow

PHP dropdown populated by database to be use javascript

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