CODEWITHSUNDEEP
phpjqueryjsonajax
user9332352
user9332352

Reputation: 185

Fetching data from database using PHP and AJAX

I want to fetch data from database using PHP and Ajax, which is first encoded into JSON.

But data is not printed properly on the screen. It shows elements of four rows in single line separated by comma.

$(document).ready(function() {
  $(function()
    {
      $.ajax({
        url: 'demo2.php',
        data: "",
        dataType: 'json',
        success: function(data)
        {
          var name = data[0];
          var email = data[1];
          var msg = data[2];
          var date1 = data[3];
          $('#output').html("<div id='container'>" + name + " " + email + " " + msg + " " + date1 + "</div><br>");
        }
      });
    });
});

Upvotes: 0

Views: 88

Answers (1)

Panos Kalatzantonakis
Panos Kalatzantonakis

Reputation: 12673

Try this:

$(document).ready(function() {
  $(function()
    {
      $.ajax({
        url: 'demo2.php',
        data: "",
        dataType: 'json',
        success: function(data)
        {
          console.log(JSON.stringify(data));
          var obj = JSON.parse(data);
          // Iterate object:
          my_text=''
          $.each(obj, function(index, value) {
             console.log(value);
             my_text += value
          }); 

          // var obj = JSON.parse('{ "name":"John", "email":"[email protected]", "msg":"Hello"}');
          $('#output').html("<div id='container'>" + my_text + "</div><br>");
        }
      });
    });
});

Fiddle: https://jsfiddle.net/fks3j500/

Upvotes: 2

Related Questions