access the response Json data in javascript

Question

I'm using a Json in my HTML to get data from Database but I can't access the data of returned Json here is my HTML function :

$.ajax({
    type: "POST",
    url: 'fetch.php',
    dataType: 'json',
    data: {func:"viewCert",tracking_code:tracking_code},
    success: function (data) {
        if (data!=null) {
            document.getElementById("generation_date").textContent = data.certInfo.timestamp;
        } else {
            alert("Something's Wrong! Try Later");
            window.location = "../views/failed.html";
        }
    }
});

and here is fetch.php function :

function viewCert($tracking_code) {
    $connect = connection();
     $connect->set_charset("utf8");
    $sql = "SELECT timestamp FROM certificate WHERE tracking_code=?";
    $result = $connect->prepare($sql);
    $result->bind_param("s",$tracking_code);
    $result->execute();
    $res=$result->get_result();
    while ($row=$res->fetch_object()) {
        $output[]=$row;
    }
    echo json_encode(array('certInfo' => $output));
}

Sorry for this question I'm just new in HTML and Javascript , so anyone know why timestamp won't be set in 'generation_date' element? any help will be much appreciated

Use console.log(data) after success: function (data) { and show us the result ? Also show generation_date element. — MorganFreeFarm
– MorganFreeFarm, Commented Feb 20, 2019 at 10:27
I think $output is an array, maybe you need to access with an index to the desired value ? like data.certInfo[0].timestamp — R3tep
– R3tep, Commented Feb 20, 2019 at 10:28
@MorganFreeFarm sorry where the Log prints? in inspect part of browser? — Shakib Karami
– Shakib Karami, Commented Feb 20, 2019 at 10:37

R3tep · Accepted Answer · 2019-02-20 10:34:22Z

1

In your PHP, $output seems to be an array. So in your javascript you need to access on the good index to get the data.

Try :

 document.getElementById("generation_date").textContent = data.certInfo[0].timestamp;
 ----------------------------------------------------------------------^^^

answered Feb 20, 2019 at 10:34

R3tep

12.9k10 gold badges52 silver badges77 bronze badges

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

2 Comments

R3tep Over a year ago

@ShakibKarami Like MorganFreeFarm comment, we need the content of consol.log(data) at the start of the success function to help you

Shakib Karami Over a year ago

sorry I was wrong certInfo was an array :) thanks a lot for your help

Collectives™ on Stack Overflow

access the response Json data in javascript

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related