java - 如何将phpmyadmin数据库与android应用程序连接

Question

我以前问过这个问题，但那次我没有 php 文件，现在我已经创建了 php 文件并将其保存在我的 xampp 文件夹中并且它的工作我已经检查过了，问题出在代码中的某个地方。我正在尝试将我的 android studio 注册页面链接到数据库，但它不起作用。当用户输入他们的详细信息时，它应该自动将其保存在我在 phpmyadmin 上创建的数据库中，但是当我在应用程序上单击注册时，没有任何反应。我将通过下面的代码，请有人能告诉我问题出在哪里吗？谢谢

这是我注册的java类

ublic class Register extends Activity {

EditText ET_FIRST_NAME, ET_LAST_NAME, ET_ADDRESS, ET_EMAIL, ET_PASSWORD;
String first_name,last_name,address,email,password;

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

    ET_FIRST_NAME = (EditText)findViewById(R.id.etFname);
    ET_LAST_NAME = (EditText)findViewById(R.id.etLname);
    ET_ADDRESS = (EditText)findViewById(R.id.etAddress);
    ET_EMAIL = (EditText)findViewById(R.id.etEmail);
    ET_PASSWORD = (EditText)findViewById(R.id.etPassword);
}

public void btRegister(View view)
{
    first_name =  ET_FIRST_NAME.getText().toString();
    last_name = ET_LAST_NAME.getText().toString();
    address = ET_ADDRESS.getText().toString();
    email = ET_EMAIL.getText().toString();
    password = ET_PASSWORD.getText().toString();

    String method = "register";
    BackgroundTask backgroundTask = new BackgroundTask(this);
    backgroundTask.execute(method, first_name,last_name,address,email,password);
    finish();
}
}

这是 Activity

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:orientation="vertical"
android:layout_height="match_parent"
android:padding="15dp"
android:layout_width="match_parent"
android:background="#8a73d5">


<TextView
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Register Form"
    android:textAppearance="?android:textAppearanceLarge"
    android:textStyle="bold"
    android:layout_gravity="center_horizontal"
    android:layout_marginTop="2dp"
    />

<TextView
    android:layout_width="wrap_content"
    android:text="First Name"
    android:layout_height="wrap_content"
    android:textColor="#000000" />

<EditText
    android:id="@+id/etFname"
    android:layout_width="match_parent"

    android:layout_height="wrap_content"
     />

<TextView
    android:layout_width="wrap_content"
    android:text="Last Name"
    android:layout_height="wrap_content"
    android:textColor="#000000"
    android:background="#8a73d5" />

<EditText
    android:id="@+id/etLname"
    android:layout_width="match_parent"
    android:layout_marginBottom="1dp"
    android:layout_height="wrap_content"
     />

<TextView
    android:layout_width="wrap_content"
    android:text="Address"
    android:layout_height="wrap_content"
    android:textColor="#000000" />

<EditText
    android:id="@+id/etAddress"
    android:layout_width="match_parent"
    android:layout_marginBottom="1dp"
    android:layout_height="wrap_content"
    />

<TextView
    android:layout_width="wrap_content"
    android:text="Email"
    android:layout_height="wrap_content"
    android:textColor="#000000" />

<EditText
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    android:inputType="textEmailAddress"
    android:id="@+id/etEmail"
     />

<TextView
    android:layout_width="wrap_content"
    android:text="Password"
    android:layout_height="wrap_content"
    android:textColor="#000000" />

<EditText
    android:id="@+id/etPassword"
    android:layout_width="match_parent"
    android:layout_marginBottom="1dp"
    android:inputType="textPassword"
    android:layout_height="wrap_content"
     />


<Button
    android:id="@+id/btRegister"
    android:text="Register"
    android:layout_width="match_parent"
    android:layout_height="wrap_content" />

这是后台任务类，其中所有代码用于将信息(登录和注册)保存到数据库。

