//THIS IS testtable.php DISPLAY FILE
<table border="1">
    <tr>
                <th>F.name</th><th>L.name</th><th>From</th><th>To</th><th>Date</th><th>Company</th><th>Bus</th><th>Status</th><th></th>
                </tr>
    <tbody id="data"><!--Display data-->

    </tbody>


</table>

<script type="text/javascript">

        // CALL AJAX
                var ajax = new XMLHttpRequest();
                var method = "GET";
                var url = "busserver.php";
                var asynchronous = true;

                ajax.open(method, url, asynchronous);

                //sending ajax request
                ajax.send();

                //receiving response from busserver.php
                ajax.onreadystatechange = function(){
                    if(this.readyState == 4 && this.status == 200){

                        //converting json back to array
                        var data=JSON.parse(this.responseText);
                        console.log(data); //for debbuging

                        //html value for tbody
                        var html="";

                        //looping through the data
                        for(var a = 0; a < data.length; a++){

                            var fname = data[a].fname;
                            var lname = data[a].lname;
                            var kiasi = data[a].kiasijumla;
                            var From = data[a].kutoka;
                            var To = data[a].kwenda;
                            var Date = data[a].datetour;
                            var Company = data[a].companyo;
                            var Bus = data[a].busie;
                            var Status = data[a].payment


                            //APPENDING ON HTML
                            html += "<tr>";

                                html += "<td>" + fname + "</td>";
                                html += "<td>" + lname + "</td>";
                                html += "<td>" + From + "</td>";
                                html += "<td>" + To + "</td>";
                                html += "<td>" + Date + "</td>";
                                html += "<td>" + Company + "</td>";
                                html += "<td>" + Bus + "</td>";
                                html += "<td>" + kiasi + "</td>";
                                html += "<td>" + Status + "</td>";



                            html += "</tr>";

                        }

                        //replacing tbody of table
                        document.getElementById("data").innerHTML = html;
                    }
                }
</script>



//THIS IS busserver.php file
<?php
$link=mysqli_connect("mysql.hostinger.com", "", "");


if(!$link){

    die ("No connection: ".mysqli_connect_error());

} else{




mysqli_select_db($link, "");

$res=mysqli_query($link, "select * from buttonscompany1 where pnumber ='0654349480'");


while($row = mysqli_fetch_assoc($res)){
    $data[] = $row;
}

$data = array();


//returning response in JSON format
echo json_encode($data);
}
?>