Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Android / Communicating with Database

Author
Message
ApkGames.Guru
10
Years of Service
User Offline
Joined: 25th Oct 2013
Location: England, UK
Posted: 1st Mar 2014 13:32
Hi all.

Has anyone written any mobile app, which connects to a database hosted on a website? I wanted to look into an app, which maintained a high score list centrally and then anyone who uses the app can get the high scores from a database maybe and updates it too when someone sets a new score.

Any advice/examples would be appreciated.

Cheers, Ian.

http://zortokgames.com
Ancient Lady
Valued Member
20
Years of Service
User Offline
Joined: 17th Mar 2004
Location: Anchorage, Alaska, USA
Posted: 1st Mar 2014 19:53
Yes, my current WIP has a web hosted high score.

I am working in Tier 2 and use PHP and MySQL on my web server (I have a VPS that hosts my sites and a few clients).

What Tier are you working in?

Cheers,
Ancient Lady
AGK Community Tester and AppGameKit Master
ApkGames.Guru
10
Years of Service
User Offline
Joined: 25th Oct 2013
Location: England, UK
Posted: 15th Jun 2014 17:50
Hi, I'm on Tier 1. My website is with GoDaddy and I do have access to PHP and MySQL. I've look through the forums to see if I could find a step by step guide to implementing a high score table, two functions, one just to retrieve the list of top 10 scores (in descending order) and the other to send a score back and it insert into the table in MySQL.

Any guidance you can give a PHP/MySQL novice would be much appreciated.

Thanks, Ian.
Naphier
13
Years of Service
User Offline
Joined: 2nd Oct 2010
Location: St Petersburg, Florida
Posted: 15th Jun 2014 23:16
Check out my article in April's newsletter.
It gives function examples and PHP scripts on how to set up stuff for leaderboards. Last month's article discusses how to send files to the server too which might be of use to you. The examples for leaderboards can easily be extended to whatever other information you like.

ApkGames.Guru
10
Years of Service
User Offline
Joined: 25th Oct 2013
Location: England, UK
Posted: 16th Jun 2014 14:15
Excellent! Many thanks for this
johnpeter73
9
Years of Service
User Offline
Joined: 29th Aug 2014
Location:
Posted: 29th Aug 2014 11:28
Thnks its very helpful for me too.

I'm studying Forex trading
johnpeter73
9
Years of Service
User Offline
Joined: 29th Aug 2014
Location:
Posted: 29th Aug 2014 11:30
Thanks it is verry helpful for me too

I'm studying Forex trading
Duffer
21
Years of Service
User Offline
Joined: 9th Feb 2003
Location: chair
Posted: 22nd Oct 2014 18:46
Is there any way I can use this to communicate with a SQLITE database?

a long time dabbler with DBC and DBPro with no actual talent but lots of enthusiasm...
Naphier
13
Years of Service
User Offline
Joined: 2nd Oct 2010
Location: St Petersburg, Florida
Posted: 3rd Nov 2014 12:00
As long as your webserver will host SQLLite, I don't see why not. All of the actual communication is done through PHP. AppGameKit is just making calls to PHP scripts hosted on a server and getting text data responses. Works pretty well, but I've found it to be a bit bulky in Wordspionage.

Login to post a reply

Server time is: 2024-03-29 15:13:03
Your offset time is: 2024-03-29 15:13:03