如何显示多个检索MySQL和Android数据的项目

Question

I am currently following a tutorial on retrieving data utilizing an online sql database, volley and android. How ever i am having real trouble making it so that more than one item is displayed. It only displays 1 row of the table even if 5 records match. Any help on this would be much appreciated

I added a loop to the php, which does work if i go through the url. exampleurl/id="1" displays all correct records in the browser. but im stuck on the java side as it only displays one item

while($res = mysqli_fetch_array($r)){

 $result = array();

Answer 1

You are using the same TextView to override again and again the data:

 textViewResult.setText("Name:\t"+name+"
Address:\t" +address+ "
Vice Chancellor:\t"+ vc);

Why don't you use a ListView to show all your results?