นำข้อมูล Array ที่คั่นด้วย ,(คอมม่า) ใส่ใน Listbox เพื่อให้เลือกสีของสินค้า

<?php
	$db=new mysqli( 'localhost', 'test', 'test', 'test');
	$sql= <<<SQL
select 'red' pd_color union all
select 'green'  union all
select 'blue'  union all
select 'orange'  union all
select 'brown' 
SQL;
	$rs = $db->query($sql);
	$li='';
	while ($dbarr = $rs->fetch_assoc()){
        $comma = $li? ',' : '';
        $li .= "<li style='float: left' data-color='$dbarr[pd_color]' >$comma $dbarr[pd_color] </li>";
	}
?>
<input type="text" id="cboCategory" placeholder="---กรุณาเลือกสี--" >
<ul id=cboCateUL style="float: left; list-style: none; display: none; width: 100%"><?=$li?></ul>
<script>
$(document).ready(function(e){
   $('#cboCategory').focus( function(e){
      $('#cboCateUL').show().focus();
   });
   $('#cboCateUL').find('li').click( function(e){
      $('#cboCategory').val( $(this).attr('data-color'));
      $('#cboCateUL').hide();
   });
});
</script>

<?php
	$db=new mysqli( 'localhost', 'root', '137964285', 'bkk');
		$sql= "select pd_color from tbl_product WHERE pd_id = $pdId";

	$rs = $db->query($sql);
	$li='';
	while ($dbarr = $rs->fetch_assoc()){
        $comma = $li? ',' : '';
        $li .= "<li style='float: left' data-color='$dbarr[pd_color]' >$comma $dbarr[pd_color] </li>";
	}
?>
<input type="text" id="cboCategory" placeholder="---กรุณาเลือกสี--" >
<ul id=cboCateUL style="float: left; list-style: none; display: none; width: 100%"><?=$li?></ul>
<script>
$(document).ready(function(e){
   $('#cboCategory').focus( function(e){
      $('#cboCateUL').show().focus();
   });
   $('#cboCateUL').find('li').click( function(e){
      $('#cboCategory').val( $(this).attr('data-color'));
      $('#cboCateUL').hide();
   });
});
</script>