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:
PHP
Mysql
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.

or

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

======================================================================
package com.apress.radio;

import java.io.InputStream;
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.app.Activity;
import android.app.ListActivity;
import android.content.Context;
import android.graphics.Color;
import android.media.MediaPlayer;
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
length)
{}
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 code.google.com and
github.com. 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  http://commonsware.com/Android/. Other books and programming 
resources can be found on my knol:

 http://knol.google.com/k/mark-murphy/android-programming 

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

 http://hc.apache.org 

-- 
Mark Murphy (a Commons Guy)
 http://commonsware.com  |  http://twitter.com/commonsguy 

Android App Developer Books:  http://commonsware.com/books.html 

--~--~---------~--~----~------------~-------~--~----~


Sponsored Links


Other Threads

1. About Video Call

Hi all,
    I  want to develop an application containing video call, but I
didn't find the interface in Android about video call. So I wonder
whether Android has this Api in fact, if anyone know it, please tell
me.Thank you in Advance!
--~--~---------~--~----~------------~-------~--~----~

2. start bluetooth failed from UI

Hi:
  On my Netbook
$bttest enable
enable
=0

command hciconfig -a and hcitool scan can get information of device.
But turn on from UI, there's no any response. it's why? have no any
idea. i don't want to analyze from app of UI.  I skiped rfkill in
bluetooth.c,because my platform have no use it. I think I have started
services about bluetooth. follow my init.rc
    chmod 0660 /dev/ttyS1
    chown bluetooth bluetooth /dev/ttyS1
service dbus /system/bin/dbus-daemon --system --nofork
    socket dbus stream 660 bluetooth bluetooth
    user bluetooth
    group bluetooth net_bt_admin
service hcid /system/bin/hcid -s -n -f /etc/bluez/hcid.conf
    socket bluetooth stream 660 bluetooth bluetooth
    socket dbus_bluetooth stream 660 bluetooth bluetooth
    group bluetooth net_bt_admin misc
    disabled
    oneshot
service hciattach /system/bin/hciattach -n /dev/ttyS1 texas 115200
    user bluetooth
    group bluetooth net_bt_admin misc
    disabled
    oneshot
service hfag /system/bin/sdptool add --channel=10 HFAG
    user bluetooth
    group bluetooth net_bt_admin
    disabled
    oneshot
Please help me?

Thanks
Best Regards!
--~--~---------~--~----~------------~-------~--~----~
unsubscribe: android-porting+unsubscr...@googlegroups.com
website: 

3. detect trackball events in dialog

4. Hot to create a mutable Bitmap from the Camera, draw another Bitmap on top, and save it

5. Adding IM providers to native IM app

6. Where can we petition for better Android Market payment options (cell-phone bills...)?

7. Wifi & 3G