php - 我尝试使用 Php、MySQL 在 android 中注册表单并使用 JSON 解析进行响应，但详细信息未插入表中

Question

当我单击注册按钮时，后端没有任何反应，表格中也没有输入任何详细信息。代码中似乎没有错误。我认为我正在使用的 URL 是问题所在。请帮助我。

RegisterRequest.java

import com.android.volley.AuthFailureError;
import com.android.volley.Response;
import com.android.volley.toolbox.StringRequest;
import java.util.HashMap;
import java.util.Map;

public class RegisterRequest extends StringRequest {
    private static final String REGISTER_REQUEST_URL="http://192.168.1.40/Register.php";
    private Map<String,String> params;
    public RegisterRequest(String name, String username, int age, String password, Response.Listener<String> listener) {
        super(Method.POST, REGISTER_REQUEST_URL, listener, null);
        params = new HashMap<>();
        params.put("name", name);
        params.put("username", username);
        params.put("password", password);
        params.put("age", age + "");
    }

    @Override
    public Map<String, String> getParams() {
        return params;
    }
}

注册 Activity 代码:

package com.login.sowmy.loginregister;
import android.content.Intent;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import com.android.volley.RequestQueue;
import com.android.volley.Response;
import com.android.volley.toolbox.Volley;
import org.json.JSONException;
import org.json.JSONObject;

public class RegisterActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_register);
        final EditText etAge=(EditText) findViewById(R.id.etAge);
        final EditText etName=(EditText) findViewById(R.id.etName);
        final EditText etUserName=(EditText) findViewById(R.id.etUserName);
        final EditText etPassword=(EditText) findViewById(R.id.etPassword);
        final Button bRegister=(Button) findViewById(R.id.BRegister);

        bRegister.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                final String name=etName.getText().toString();
                final String username=etUserName.getText().toString();
                final String password=etPassword.getText().toString();
                final int age=Integer.parseInt(etAge.getText().toString());
                Response.Listener<String> responseLister= new Response.Listener<String>() {
                    @Override
                    public void onResponse(String response) {
                        try {
                            JSONObject jsonObject=new JSONObject(response);
                            boolean success=jsonObject.getBoolean("success");
                            if(success){
                                Intent i=new Intent(RegisterActivity.this,LoginActivity.class);
                                RegisterActivity.this.startActivity(i);
                            }else{
                                AlertDialog.Builder builder=new AlertDialog.Builder(RegisterActivity.this);
                                builder.setMessage("Register Failed").setNegativeButton("Retry",null).create().show();
                            }
                        } catch (JSONException e) {
                            e.printStackTrace();
                        }
                    }
                };
                RegisterRequest registerRequest=new RegisterRequest(name,username,age,password,responseLister);
                RequestQueue queue=  Volley.newRequestQueue(RegisterActivity.this);
                queue.add(registerRequest);
            }
        });
    }
}

我在 list 文件中添加了互联网权限，并在构建gradle中包含了编译'com.android.volley:volley:1.0.0'。我的android版本是2.2.3

下面是php代码

<?php
$con = mysqli_connect("localhost", "root", "", "employee11");
$name = $_POST["name"];
$age = $_POST["age"];
$username = $_POST["username"];
$password = $_POST["password"];
$statement = mysqli_prepare($con, "INSERT INTO user (name, username, age, password) VALUES (?, ?, ?, ?)");
mysqli_stmt_bind_param($statement, "siss", $name, $username, $age, $password);
mysqli_stmt_execute($statement);
$response = array();
$response["success"] = true;
echo json_encode($response);
?>

Answer 1

首先使用 postman 检查 api。如果没问题，则从 volley 进行检查。并且您的 api 返回 json 数组 ['success':'true']。所以请看下面的代码。

    // Creating volley request obj
    JsonArrayRequest FormPostRequest = new JsonArrayRequest(url,
            new Response.Listener<JSONArray>() {
                @Override
                public void onResponse(JSONArray response) {
                    Log.d(TAG, response.toString());

                    // Parsing json
                        try {
                            JSONObject obj = response.getJSONObject(0);
                            Toast.makeText(this, obj.getString("success"), Toast.LENGTH_SHORT).show();

                        } catch (JSONException e) {
                            e.printStackTrace();
                        }
                }
            }, new Response.ErrorListener() {
        @Override
        public void onErrorResponse(VolleyError error) {
            VolleyLog.d(TAG, "Error: " + error.getMessage());
        }
    });

    // Adding request to request queue
    AppController.getInstance().addToRequestQueue(FormPostRequest);