How to request multiple data from database and insert into array in Android development

Question

I'm new to Android development and I'm basically developing my first app asides the HelloWorld examples and all. Now what I want to do is get data from a database (MySQL), I'm using PHP for server-side. The kind of data needed to be collected are blog entries where there are titles, post-images and excerpts. How do I get them in an array such that I'll be able to list them in a ListView. Actually, I have an idea running in my head which is - get all data and embed them in custom tags using php as in:

<item1>
    <post-title>Title of post goes here</post-title>
    <post-image>http://someimagelink.com</post-image>
    <post-excerpt>Some part of the post body</post-excerpt>
</item1>

And same goes for item2, item3, item3 etc which is representing the ListView rows respectively. Then I'll use a regex to search between each opening and closing tags. I don't know if this idea is lame, lol but I know definitely that its tedious. So I was thinking if there were a direct way handle such task as this or if someone could explain a more simpler way to do this. Thanks

score 0 · Answer 1 · answered Apr 20 '16 at 10:38

0

You might use jsoup to parse the response. It's as simple as writing jQuery/CSS selectors.

answered Apr 20 '16 at 10:38

Jonas Köritz

2,606
21
33

score -1 · Answer 2 · answered Apr 20 '16 at 10:47

-1

That requires a long answer. the short one is: you need to connect to your db using a mysql connector for java. there are plenty of resources and tutorial out there to learn how to use it (like this). Sorry but a real answer to this question will require a blog post. I just gave you the tools to start. good luck!

answered Apr 20 '16 at 10:47

carlo.marinangeli

2,958
2
17
17

Thanks fam lemme on the tools u gave – Skeellz Apr 20 '16 at 10:50
That does not really work for Android http://stackoverflow.com/questions/12233145/connecting-to-mysql-from-android-with-jdbc – cyroxis Apr 20 '16 at 12:39
@cyroxis explain your downvote please. my answer is correct. it works on Android but it is not recommended. of course a webservice would be better. I was just replying to the question. – carlo.marinangeli Apr 23 '16 at 17:36
You are suggesting a officially non recommended solution without 1. Qualifying that this is not recommended 2. Stating why you recommend this over recommended solutions. – cyroxis Apr 25 '16 at 12:58
@cyroxis not recommended officially by who? – carlo.marinangeli Apr 25 '16 at 15:47

How to request multiple data from database and insert into array in Android development

2 Answers2