M McJaegs Member Licensed User Longtime User Apr 30, 2012 #1 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
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 B4X founder Staff member Licensed User Longtime User Apr 30, 2012 #2 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. Upvote 0
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.
M McJaegs Member Licensed User Longtime User Apr 30, 2012 #3 Erel said: 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. Click to expand... Well what I am doing in putting every radio station by major city into a table. That would probably be a fairly large file. Upvote 0
Erel said: 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. Click to expand... Well what I am doing in putting every radio station by major city into a table. That would probably be a fairly large file.
M McJaegs Member Licensed User Longtime User May 1, 2012 #4 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? Upvote 0
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?
D DouglasNYoung Active Member Licensed User Longtime User May 2, 2012 #5 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 Upvote 0
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
M McJaegs Member Licensed User Longtime User May 2, 2012 #6 DouglasNYoung said: 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 Click to expand... 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 Upvote 0
DouglasNYoung said: 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 Click to expand... 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
S Smee Well-Known Member Licensed User Longtime User May 2, 2012 #7 McJaegs said: Well what I am doing in putting every radio station by major city into a table. That would probably be a fairly large file. Click to expand... 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 Upvote 0
McJaegs said: Well what I am doing in putting every radio station by major city into a table. That would probably be a fairly large file. Click to expand... 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
