如果是PHP做的服務端,要用Android去訪問,如何辦?當然可以用REST,但也可以用點笨的方法,比如PHP的服務端可以用JSON和XML提供返回的數據,而android端則可以用APACHE的httpclient去訪問.
下面是一個例子,假設數據表中users表有如下字段(mysql):
idusers,UserName,FullName,加點數據.然後在服務端PHP,建立一個
webservice1.php,作用是直接返回服務端數據庫的數據,如下:
- <?php
- if(isset($_GET['user']) && intval($_GET['user'])) {
-
-
- $format = strtolower($_GET['format']) == 'json' ? 'json' : 'xml'; //xml is the default
- $user_id = intval($_GET['user']); //no default
-
- /* 連接數據庫*/
- $link = mysql_connect('localhost','root','xxxxx') or die('Cannot connect to the DB');
- mysql_select_db('jsonandroid',$link) or die('Cannot select the DB');
-
- $query = "SELECT * FROM `users`;";
- $result = mysql_query($query,$link) or die('Errant query: '.$query);
-
- $posts = array();
- if(mysql_num_rows($result)) {
- while($post = mysql_fetch_assoc($result)) {
- $posts[] = array('post'=>$post);
- }
- }
-
- /* json格式*/
- if($format == 'json') {
- header('Content-type: application/json');
- echo json_encode(array('posts'=>$posts));
- }
- else {
- header('Content-type: text/xml');
- echo '<posts>';
- foreach($posts as $index => $post) {
- if(is_array($post)) {
- foreach($post as $key => $value) {
- echo '<',$key,'>';
- if(is_array($value)) {
- foreach($value as $tag => $val) {
- echo '<',$tag,'>',htmlentities($val),'</',$tag,'>';
- }
- }
- echo '</',$key,'>';
- }
- }
- }
- echo '</posts>';
- }
-
- }
- ?>
則可以把數據表輸出為JSON或者XML格式了.客戶端的ANDROID調用:
- try {
-
- HttpParams httpParams = new BasicHttpParams();
- HttpConnectionParams.setConnectionTimeout(httpParams,
- TIMEOUT_MILLISEC);
- HttpConnectionParams.setSoTimeout(httpParams, TIMEOUT_MILLISEC);
-
- HttpParams p = new BasicHttpParams();
-
- p.setParameter("user", "1");
-
-
- HttpClient httpclient = new DefaultHttpClient(p);
- String url = "http://10.0.2.2:8082/myphp/phpWebservice/webservice1.php?user=1&format=json";
- HttpPost httppost = new HttpPost(url);
-
-
- try {
- Log.i(getClass().getSimpleName(), "send task - start");
-
- List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>(
- 2);
- nameValuePairs.add(new BasicNameValuePair("user", "1"));
- httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
- ResponseHandler<String> responseHandler = new BasicResponseHandler();
- String responseBody = httpclient.execute(httppost,
- responseHandler);
- // 解析JSON返回的 JSONObject json = new JSONObject(responseBody);
- JSONArray jArray = json.getJSONArray("posts");
- ArrayList<HashMap<String, String>> mylist = new ArrayList<HashMap<String, String>>();
-
- for (int i = 0; i < jArray.length(); i++) {
- HashMap<String, String> map = new HashMap<String, String>();
- JSONObject e = jArray.getJSONObject(i);
- String s = e.getString("post");
- JSONObject jObject = new JSONObject(s);
-
- map.put("idusers", jObject.getString("idusers"));
- map.put("UserName", jObject.getString("UserName"));
- map.put("FullName", jObject.getString("FullName"));
-
- mylist.add(map);
- }
- Toast.makeText(this, responseBody, Toast.LENGTH_LONG).show();