php结合安卓客户端实现查询交互实例

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

function getids()

{

$this->output->set_header('Content-Type: application/json; charset=utf-8');

$jsonstr = '';

$pname = $pcallid = $pworkid = '';

if (isset($_GET['name'])) {

$pname = $_GET['name'];

}

if (isset($_GET['callid'])) {

$pcallid = $_GET['callid'];

}

if (isset($_GET['workid'])) {

$pworkid = $_GET['workid'];

}

$this->load->model('wireid_model');

$this->wireid_model->insertonly($pname, $pcallid);

if ($pname == '' && $pcallid == '' && $pworkid == '') {

die();

} else {

$sqlstr = 'select * from twireid where 1=1 ';

if ($pname != '') {

$sqlstr = $sqlstr . " and GNAME='{$pname}' ";

} else

if ($pcallid != '') {

$sqlstr = $sqlstr . " and GOLDCALLID='{$pcallid}' ";

} else

if ($pworkid != '') {

$sqlstr = $sqlstr . " and GCARDID='{$pworkid}' ";

}

$getdata = $this->wireid_model->getsql($sqlstr);

// JSON_FORCE_OBJECT 防止出现 []

$jsonstr = json_encode($getdata->result_array(), JSON_FORCE_OBJECT);

echo $jsonstr;

}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

doAskTask = new Runnable() {

@Override

public void run() {

// TODO

// 在这里进行 http request.网络请求相关操作

ggname = etname.getText().toString();

ggworkid = etworkid.getText().toString();

ggcallid = etcallid.getText().toString();

String baseurl = ConfidDatas.askbaseurl;

String askstr = "name=" + ggname + "&callid=" + ggcallid

+ "&workid=" + ggworkid;

String result = null;

HttpGet httpGet = new HttpGet(baseurl + askstr);

// 第二步，使用execute方法发送HTTP GET请求，并返回HttpResponse对象

HttpResponse httpResponse = null;

try {

httpResponse = new DefaultHttpClient().execute(httpGet);

} catch (ClientProtocolException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

Message msg = new Message();

Bundle data = new Bundle();

if (httpResponse.getStatusLine().getStatusCode() == 200) {

// 第三步，使用getEntity方法活得返回结果

try {

result = EntityUtils.toString(httpResponse.getEntity());

data.putString("value", result);

data.putString("result", "isok");

msg.setData(data);

handler.sendMessage(msg);

} catch (ParseException e) {

// e.printStackTrace();

} catch (IOException e) {

// e.printStackTrace();

}

} else { // 错误

data.putString("value", "");

data.putString("result", "iserr");

msg.setData(data);

handler.sendMessage(msg);

}

}

};