Friday, October 13, 2017

JSON HTML

JSON HTML

JSON can be easily translated into JavaScript. JavaScript can be used to make HTML in your web pages.

HTML Table

Make an HTML table with data received as JSON:

Example

obj = { "table":"customers""limit":20 };
dbParam = JSON.stringify(obj);
xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
    if (this.readyState == 4 && this.status == 200) {
        myObj = JSON.parse(this.responseText);
        txt += "<table border='1'>"
        for (x in myObj) {
            txt += "<tr><td>" + myObj[x].name + "</td></tr>";
        }
        txt += "</table>" 
        document.getElementById("demo").innerHTML = txt;
    }
}
xmlhttp.open("POST""json_demo_db_post.php"true);
xmlhttp.setRequestHeader("Content-type""application/x-www-form-urlencoded");
xmlhttp.send("x=" + dbParam);
HTML Drop Down List

Make an HTML drop down list with data received as JSON:

Example

obj = { "table":"customers""limit":20 };
dbParam = JSON.stringify(obj);
xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
    if (this.readyState == 4 && this.status == 200) {
        myObj = JSON.parse(this.responseText);
        txt += "<select>"
        for (x in myObj) {
            txt += "<option>" + myObj[x].name;
        }
        txt += "</select>" 
        document.getElementById("demo").innerHTML = txt;
    }
}
xmlhttp.open("POST""json_demo_db_post.php"true);
xmlhttp.setRequestHeader("Content-type""application/x-www-form-urlencoded");
xmlhttp.send("x=" + dbParam);
Free online tool to format, edit, and validate JSON: JSON Formatter tool.