Here is the code i used to get my data in json encoded
<?php include 'db.php'; $sql="SELECT * FROM Outputs"; //$result=mysqli($conn,$sql); $result = $conn->query($sql); //create an array $esparray = array(); while($row =mysqli_fetch_assoc($result)) { $esparray[] = $row; } echo json_encode($esparray); //close the db connection mysqli_close($conn); ?>and my results is here
[{“id”:“1”,“name”:“AAA”,“status”:“1”},{“id”:“2”,“name”:“BBB”,“status”:“0”}{“id”:“3”,“name”:“CCC”,“status”:“1”}{“id”:“4”,“name”:“DDD”,“status”:“1”}]
I want to display name and status like
Name: AAA
Status: 1
Name: BBB
Status: 0
Name: CCC
Status: 1
Name: DDD
Status: 1
How can i do that? I am new in kodular.