android端使用HttpURLConnection与服务器端通信
客户端实现(java)
String urlStr = "http://xx.xx.xxx.xxx/CodeForum/codeLogin.php";
String params = "phone=" + user_phone;
URL url = new URL(urlStr);
HttpURLConnection http = (HttpURLConnection) url.openConnection();
http.setDoOutput(true);
http.setDoInput(true);
http.setRequestMethod("POST");
http.connect();
OutputStream out = http.getOutputStream();
out.write(params.getBytes());
out.flush();
out.close();
InputStream is = http.getInputStream();
BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(is));
String line = "";
StringBuilder sb = new StringBuilder();
while (null != (line = bufferedReader.readLine())) {
sb.append(line);
}
String result = sb.toString();
try {
jsonObject = new JSONObject(result);
} catch (Exception e) {
Log.e("log_tag", "the Error parsing data " + e.toString());
}
服务端实现(php)
<?php
include 'utils.php';
$conn=mysqli_connect("127.0.0.1","root","12345678") or die("数据库服务器连接错误".mysqli_error());
mysqli_select_db($conn,"CodeForum");
$getId=$_POST['uid'];
$getPwd=$_POST['pwd'];
$getPhone=$_POST['uid'];
$sqlPhone=mysqli_query($conn,"SELECT * FROM `user` WHERE `phone` ='$getPhone'");
$sql=mysqli_query($conn,"SELECT * FROM `user` WHERE `name` ='$getId'");
$phoneResult=mysqli_fetch_assoc($sqlPhone);
$result=mysqli_fetch_assoc($sql);
if(!empty($result)){
if($getPwd==$result['pwd']){
$back['status']="1";
$back['info']="login success";
$back['name']=$result['name'];
$back['phone']=$result['phone'];
$back['icon']=base64_encode($result['icon']);
echo(json_encode($back));
}else{
$back['status']="-2";
$back['info']="password error";
echo(json_encode($back));
}
}else if(!empty($phoneResult)){
if($getPwd==$phoneResult['pwd']){
$back['status']="1";
$back['info']="login success";
$back['name']=$phoneResult['name'];
$back['phone']=$phoneResult['phone'];
$back['icon']=base64_encode($phoneResult['icon']);
echo(json_encode($back));
}else{
$back['status']="-2";
$back['info']="password error";
echo(json_encode($back));
}
}else{
$back['status']="-1";
$back['info']="user not exist";
echo(json_encode($back));
}
mysqli_close($conn);
?>