Fetching data from database using PHP and AJAX

Question

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>");
        }
      });
    });
});

Please share data which you want to print and format to print — ram singh
– ram singh, Commented Feb 9, 2018 at 9:23
"four rows in single line" - How does that work? Either you get four rows or a single line — user8034901
– user8034901, Commented Feb 9, 2018 at 9:29

Panos Kalatzantonakis · Accepted Answer · 2018-02-09 09:57:17Z

2

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/

edited Feb 9, 2018 at 9:57

answered Feb 9, 2018 at 9:29

Panos Kalatzantonakis

12.7k8 gold badges68 silver badges86 bronze badges

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

7 Comments

Panos Kalatzantonakis Over a year ago

Provide additional info! Give json data, console output. Also make sure your output is in JSON format

user9332352 Over a year ago

[["fahad","[email protected]","hello!","2018-02-13"],["chris","[email protected]","hello","2018-02-04"],["robert","[email protected]","hi there","2018-02-06"]]

Panos Kalatzantonakis Over a year ago

Your array does not have keys thats why, print(obj[1][1])

user9332352 Over a year ago

How to get keys for each values?

user9332352 Over a year ago

is there any way to make it associative array?

|

Collectives™ on Stack Overflow

Fetching data from database using PHP and AJAX

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related