duandan4680 2018-10-17 15:19
浏览 51

使用一个php文件将关系(PK,FK“user_id”)的两个表中的数据插入

i have two tables

T1 "user": user_id (PK&Autoincrement) | name | email | password | grade

and

T2 "score": user_id (FK&AI) | mathematik | informatik

so far my php file looks like this:

<?php
    $connect = mysqli_connect("localhost", "id6777294_l2w", "123l2w456", "id6777294_l2w");
    
if(isset($_POST["name"]) && isset($_POST["email"]) && isset($_POST["password"]) && isset($_POST["grade"])){
    $name = $_POST["name"];
    $email = $_POST["email"];
    $password = $_POST["password"];
    $grade = $_POST["grade"];
}

    $statement = mysqli_prepare($connect, "INSERT INTO user(name, email, password, grade) VALUES (?, ?, ?, ?)");
    mysqli_stmt_bind_param($statement, "sssi", $name, $email, $password, $grade);
    mysqli_stmt_execute($statement);
    
    $response = array();
    $response["success"] = true;  
    
    echo json_encode($response);
?>

and this is my client (Android) side at first the StringRequest

public class RegisterRequest extends StringRequest {

    private static final String REGISTER_REQUEST_URL = "http://*****************/Register.php";

   
    private Map<String, String> params;

  
    public RegisterRequest(String name, String email, String password, int grade,
                           Response.Listener<String> listener){

    
        super(Request.Method.POST, REGISTER_REQUEST_URL, listener, null);

        params = new HashMap<>();
        params.put("name", name);
        params.put("email", email);
        params.put("password", password);
        params.put("grade", grade + "");

    }

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

and the Activity

public class RegisterActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_register);

        final EditText nameID = (EditText) findViewById(R.id.nameID);
        final EditText emailID = (EditText) findViewById(R.id.emailID);
        final EditText passwordID = (EditText) findViewById(R.id.passwordID);
        final EditText gradeID = (EditText) findViewById(R.id.gradeID);
        final Button registerbtn = (Button) findViewById(R.id.registerbtn);


        registerbtn.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View v) {

                final String name = nameID.getText().toString();
                final String email = emailID.getText().toString();
                final String password = passwordID.getText().toString();
                final int grade = Integer.parseInt(gradeID.getText().toString());

                //now we need a String Listener for the constructor
                Response.Listener<String> responseListener = new Response.Listener<String>() {

                   

                    @Override
                    public void onResponse(String response) {
                        try {
                            JSONObject jsonResponse = new JSONObject(response);
                            boolean success = jsonResponse.getBoolean("success");

                            if (success){
                                startLoginActivity();
                            }else {
                                AlertDialog.Builder builder = new AlertDialog.Builder(RegisterActivity.this);
                                builder.setMessage("Registrierung fehlgeschlagen").setNegativeButton("Wiederhole",null).create().show();

                            }


                        } catch (JSONException e) {
                            e.printStackTrace();
                        }

                    }
                };

                RegisterRequest registerRequest = new RegisterRequest(name, email, password, grade, responseListener);
                RequestQueue queue = Volley.newRequestQueue(RegisterActivity.this);
                queue.add(registerRequest);
            }
        });


    }

    private void startLoginActivity(){
        Intent intent = new Intent(RegisterActivity.this, LoginActivity.class);
        RegisterActivity.this.startActivity(intent);
    }
}

This code works fine and inserts through registration a new user. But now i want to fill through the php file the two tables respective a user and his score (related with the PK/FK user_id).

Anybody please help me, im stuck here. I dont know how to change the php file and my java code.

</div>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
    • ¥20 怎么用dlib库的算法识别小麦病虫害
    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?