php - 如何在 Android 中使用 ID 从服务器获取数据

Question

我正在编写一个 native Android 应用程序，我在其中使用 PHP MYSQL 从服务器获取数据

在此 [约会列表] 中，我允许用户重新安排约会，但每当我点击项目时都会出现空白表格，简而言之，我不会获取我在列表中单击的特定约会的数据。

问题

如何使用 AppointmentID 在表单中显示数据？

下面我展示了我编写的所有必需代码[客户端和服务器端]

UpcomingActivity.java:

        @Override
        public boolean onContextItemSelected(MenuItem item) {
            AdapterView.AdapterContextMenuInfo info = (AdapterView.AdapterContextMenuInfo)item.getMenuInfo();
            int menuItemIndex = item.getItemId();
            String[] menuItems = Cmd;
            String CmdName = menuItems[menuItemIndex];
            // Check Event Command
            if ("Cancel".equals(CmdName)) 
            {
                Toast.makeText(UpcomingActivity.this,"Selected Cancel",Toast.LENGTH_LONG).show();           
            }
            else if ("Reschedule".equals(CmdName)) 
            {
                Toast.makeText(UpcomingActivity.this,"Selected Update",Toast.LENGTH_LONG).show();

                String sAppointmentID = MyArrList.get(info.position).get("UserID").toString();                      
                Log.d(tag, "sAppointmentID :: " + sAppointmentID);

                Intent newActivity = new Intent(UpcomingActivity.this, UpdateActivity.class);
                newActivity.putExtra("UserID", sAppointmentID);                     
                startActivity(newActivity);
            }             
            return true;
        }

更新 Activity .java:

            public void showInfo()
            {
                final TextView tAppointmentID = (TextView)findViewById(R.id.txtUsername);
                final TextView tType = (TextView)findViewById(R.id.txtName);
                final TextView tDate = (TextView)findViewById(R.id.txtEmail);
                final TextView tTime = (TextView)findViewById(R.id.txtTel);

                Button btnSave = (Button) findViewById(R.id.btnSave);
                Button btnCancel = (Button) findViewById(R.id.btnCancel);
                String url = "http://10.0.2.2/appointments/getByMemberID.php";

                Intent intent= getIntent();
                final String AppointmentID = intent.getStringExtra("AppointmentID");
                List<NameValuePair> params = new ArrayList<NameValuePair>();
                params.add(new BasicNameValuePair("sAppointmentID", AppointmentID));

                String resultServer  = getHttpPost(url,params);
                String strAppointmentID = "";               
                String strType = "";
                String strDate = "";
                String strTime = "";

                JSONObject c;
                try {
                    c = new JSONObject(resultServer);

                    strAppointmentID = c.getString("UserID");
                    Log.d(TAG, "String strAppointmentID" + strAppointmentID);
                    strType = c.getString("Type");
                    Log.d(TAG, "String strType" + strType);
                    strDate = c.getString("Date");
                    Log.d(TAG, "String strDate" + strDate);
                    strTime = c.getString("Time");
                    Log.d(TAG, "String strTime" + strTime);

                    if(!strAppointmentID.equals(""))
                    {
                        tAppointmentID.setText(strAppointmentID);
                        tType.setText(strType);
                        tDate.setText(strDate);
                        tTime.setText(strTime);
                    }   
                    else
                    {
                        tAppointmentID.setText("-");
                        tType.setText("-");
                        tDate.setText("-");
                        tTime.setText("-"); 
                        btnSave.setEnabled(false);
                        btnCancel.requestFocus();
                    }

                } catch (JSONException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }   
            }

Answer 1

1. 首先确保您拥有有效的 AppointmentID 和 UserId 以及

2. 在 UpcomingActivity.java 的方法 onContextItemSelected 中，您没有提供 AppointmentID 而只是提供 UserID 到 Intend

3. List 但在 Updateactivity 的方法 showData 中，您请求的 intent.getStringExtra("AppointmentID") 无效。

所以你更新你的 UpcomingActivity.java 应该是这样的

 public boolean onContextItemSelected(MenuItem item) {
        AdapterView.AdapterContextMenuInfo info = (AdapterView.AdapterContextMenuInfo)item.getMenuInfo();
        int menuItemIndex = item.getItemId();
        String[] menuItems = Cmd;
        String CmdName = menuItems[menuItemIndex];
        // Check Event Command
        if ("Cancel".equals(CmdName)) 
        {
            Toast.makeText(UpcomingActivity.this,"Selected Cancel",Toast.LENGTH_LONG).show();           
        }
        else if ("Reschedule".equals(CmdName)) 
        {
            Toast.makeText(UpcomingActivity.this,"Selected Update",Toast.LENGTH_LONG).show();

            String sAppointmentID = MyArrList.get(info.position).get("UserID").toString();                      
            Log.d(tag, "sAppointmentID :: " + sAppointmentID);

            Intent newActivity = new Intent(UpcomingActivity.this, UpdateActivity.class);
            newActivity.putExtra("UserID", sAppointmentID);
            newActivity.putExtra("AppointmentID", MyArrList.get(info.position).get("AppointmentID").toString());// <== here                     
            startActivity(newActivity);
        }             
        return true;
    }