Untitled

//index.html

<html>
<head>
    <script src="jquery.min.js"></script>
</head>
<body>
    <button onclick="getData()">Click me</button>
    <div id="result">

    </div>
</body>
<script>
    function getData(){
        $.ajax({
            url: "proccess.php",
            type: "POST",
            success: function(data){//laman ng data ay yung table
                var result = data;
                var parsedData = JSON.parse(result);//convert to ojbect ulit

                for(var i = 0;i < parsedData.length; i++){
                    $("#result").append("<p> ID:" + parsedData[i].id + ", Name:" + parsedData[i].username + ", password:" +parsedData[i].password + "</p>")
                }
            }, error: function(xhr){

            }
        });
    }
</script>
</html>

//proccess.html

<?php
include("dbconn.php");

$query = mysql_query("SELECT * FROM user");//

if(mysql_num_rows($query) > 0){ //para macheck nya kung may laman
    $array = array();//d2 issave ung laman ng table
    while($row=mysql_fetch_array($query)){
        $obj = new stdClass();// create object
        $obj->id = $row['id']; //create object name with data row
        $obj->username = $row['username'];
        $obj->password = $row['password'];

        array_push($array, $obj);//insert all $obj to $arr
    }

    echo json_encode($array); // convert to string
}
?>