How to pull Php Json values as dropdown with Jquery?

Question

I am doing a Autocomplete function using php with jquery.On Entering first letter in alert box it is displaying values correctly.I need to get the values as dropdownlist.

My coding is:

<html>
<head>
<script>
$(document).ready(function(){
    $("#localty").keyup(function(){
        var localty = $("#localty").val();
        $.ajax({
            type : "POST",
            url: "getlist.php",
            dataType : "json",
            data : "localty="+localty,
            success: function(result){
                alert(result);
            }
        });
    });
});
</script>
</head>
<body>
<input type="text" id="localty">
<input type="submit" name="submit" value="Submit">
</body>
</html>

getlist.php page:

    <?php
    $localty = $_REQUEST['localty'];


    $con = mysqli_connect('localhost','root','','details');
    if (!$con) 
    {
    die('Could not connect: ' . mysqli_error($con));
     }
     mysqli_select_db($con,"details");
     ?>

    <?php
    $sql="SELECT localty FROM localty WHERE localty like '$localty%'";
    $result = mysqli_query($con,$sql);
    while($row = mysqli_fetch_array($result))
    {
        $row_set[] = $row['localty'];
    }
    echo json_encode($row_set);
    mysqli_close($con);
    ?>

Please give any Suggestions.

Ahmad Samilo · Accepted Answer · 2015-03-02 09:20:06Z

1

Your code have to be like this:

Your HTML

<select id="myselect">
</select>

The javascript(Using jQuery)

var json={} // Populate this json object
$.each(json, function(key, value){
    $('#myselect').append("<option value='"+key+"'>"+value+"</option>");
});

answered Mar 2, 2015 at 9:20

Ahmad Samilo

91416 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

How to pull Php Json values as dropdown with Jquery?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related