Getting mysql result into a jquery array

Question

I am trying to get this array as a result of mysql result.

var availableTags = [
      "ActionScript",
      "AppleScript",
      "Asp",
      "BASIC",
      "C",
      "C++",
      "Clojure",
      "COBOL",
      "ColdFusion",
      "Erlang",
      "Fortran",
      "Groovy",
      "Haskell",
      "Java",
      "JavaScript",
      "Lisp",
      "Perl",
      "PHP",
      "Python",
      "Ruby",
      "Scala",
      "Scheme"
    ];

Is it as simple as:

var availableTags [] = <php echo $result['availabletags']; ?> ;

Or should I do something else?

It depends upon what your query returns. If it is giving array of objects then you have to change your code. — Himanshu Upadhyay
– Himanshu Upadhyay, Commented Jul 19, 2017 at 10:41
What format is $result['availabletags'] in? Assuming you can create a PHP array from it, then you can do: var availableTags = <php echo json_encode($result['availabletags']); ?>; — Rory McCrossan
– Rory McCrossan, Commented Jul 19, 2017 at 10:43

Prabhu Nandan Kumar · Accepted Answer · 2017-07-19 10:47:06Z

1

You can get your result by run of following query :

while( $row = mysql_fetch_assoc( $result)){
    $new_array[] = $row; // Inside while loop
}

Let me know if you face any issue.

answered Jul 19, 2017 at 10:47

Prabhu Nandan Kumar

1,26513 silver badges22 bronze badges

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

2 Comments

J. Doe Over a year ago

I am trying to make this code work with mysql result as autocomplete options. jqueryui.com/autocomplete

J. Doe Over a year ago

What is the easiest way?

Collectives™ on Stack Overflow

Getting mysql result into a jquery array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related