App using a DB

[McJaegs]

So I am making an App that displays radio stations based on location. It would be completely impractical to code all of the Radio stations into the app as stations change and that would just take a lot of code.

I figure that the best option would be to have the app access an external database for the information. I have looked at the SQL tutorial, and I am pretty confused. I don't know anything about PHP so I don't really know what to do with that.

Could someone help me to get going with this? I know to make a SQL database, but configuring it for remote access and accessing it with an android app is another story.

Thanks

 

[Erel]

You do not need to know PHP to use a remote database.

However if the list is not too long then you can just put it in an online text file and download this file every time.

 

[McJaegs]

You do not need to know PHP to use a remote database.

However if the list is not too long then you can just put it in an online text file and download this file every time.

Well what I am doing in putting every radio station by major city into a table. That would probably be a fairly large file.

 

[McJaegs]

Ok, so i created a php script and placed it on the server, but when I try to run it from a browser I get a 404 page not found error. Any ideas?

 

[DouglasNYoung]

McJaegs,
Try typing the php page address directly into your browser, perhaps on your PC - Can you see the expected output? If you get 'page not found' then its probable that your app isn't formatting the address correctly!

Douglas

 

[McJaegs]

McJaegs,
Try typing the php page address directly into your browser, perhaps on your PC - Can you see the expected output? If you get 'page not found' then its probable that your app isn't formatting the address correctly!

Douglas

Well I think the problem is that I am trying to connect to a MS SQL server and the script is written for a MySQL server

 

[Smee]

Well what I am doing in putting every radio station by major city into a table. That would probably be a fairly large file.

Not really, I use files that have a few hundred lines in each of them and they download pretty quick. Once the full file is downloaded all you need to do is have an update file for changes with one or two lines