Software Archive
Read-only legacy content

Help with data base

Pablo_F_
Beginner
264 Views

Hello,

I'm very new on this world, I'm a videographer, not a coder, I lunch a website platform for upload videos and sell it.

I'm now working in the app, also very  new on this, but, reading and watching, I have something here. I have a Login main page, then, a page where user can choose if he want to record a video, upload a video or visit his profile, I create to profile page and everything it is going well.

Now, I want to connect my website data base to this app, What I mean it is that the user can login with the normal website credentials, and can watch their videos uploaded, sell it. etc. Upload videos to their accounts, preview.

And also, that I new user can login using facebook, saving data to website platform, videos, etc.

If someone can give a feedback or help me with this. It would be great.

Thanks in advance,

Pablo,

 

0 Kudos
1 Reply
RBang
New Contributor II
264 Views

Hi Pablo,

To store or retrieve any information stored on a Database on a web server, you will need to create a simple web service that will pass the requests to the database and then return the results from the database back to Android in a format Android can understand. You can typically send the data in POST or REST and then retrieve the data in JSON format.

In your example website you have a database in which you have a list of videos to watch. When you display the videos on your website you may go the the link: www.pablo.com/videos

That is a link that gets your list of videos and displays them in HTML. You can do the same in Android via the browser, but if you want the data to go to your app, you still ask for data via HTTP/HTTPS except you want the list of paintings formatted differently (not in HTML). So you can set up your website to respond to something like: www.pablo.com/videos.json

This would give you your list of videos in a format called JSON, which is more friendly for app use because it gives the raw data and doesn't worry about the styling (text, colors, etc). You use that link in your Android app and your app will receive the data. You can do whatever you want with the data afterwards within your app (show to your users in a ListView, etc).

Hope this helps.

0 Kudos
Reply