从数据库通过AJAX获取JSON

Question

My code is not working. Can anyone tell me what's wrong with it? I don't get any result from this code. Please help.

<a href="" id="navigation-edit">EDIT MENU</a>   

$(function(){
    $("a#navigation-edit").on(("click"),function(){ 
         $.getJSON("ajax/navigation-edit.php", function(data) {
             $("#result").html(data);
        });              
    });
});

navigation-edit.php

 <?PHP

$result_NavDel = $mysqli->query("SELECT * FROM navigation_dynamic");
while($row = $result_NavDel->fetch_assoc()){
    $data[] = "<li class='animated bounce infinite'><a  href='?".$row['url']."'>".$row['menu']."</a></li>";

}

$implode='<ul class="nav navbar-nav" id="deleteNav">'`.`implode($data).'</ul>';
 echo json_encode($implode);




 ?>

Answer 1

You are making a request asking for JSON formatted response when you use $.getJSON().

However it is clear from intent of your php and callback code you only want text/html returned so just change from using $.getJSON() to using $.get() which will default to text/html

---

If you do want JSON then change to something like:

PHP

$data=array('text'=>'OK');
echo json_encode($data);

And change callback of `$.getJSON to:

$.getJSON("ajax/navigation-edit.php", function(data) {
     $("#result").html(data.text);
});