-1

in my php I echoed

        //sql query here
        foreach($user as $values){
            echo $values['id'];
            echo $values['name'];
            echo $values['email'];
            echo $values['loc'];
        }

in my $.post

success:function(msg){
//what to put here to be able to retrieve the values?
}

and in my html

 <td id="idField"></td><td id="nameField"></td><td id="emailField"></td><td id="locField"></td>

How should be done in a right way? The output should display the specified columns from a table and should display a numbers of rows depends from the query result.

Sui Go
  • 463
  • 2
  • 12
  • 31

1 Answers1

1

PHP

echo json_encode($user);

jQuery

success:function(msg){
  $('#idField').html(msg.id);
  $('#nameField').html(msg.name;
  // etc      
}

You really should learn how to use documentation, google, SO and online help. There is thousands of tutorials, docs, help how to do it. Just make some research before you ask for help.

Get data from php array - AJAX - jQuery

Community
  • 1
  • 1
Peter
  • 16,453
  • 8
  • 51
  • 77