showing php jsonencode array result into ajax success function

Question

I am trying to show result of my php code to ajax file with jquery but I don't know how to do it. Final array [{"UPDATE_TIME":"2016-11-28 06:51:51"}]

I want to show this result through ajax jquery.

<?php
header('Access-Control-Allow-Origin: *');

include_once "dbconfig.php";

$sql = "SELECT UPDATE_TIME
FROM   information_schema.tables
WHERE  TABLE_SCHEMA = 'vizteyl7_tarining'
   AND TABLE_NAME = 'news'";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        $output[] = $row;
    }

    echo json_encode($output);
} else {
    echo "0 results";
}
$conn->close();
?>

 <label>Enter TimeStamp (last updated date: <span id="lastTs"></span>)</label>

    $(document).ready(function(){
              setTs();
      })

  function setTs(){

  $.ajax({
        type: "GET",
        url:"http://example.com/stshow.php",
        dataType: "json",
        success: function(data) {
            $('#lastTs').text(data[0]);

}
});
}

Nikhil Vaghela · Accepted Answer · 2016-11-28 09:30:45Z

1

Try this...

$('#lastTs').text(data[0].UPDATE_TIME);

answered Nov 28, 2016 at 9:30

Nikhil Vaghela

2,0942 gold badges18 silver badges30 bronze badges

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

6 Comments

Sagar Gopale Over a year ago

error showing for $(document).ready(function(){ setTs(); }) its saying $ is not defined but nothing showing for main ajax,its showing blank screen,no output

Nikhil Vaghela Over a year ago

Have you call jquery.min.js ?

Sagar Gopale Over a year ago

no ,its imp to call jquery.min.js? i have added noe google cdn <script src="ajax.googleapis.com/ajax/libs/jquery/3.1.1/…> above script tag $ defined error now gone bt output not coming

Nikhil Vaghela Over a year ago

Yes it is...without js you can not use jquery..See below link... w3schools.com/jquery/tryit.asp?filename=tryjquery_hide

Sagar Gopale Over a year ago

yes i did same not no error in code but output still not coming

|

Collectives™ on Stack Overflow

showing php jsonencode array result into ajax success function

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related