Get list from Website ( PHP , MySQL , HTTP request , XML )

by DemOlitioN » Fri, 10 Apr 2009 01:55:00 GMT

Sponsored Links
 m having a problem.

I am trying to build a software that communicates with a website.
simply, i would like to have a php webpage that when i click a button
it creates an alert on the phone.

I planned on doing that by using a mysql database to with the website
where the click from the webpage will update the database, then the
mobile phone will (at intervals) make a request to the webpage or
database to retrieve that info.

Here's what im thinking of using:
Android OS
Windows Mobile OS

I found a tutorial from Apress called 'Apress Android Tutorials July
2008' and found an example that was about 90% similar to what i want
(with the source code) but when i try it i get errors and I cant find
a way to contact Apress(site is down etc)

The example was called Chapter 5: Loading a List from the Web. when i
use eclipse with the source, the error i get is "UIThreadUtilities
cannot be resolved". I noticed that when i excluded the rest of the
code and specify to import UIThreadUtilities it doesnt work.

I know this message is a bit long and it involves a lot but If anyone
can please help:

1. request i send them the source code from Apress to see if it works
on their eclipse. So I know how to fix it.


2. recommend an alternative way for me to pull info from a URL(or php
page) or a database.

Heres the code its supposed to pick a list of radio stations via xml
parsing from a web location:
I get errors where it says UiThreadutilities and other related places


import java.util.List;
import java.util.Vector;

import javax.xml.parsers.SAXParser;
import javax.xml.parsers.SAXParserFactory;

import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpUriRequest;
import org.apache.http.impl.client.DefaultHttpClient;
import org.xml.sax.Attributes;
import org.xml.sax.InputSource;
import org.xml.sax.Locator;
import org.xml.sax.XMLReader;

import android.content.Context;
import android.os.Bundle;
import android.speech.recognition.Logger;
import android.util.Log;
import android.view.UIThreadUtilities;
import android.view.View;
import android.view.View.OnClickListener;
import android.view.View.OnFocusChangeListener;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.TextView;

public class StationPicker extends ListActivity {

Vector<StationData> stationListVector = new Vector<StationData>();
SAXParser parser = null;
XMLReader reader = null;
XMLHandler handler = new XMLHandler();
ArrayAdapter<StationData> adapter = null;
Activity ctx = this;

class XMLHandler implements org.xml.sax.ContentHandler
StationData currentStation;
String lastName;

public void endDocument(){}
public void endPrefixMapping(String prefix){}
public void ignorableWhitespace(char[] ch, int start, int
public void processingInstruction(Strin

Get list from Website ( PHP , MySQL , HTTP request , XML )

by Mark Murphy » Fri, 10 Apr 2009 06:17:57 GMT


That tutorial is rather old from the standpoint of Android. Most
tutorials written before September 2008 will require some amount of
modification to work on current Android SDK editions.

That class was removed from the SDK, IIRC.

Use a more up-to-date resource!

There are many open source Android projects on and Many of these download data off of the Web. For example,
there projects in the apps-for-android project on Google Code that work
with Flickr's API.

There are several books on Android, at least some of which have their
source code available for download, and some of which cover HTTP
operations. For example, you can download the source code for my book
off of Other books and programming 
resources can be found on my knol: 

For HttpClient proper, there are examples out on their site: 

Mark Murphy (a Commons Guy)  | 

Android App Developer Books: 


Sponsored Links

Other Threads

1. Android desktop and Application.


I want to reduce the application size but not the Desktop size. I
tried changing code in but it changes the
size of desktop as well.

Is there a way to distinguish between them?



2. Emulator crashed on X86_64 Gentoo (SDK 1.6)

I'm really e{*filter*}d about the Android 1.6 release and its new feature.

I installed android-sdk-1.6 on my Gentoo box using the following

# emerge android-sdk

It successfully installed and I could create an AVD named TestAVD
using the "android" command.

But when I tried to run emulator with TestAVD, I got a Segmentation
fault message and the emulator crashed.

Does anyone run android 1.6 emulator successfully on 64bit Linux ?

3. SurfaceView in Layout XML

4. Error occurs when layoutopt is run.

5. AVD emulator problem in Android SDK 2.0

6. SDK installation on Windows - Failed To Fetch URL...

7. Using Text to Speech (Pico) in 1.6 SDK