将包含数据库的php数组传递给jquery进行操作

Question

i have a combo box in html and i wish to show data comming from database in it by manipulating it to if database result have abc/cde/etc and user put a these all will display i did this through jquery but couldnt find a dynamic way to paas values..

enter code here

 <?php
 // Connects to your Database
 $connection=mysql_connect("localhost","root","");
 $db="kukreja";
 mysql_select_db($db,$connection) or die("could not open $db");
 $sql="SELECT*FROM add_item";
 $result=mysql_query($sql,$connection) or die("could not execute sql:$sql");

 $num_result=mysql_fetch_Array($result);


 ?>



 <script type="text/javascript">
 jQuery(function($) {

 var availableTags = [
    "ActionScript",
    "AppleScript",
    "Asp",
    "BASIC",
    "C",
    "C++",
    "Clojure",
    "COBOL",
    "ColdFusion",
    "Erlang",
    "Fortran",
    "Groovy",
    "Haskell",
    "Java",
    "JavaScript",
    "Lisp",
    "Perl",
    "PHP",
    "Python",
    "Ruby",
    "Scala",
    "Scheme"
    ];
     $( "#tags" ).autocomplete({
    source: availableTags
      });

    });
     </script>

Answer 1

Use jQuery ajax . Let's check the bellow example

Example