将数组插入到android的MySql数据库中。-InsertarrayintoMySqldatabseinandroid

0  

You do not have MySql database in the android, you can do that either on Sqlite on android or try using webservice which post data on the MySql server.

在安卓系统中没有MySql数据库，可以在安卓上使用Sqlite，也可以尝试使用在MySql服务器上发布数据的webservice。

0  

To get the multiple split text from MultiAutoCompleteTextView and storing them in array and passing it to MySql from android:

要从MultiAutoCompleteTextView中获取多个分割文本并将其存储在数组中，并将其从android传递给MySql:

 public class WorkNow extends AppCompatActivity {
public static final String URL_ADD = "YOUR LINK";
public static String KEY_C="tags";



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

    Button add = (Button) findViewById(R.id.buttonAdd);


    String[] str = {"India", "China", "Japan",
            "Nepal", "Italy", "Germany "};

    final MultiAutoCompleteTextView mt = (MultiAutoCompleteTextView)
            findViewById(R.id.multiAutoCompleteTextView1);

    mt.setTokenizer(new MultiAutoCompleteTextView.CommaTokenizer());

    ArrayAdapter adp = new ArrayAdapter(this, android.R.layout.simple_dropdown_item_1line, str);
    mt.setThreshold(1);
    mt.setAdapter(adp);


    assert add != null;
    add.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            String text = mt.getText().toString();

            if (text != null && text.length() > 0) {
                text = text.substring(0, text.length() - 1);
            }
            String countries[] = text.split(",");  // countries array will have all the countries entered in multiAutoCompleteTextView

            for (final String s : countries) {
                Toast.makeText(WorkNow.this, s, Toast.LENGTH_SHORT).show();

                class AddEmployee extends AsyncTask {

                    ProgressDialog loading;

                    @Override
                    protected void onPreExecute() {
                        super.onPreExecute();
                        loading = ProgressDialog.show(WorkNow.this, "Adding...", "Wait...", false, false);
                    }

                    @Override
                    protected void onPostExecute(String s) {
                        super.onPostExecute(s);
                        loading.dismiss();
                        Toast.makeText(WorkNow.this, s, Toast.LENGTH_LONG).show();
                    }

                    @Override
                    protected String doInBackground(Void... v) {
                        HashMap params = new HashMap<>();
                        params.put(KEY_C, s);


                        RequestHandler rh = new RequestHandler();
                        String res = rh.sendPostRequest(URL_ADD, params);
                        return res;
                    }
                }

                AddEmployee ae = new AddEmployee();
                ae.execute();
            }
        }
    });
}


    @Override
    public boolean onCreateOptionsMenu (Menu menu){
        getMenuInflater().inflate(R.menu.menu_main, menu);
        return true;
    }

}

And here is the PHP code:

这里是PHP代码: