get array from ajax json with javascript

Question

I have this code which should convert it's results to json. I want to get the array with js and print it.

$db = new PDO('mysql:host=localhost;dbname=Contact', 'root', '');
$statement=$db->prepare("SELECT * FROM myfeilds");
$statement->execute();
$results=$statement->fetchAll(PDO::FETCH_ASSOC);
$json=json_encode($results);

How can I do this ?

$(document).ready(function() {
    $.ajax({
        type : 'POST',
        url : 'server.php',
        success : //........
    }); 
});

Possible duplicate of How to pass an array using PHP & Ajax to Javascript? — Farzher
– Farzher, Commented Feb 14, 2017 at 8:50

JYoThI · Accepted Answer · 2017-02-14 09:29:21Z

3

You have to echo the something in server side to return the ajax

PHP:

    $db = new PDO('mysql:host=localhost;dbname=Contact', 'root', '');
    $statement=$db->prepare("SELECT * FROM myfeilds");
    $statement->execute();
    $results=$statement->fetchAll(PDO::FETCH_ASSOC);
    $json=json_encode($results);
     echo $json;

    ?>

Ajax :

$(document).ready(function() {
      $.ajax({
        type : 'POST',
        url : 'server.php',
        dataType:"json",
        success : function (data) {

            alert(JSON.stringify(data));
           }
        }
      }); 
    });

edited Feb 14, 2017 at 9:29

answered Feb 14, 2017 at 9:07

JYoThI

12.1k1 gold badge13 silver badges26 bronze badges

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

2 Comments

Toprex Over a year ago

thanks ...How can I print it on the table or div ? This means that for each variable in a special section can print

JYoThI Over a year ago

take look at here stackoverflow.com/questions/4189365/… @Toprex

Morgs · Accepted Answer · 2017-02-14 08:58:20Z

Ok so you seem to have got enough downvotes but I am also guessing you're fairly new so here's my little help:

PHP:

$db = new PDO('mysql:host=localhost;dbname=Contact', 'root', '');
$statement=$db->prepare("SELECT * FROM myfeilds");
$statement->execute();
$results=$statement->fetchAll(PDO::FETCH_ASSOC);
$json=json_encode($results);

return $json; // Return this back to your browser
?>

Javascript / jQuery:

$(document).ready(function() {
  $.ajax({
    type : 'POST',
    url : 'server.php',
    dataType:"json",
    success : function (data) {
       for ( var d in data ) {
          var column1 = data[d].column1;
       }
    }
  }); 
});

You might want to have a look at the documentation on ajax...

Collectives™ on Stack Overflow

get array from ajax json with javascript

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related