在android中向远程服务器传递get请求

Question

我正在尝试从android应用程序向远程服务器发送post请求。请求应在数据库的一列中插入值。服务器端的PHP代码如下：

 <?php 
$servername="sql9.freesqldatabase.com"; 
$username="sql9193859"; 
$password="MUEpGxKWUt"; 
$dbname="sql9193859"; 
$sms_content=$_GET["sms_content"]; 

$conn=new mysqli($servername,$username,$password,$dbname); 

// check connection 

if ($conn->connect_error){
    die("Connection failed: ".$conn->connect_error); 
}
else {
    echo "connected successfully"; 
    $sql="insert into SMS_TABLE(content) values ($sms_content)"; 
    if ($conn->query($sql)===true){
        echo "New record inserted successfully"; 
    }
    else {
        echo "Error:".$sql."<br>".$conn->error; 
    }
}

?>

向远程服务器发送get请求的方法如下：

public void insertSMS() throws IOException {
        viewbtn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                try {
                    URL url = new URL("https://smssaver.000webhostapp.com/helloworld/insert_data.php?sms_content=100");
                    HttpURLConnection urlConnection = (HttpURLConnection) url.openConnection();
                    urlConnection.disconnect();
                } catch (MalformedURLException e1) {
                    e1.printStackTrace();
                } catch (IOException e1) {
                    e1.printStackTrace();
                }
            }
        });


    }

当我在浏览器上键入链接时，它工作正常。但是，当我在Android中调用它时，它不起作用。

Answer 1

打开连接

需要注意的是，URLConnection实例不会在创建时建立实际的网络连接。这只会在调用URLConnection.connect（）时发生。

您需要调用urlConnection.connect（）来执行您的调用

URL url = new URL("https://smssaver.000webhostapp.com/helloworld/insert_data.php?sms_content=100");
HttpURLConnection urlConnection = (HttpURLConnection) url.openConnection();
// additional attributes for request for efficiency 
urlConnection.setReadTimeout(1000);
urlConnection.setConnectTimeout(1000);
urlConnection.setRequestMethod("GET");

urlConnection.connect();