(+91)-9910-6998-02 Training Consultant
< Ajax pagination with search filter php Last >
<p> <span style="font-size:16px"><strong>How to Display data from database in JSON format using Ajax and PHP</strong></span><br />
<br />
A very common use of JSON is to read data from a web server and then display these data into a web page.</p>
<p>JSON is text, so when we want to exchange text as data between a browser and web server we can use JSON. In this tutorial, I will teach you how to get data from database in JSON format using Ajax and PHP. PHP has some default functions which can easily handle any JSON string. json_encode() function converts any PHP objects into JSON. Similarly, json_decode() function converts any JSON into PHP array object.</p>
<p> <strong> So, for better understand, follow the following example, it will help you to know how to get data from</strong></p>
<p>database in JSON format using Ajax and PHP. In this example, we will insert a roll number in the input box, it returns corresponding student details from the MySQL database in JSON format and displays in the web page.</p>
Let See code
define('HOST','localhost');
define('USER','root');
define('PASSWORD','');
define('DATABASE','jquery');
$conn = mysqli_connect(HOST,USER,PASSWORD,DATABASE);
include 'db.php';
$select = "select * from company";
$select_mq = mysqli_query($conn,$select);
while($mfa_data = mysqli_fetch_assoc($select_mq)){
$data['company_list'][] = $mfa_data;
}
echo json_encode($data);
exit();
Index.php
<body onload="getcompanylist();">
<table border="1" id="company_data">
</table>
</body>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script>
<script>
function getcompanylist(){
var roll = 1;
$.ajax({
url:'getcompanylist.php',
type:'post',
dataType:'json',
data:{roll:roll},
success:function(data){
$.each(data.company_list ,function(i,post){
var newrow = "<tr><td>"+post.company_name+"</td><td>"+post.company_address+
"</td><td>"+post.company_type+"</td></tr>";
$(newrow).appendTo("#company_data");
})
}
});
}
</script>