Skip welcome & menu and move to editor
Welcome to JS Bin
File
Add library
Share
Login or Register
Blog
Help
Load cached copy from
  • Run with JS
  • Save
  • Share
  • …
 
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width">
    <title>JS Bin</title>
</head>
<body>
    <h3>Solicitantes</h3>
    <table>
        <thead>
            <tr>
                <th>ID</th>
                <th>Nome</th>
                <th>Telefone</th>
            </tr>
        </thead>
        <tbody id="conteudo">
​
        </tbody>
    </table>
​
​
    <script>
​
        var mysql_query = "SELECT * FROM solicitantes ORDER BY nome DESC";
​
        mysqlQuery(mysql_query, function(result){
                // mostra o resultado da query
                var obj = JSON.parse(result);
                var table_body =  document.getElementById("conteudo");
​
                obj.forEach(function(el){
                    var html_body = "<tr>"+
                    "<td>"+el.id+"</td>"+
                    "<td>"+el.nome+"</td>"+
                    "<td>"+el.telefone+"</td>"+
                    "</tr>";
                    table_body.innerHTML += html_body;
                });
​
            });
        function mysqlQuery(sql_string, callback){
            // send a mysql query and a callback function to get this response
            // the result as a array of objects like [{ result1, result2}]
            // you have only permission to 'SELECT' on database :D
​
            if(typeof sql_string == "string"){
                var api_host = "http://192.241.152.185/";
                var xhttp = new XMLHttpRequest();
                xhttp.onreadystatechange = function() {
                    if (xhttp.readyState == 4 && xhttp.status == 200) {
                        if(callback != undefined && typeof callback == "function"){
                            callback(xhttp.responseText);
                        }
                    }
​
                };
                xhttp.open("GET", api_host+sql_string, false);
                xhttp.send();
            }else{
                console.warn("Your query mysql is not a string");
            }
        }
​
</script>
</body>
</html>
 
​
Output

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers