Nash Nash - 3 months ago 16
Javascript Question

Unable to read key value pair of Json_encode in javascript

I am having issues with reading Json_encode response in a java script.

The PHP file reads values from database and sends the results as Json_encode array to html.

<?php
include("connect.php");
try {

$conn = new PDO("mysql:host=$servername;dbname=mydb", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "Call print_awb (@output1,@output2,:input_awb_ref_id)";
if (isset($_POST)) {
$p_in_awb_ref_id =reset($_POST["var_p_in_awb_ref_id"]);
}
$stmt = $conn->prepare($sql);
$stmt->bindParam(':input_awb_ref_id',$p_in_awb_ref_id, PDO::PARAM_INT);
$stmt->execute();
$out_awb_ref_id = $conn->query("SELECT @output1")->fetch(PDO::FETCH_ASSOC);
$out_agent_id = $conn->query("SELECT @output2")->fetch(PDO::FETCH_ASSOC);

$output = array(
"out_awb_ref_id" => $out_awb_ref_id,
"out_agent_id" => $out_agent_id,
);
echo json_encode($output);
$stmt->closeCursor();
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
?>


The HTML CODE



<script type="text/javascript">

function get_parameters(){

var quote = ABCD1234;
quote.toString();
window.alert(quote);
$.ajax({
type: "POST",
url: "printawb.php",
data: {var_p_in_awb_ref_id:quote},
dataType: "text",
success: function (result) {

alert(result);
var a = result.out_awb_ref_id;
alert (a);
alert(result['out_awb_ref_id']);
alert(result['out_agent_id'])
},
error:function (jqXHR, status, err){
//Fail
layer_1.html(html);
}

});
return vars;

};
</script>


The response I have is




HVP000062

{"out_awb_ref_id":{"@output1":"MIR"},"out_agent_id":{"@output2":"rtPreston"}}
undefined
undefined


All Need is the values in the 2nd line of the result ie. "MIR" and "rtPreston"

I have tried couple of things:
1. changed the calling function type as 'JSON' but the response was 'Object' without values
2. Tried converting to jsonString
3. tried reading values using JSON.parse(jsonString);
4. result['out_ref_awb_id']

None of them work. Can someone help me how I can get values of these? I can then use them to populate on a html page.

Many thanks

Answer

Add this as a first line in the HEAD section of your HTML template

<meta content="text/html;charset=utf-8" http-equiv="Content-Type">
<meta content="utf-8" http-equiv="encoding">

Then try this code:

<script type="text/javascript">

    function get_parameters(){

        var quote = ABCD1234;
        quote.toString();
        window.alert(quote);
        $.ajax({
            type:  "POST",
            url: "printawb.php",
            data: {var_p_in_awb_ref_id:quote},
            dataType: "text",
            success: function (result) {

                var data = jQuery.parseJSON(result);
                var param1 = data.out_agent_id;
                var param2 = data.out_awb_ref_id;
                alert(param1["@output2"]);
                alert(param2["@output1"])
            },
            error:function (jqXHR, status, err){
                //Fail
                layer_1.html(html);
            }
        });
        return vars;

    };
</script>
Comments