public class BackgroundTask extends AsyncTask <String, Void, String> {
AlertDialog alertDialog;
Context ctx;

BackgroundTask(Context ctx){

    this.ctx = ctx;
}
@Override
protected void onPreExecute() {

    alertDialog = new AlertDialog.Builder(ctx).create();
    alertDialog.setTitle("Login Infomration");
}

@Override
protected String doInBackground(String... params) {
   String reg_url = "http://192.168.0.10/webapp/register.php";
    String login_url = "http://192.168.0.10/webapp/login.php";
    String method = params [0];
    if (method.equals("register") ){
        String first_name = params [1];
        String last_name = params [2];
        String address = params [3];
        String email = params [4];
        String password = params [5];
        try {
            URL url = new URL(reg_url);
            HttpURLConnection httpURLConnection = (HttpURLConnection)url.openConnection();
            httpURLConnection.setRequestMethod("POST");
            httpURLConnection.setDoOutput(true);
            OutputStream OS = httpURLConnection.getOutputStream();
            BufferedWriter bufferedWriter = new BufferedWriter(new OutputStreamWriter(OS, "UTF-8"));

            String data = URLEncoder.encode("first_name", "UTF-8") + "=" + URLEncoder.encode(first_name, "UTF-8") + "&" +
                    URLEncoder.encode("last_name", "UTF-8") + "=" + URLEncoder.encode(last_name, "UTF-8") + "&" +
                    URLEncoder.encode("address", "UTF-8") + "=" + URLEncoder.encode(address, "UTF-8")+ "&" +
                    URLEncoder.encode("email", "UTF-8") + "=" + URLEncoder.encode(email, "UTF-8")+ "&" +
                    URLEncoder.encode("password", "UTF-8") + "=" + URLEncoder.encode(password, "UTF-8");
            bufferedWriter.write(data);
            bufferedWriter.flush();
            bufferedWriter.close();
            OS.close();
            InputStream IS = httpURLConnection.getInputStream();
            IS.close();
            httpURLConnection.disconnect();
            return "Registration Has Been Successful.";
        } catch (MalformedURLException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    else if(method.equals("login"))
    {
        String login_name = params[1];
        String login_pass = params[2];
        try {
            URL url = new URL(login_url);
            HttpURLConnection httpURLConnection = (HttpURLConnection)url.openConnection();
            httpURLConnection.setRequestMethod("POST");
            httpURLConnection.setDoOutput(true);
            httpURLConnection.setDoInput(true);
            OutputStream outputStream = httpURLConnection.getOutputStream();
            BufferedWriter bufferedWriter = new BufferedWriter(new OutputStreamWriter(outputStream,"UTF-8"));
            String data = URLEncoder.encode("login_name","UTF-8")+"="+URLEncoder.encode(login_name,"UTF-8")+"&"+
                    URLEncoder.encode("login_pass","UTF-8")+"="+URLEncoder.encode(login_pass,"UTF-8");
            bufferedWriter.write(data);
            bufferedWriter.flush();
            bufferedWriter.close();
            outputStream.close();
            InputStream inputStream = httpURLConnection.getInputStream();
            BufferedReader bufferedReader = new BufferedReader (new InputStreamReader(inputStream,"iso-8859-1"));
            String response = "";
            String line = "";
            while ((line = bufferedReader.readLine())!=null)
            {
                response+= line;
            }
            bufferedReader.close();
            inputStream.close();
            httpURLConnection.disconnect();
            return response;
        } catch (MalformedURLException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    return null;
}

@Override
protected void onProgressUpdate(Void... values) {
    super.onProgressUpdate(values);
}

@Override
protected void onPostExecute(String result) {
    if(result.equals("Registration Has Been Successful."))
    {
        Toast.makeText(ctx, result, Toast.LENGTH_LONG).show();
    }
else
    {
        alertDialog.setMessage(result);
        alertDialog.show();
    }

}
}

Answer 1

除了使用 asynctask 连接你的 php，你可以使用 volley 库来自动化这个过程。它会自行发出 http 请求并直接为您获取结果。介绍它的一个很好的指南是: http://www.androidhive.info/2012/01/android-login-and-registration-with-php-mysql-and-sqlite/

在尝试通过 asyctask 完成任务后，我切换到 volley，并且只尝试了一次就成功了。

快乐编码。