Webservice to fetch data from database is as given below:
Smart.php
define('HOST','localhost');
define('USER','root');
define('PASS','root');
define('DB','Stud');
$con = mysqli_connect(HOST,USER,PASS,DB);
$sql = "select * from Student";
$result=array();
$res = mysqli_query($con,$sql);
enter code here
while($row = mysqli_fetch_array($res)){
array_push($result,
array('id'=>$row[0],
'name'=>$row[1],
'address'=>$row[2]
));
}
echo json_encode(array("result"=>$result));
mysqli_close($con);
?>
Android program is as given below:
MainActivity.java
public class MainActivity extends AppCompatActivit