Populate dropdown dynamically using JSON data

Question

I am having problems displaying the names of golf courses in my dropdown menu. I have a PHP script that when ran, returns the names of the courses in my database. The problem is that when I apply this to my index.html dropdown page and display it in the browser, the content is not displaying the dropdown.

<?php


    $db_host = 'localhost';
    $db_user = 'root';
    $db_pass = '';
    $db_name = '';

    $con = mysqli_connect($db_host,$db_user,$db_pass, $db_name);
    if (!$con) {
    die('Could not connect: ' . mysqli_error($con));
    }   


    $sql = "SELECT name FROM courses";

    $result = mysqli_query($con, $sql) or die("Error: ".mysqli_error($con));;

    $courses = array();

    while ($row = mysqli_fetch_array($result))
    {
        array_push($courses, $row["name"]);
    }

    echo json_encode($courses);

?>

The above code successfully generates the data from the database

$(document).ready(function () {
    $.getJSON("getCourseDD.php", success = function(data){
        var options = "";
        for(var i=0; i< data.length; i++){
            options += '<option value ="' + data[i] + '">' + '</option>';
        }
        $("#selectCourse").append(options);
    });
});

The above code is not populating the course names into the dropdown menu.

The id of my dropdown menu is selectCourse.

<form> <select id="selectCourse" </select> </form>

Thanks for any help in advance.

Please show the HTML as well

André Schild
– André Schild

2015-07-21 09:16:08 +00:00
Commented Jul 21, 2015 at 9:16 — André Schild
– André Schild, Commented Jul 21, 2015 at 9:16

Ashwin Aggarwal · Accepted Answer · 2015-07-21 09:39:08Z

1

You need to put text in options as below :

var dummyData = ['English','Spanish','French','Mandarin'];

$(document).ready(function () {
    var data = dummyData, //This data comes from the ajax callback
        courseOptions = "";

    for(var i=0; i< data.length; i++){
       courseOptions += '<option value ="' + data[i] + '">'+data[i]+'</option>';
    }

   $("#selectCourse").append(courseOptions);

});

Working Demo : jsFiddle

answered Jul 21, 2015 at 9:39

Ashwin Aggarwal

6679 silver badges21 bronze badges

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

Comments

Satpal · Accepted Answer · 2015-07-21 09:15:55Z

0

Currently you are not setting text of option also, use

options += '<option value ="' + data[i] + '">' +  data[i]  + '</option>'

instead of

options += '<option value ="' + data[i] + '">' + '</option>';

answered Jul 21, 2015 at 9:15

Satpal

134k13 gold badges168 silver badges171 bronze badges

Comments

TaoPR · Accepted Answer · 2015-07-21 09:22:24Z

0

As you're currently utilizing jQuery, you may want to go for this solution:

for(var i=0; i< data.length; i++)
{
    $("#selectCourse").append(
        $('<option>').text(data[i]).val(data[i])
    );
}

answered Jul 21, 2015 at 9:22

TaoPR

6,0783 gold badges28 silver badges38 bronze badges

Comments

Aniket Singh · Accepted Answer · 2015-07-21 09:25:51Z

0

Use .html(options); in place of .append(options); .

append() add data after tag but html() insert data between tag.

and you should also assign something between tag, like

options += '<option value ="' + data[i] + '">' +  data[i]  + '</option>'

edited Jul 21, 2015 at 9:25

answered Jul 21, 2015 at 9:18

Aniket Singh

2,6942 gold badges24 silver badges33 bronze badges

Comments

Tuhin Biswas · Accepted Answer · 2015-07-21 10:08:42Z

0

First log your data like console.log(data) and check in browser firebug console whether it outputs json string or object. If it's string you need to convert it into object using JSON.parse().

answered Jul 21, 2015 at 10:08

Tuhin Biswas

379 bronze badges

Collectives™ on Stack Overflow

Populate dropdown dynamically using JSON data

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related