java - Android Volley- 添加到数据库

Question

我在 Volley 中实现了一个简单的注册详细信息脚本，它使用我构建的 PHP 脚本，第一次执行代码时，它在 logcat 中显示权限被拒绝错误。然后我添加了权限 <uses-permission android:name="android.permission.INTERNET" />正如其他人所说，但是现在当我尝试注册一个帐户时，logcat 中根本没有消息出现，也没有添加数据。我一直在浏览以前的论坛帖子，找不到与我遇到的类似的内容

代码:

  public void registerAccountButtonOnClick (View v) {

        StringRequest request = new StringRequest(Request.Method.POST, registerURL, new Response.Listener<String>() {
            @Override
            public void onResponse(String response) {

            }
        }, new Response.ErrorListener() {
            @Override
            public void onErrorResponse(VolleyError error) {

            }
        }) {
            @Override
            protected Map<String, String> getParams() throws AuthFailureError {
                Map<String, String> parameters = new HashMap<String, String>();
                parameters.put("FIRST_NAME",firstname.getText().toString());
                parameters.put("LAST_NAME",lastname.getText().toString());
                parameters.put("USER_NAME",username.getText().toString());
                parameters.put("PASSWORD",password.getText().toString());
                return parameters;
            }
        };
        requestQueue.add(request);


    }

PHP:

连接.php

<?php

define('hostname', 'localhost');
define('username','root');
define('dbpassword', '');
define('databaseName', 'YouDecide');

$connect = mysqli_connect(hostname,username,dbpassword,databaseName);


?>

注册账号.php

<?php

if($_SERVER["REQUEST_METHOD"]== "POST") {

    require 'connection.php';
    createAccount();

}

function createAccount()
{
    global $connect;

    $firstname = $_POST["firstname"];

    $lastname = $_POST["lastname"];

    $username = $_POST["username"];

    $password = $_POST["password"];


    $query = "INSERT INTO User(FIRST_NAME,LAST_NAME,USER_NAME,PASSWORD) VALUES ('$firstname', '$lastname', '$username','$password')";

    mysqli_query($connect, $query) or die (mysqli_error($connect));
    mysqli_close($connect);

}

?>

打印堆栈跟踪:

02-18 03:55:12.370 1569-1569/com.example.georgetucker.youdecide W/System.err:     at com.android.volley.toolbox.BasicNetwork.performRequest(BasicNetwork.java:158)
02-18 03:55:12.370 1569-1569/com.example.georgetucker.youdecide W/System.err:     at com.android.volley.NetworkDispatcher.run(NetworkDispatcher.java:114)
02-18 03:55:12.370 1569-1569/com.example.georgetucker.youdecide W/System.err: Caused by: java.net.ConnectException: failed to connect to localhost/127.0.0.1 (port 80) after 2500ms: isConnected failed: ECONNREFUSED (Connection refused)
02-18 03:55:12.370 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.io.IoBridge.isConnected(IoBridge.java:223)
02-18 03:55:12.370 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.io.IoBridge.connectErrno(IoBridge.java:161)
02-18 03:55:12.370 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.io.IoBridge.connect(IoBridge.java:112)
02-18 03:55:12.370 1569-1569/com.example.georgetucker.youdecide W/System.err:     at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:192)
02-18 03:55:12.370 1569-1569/com.example.georgetucker.youdecide W/System.err:     at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:459)
02-18 03:55:12.370 1569-1569/com.example.georgetucker.youdecide W/System.err:     at java.net.Socket.connect(Socket.java:842)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.net.http.HttpConnection.<init>(HttpConnection.java:76)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.net.http.HttpConnection.<init>(HttpConnection.java:50)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.net.http.HttpConnection$Address.connect(HttpConnection.java:362)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.net.http.HttpConnectionPool.get(HttpConnectionPool.java:87)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.net.http.HttpConnection.connect(HttpConnection.java:128)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.net.http.HttpEngine.openSocketConnection(HttpEngine.java:316)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.net.http.HttpEngine.connect(HttpEngine.java:311)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.net.http.HttpEngine.sendSocketRequest(HttpEngine.java:290)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.net.http.HttpEngine.sendRequest(HttpEngine.java:240)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.net.http.HttpURLConnectionImpl.connect(HttpURLConnectionImpl.java:81)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.net.http.HttpURLConnectionImpl.getOutputStream(HttpURLConnectionImpl.java:197)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at com.android.volley.toolbox.HurlStack.addBodyIfExists(HurlStack.java:257)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at com.android.volley.toolbox.HurlStack.setConnectionParametersForRequest(HurlStack.java:227)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at com.android.volley.toolbox.HurlStack.performRequest(HurlStack.java:107)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at com.android.volley.toolbox.BasicNetwork.performRequest(BasicNetwork.java:97)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:   ... 1 more
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err: Caused by: libcore.io.ErrnoException: isConnected failed: ECONNREFUSED (Connection refused)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:     at libcore.io.IoBridge.isConnected(IoBridge.java:208)
02-18 03:55:12.380 1569-1569/com.example.georgetucker.youdecide W/System.err:   ... 21 more

感谢观看:-)

Answer 1

它说 无法连接到 localhost/127.0.0.1(端口 80)

在您的 Android 应用中，您在 registerURL 中使用了错误的 IP，请将 127.0.0.1 或 localhost 替换为以下 IP 地址运行网络服务器(apache？)的机器应该类似于 192.168.xxx.yyy