android访问php webservice简单一例
16lz
2021-01-24
如果是PHP做的服务端,要用android去访问,如何办?当然可以用REST,但也可以用点
笨的方法,比如PHP的服务端可以用JSON和XML提供返回的数据,而android端则可以用
APACHE的httpclient去访问.
下面是一个例子,假设数据表中users表有如下字段(mysql):
idusers,UserName,FullName,加点数据.然后在服务端PHP,建立一个
webservice1.php,作用是直接返回服务端数据库的数据,如下:
则可以把数据表输出为JSON或者XML格式了.客户端的ANDROID调用:
再搞个webservice2.php,该文件用来把客户端传送过去的JSON数据保存
而ANDROID端的,可以构造JSON,发送到webservice2.php
这样,就可以把ANDROID发送的数据保存到服务端了
笨的方法,比如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();
再搞个webservice2.php,该文件用来把客户端传送过去的JSON数据保存
<?php $json = file_get_contents('php://input');$obj = json_decode($json);//echo $json;//保存数据库$con = mysql_connect('localhost','root','XXX') or die('Cannot connect to the DB');mysql_select_db('jsonandroid',$con); mysql_query("INSERT INTO `users` (UserName, FullName)VALUES ('".$obj->{'UserName'}."', '".$obj->{'FullName'}."')");mysql_close($con); $posts = array(1); header('Content-type: application/json'); echo json_encode(array('posts'=>$posts));?>
而ANDROID端的,可以构造JSON,发送到webservice2.php
try {JSONObject json = new JSONObject();json.put("UserName", "test2");json.put("FullName", "1234567");HttpParams httpParams = new BasicHttpParams();HttpConnectionParams.setConnectionTimeout(httpParams,TIMEOUT_MILLISEC);HttpConnectionParams.setSoTimeout(httpParams, TIMEOUT_MILLISEC);HttpClient client = new DefaultHttpClient(httpParams);String url = "http://10.0.2.2:8082//myphp/phpWebservice/webservice2.php";HttpPost request = new HttpPost(url);request.setEntity(new ByteArrayEntity(json.toString().getBytes("UTF8")));request.setHeader("json", json.toString());HttpResponse response = client.execute(request);HttpEntity entity = response.getEntity();if (entity != null) {InputStream instream = entity.getContent();String result = RestClient.convertStreamToString(instream);Log.i("Read from server", result);Toast.makeText(this, result,Toast.LENGTH_LONG).show();}
这样,就可以把ANDROID发送的数据保存到服务端了
更多相关文章
- 基于 Android(安卓)NDK 的学习之旅----- Java 方法映射到C中的签
- android通讯录开发 导出数据库
- Android(安卓)序列化对象接口Parcelable使用方法
- Android――ContentProvider (一)创建contentProvider
- Android(安卓)ListView分页加载数据
- android SQLite 的使用
- Android开发-面向对象的数据库Db4o
- android Sqlite数据库事务处理*.sql 语句集文件
- Android(安卓)系统CPU,RAM,ROM,SDCard,MAC等信息查询