如何按添加此帖子的用户从帖子中删除行？

Question

这是android studio中的代码，我只想通过引用注册用户的外键user_id从表users中删除此帖子

   public class DailogeUbdatePost extends Dialog implements View.OnClickListener {

String HttpUrlDeleteRecord = "http://localhost/DrSiani/DeletePosts.php";

public Context c;
public Dialog d;
public Button deletDialog,ubdateDialoge;
TextView textDialogAdd;
ProgressDialog progressDialog2;
HashMap<String,String> hashMap = new HashMap<>();
String finalResult ;
HttpParse httpParse = new HttpParse();






public DailogeUbdatePost(Context a) {
    super(a);
    // TODO Auto-generated constructor stub
    this.c = a;
}
@Override
protected void onCreate(final Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    requestWindowFeature(Window.FEATURE_NO_TITLE);
    setContentView(R.layout.activity_dailoge_ubdate_post);

    deletDialog= (Button) findViewById(R.id.deletDialog);
    ubdateDialoge= (Button) findViewById(R.id.ubdateDialoge);


    deletDialog.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            StudentDelete(finalResult);

        }
    });

}


@Override
public void onClick(View v) {
    switch (v.getId()) {
        case R.id.BackBtnDialogDR:

            dismiss();

            break;
        default:
            break;
    }
    dismiss();
}
public void StudentDelete(final String uerId) {

    class DeletePosts extends AsyncTask<String, Void, String> {

        @Override
        protected void onPreExecute() {
            super.onPreExecute();

            progressDialog2 = ProgressDialog.show(getContext(), "Loading Data", null, true, true);
        }

        @Override
        protected void onPostExecute(String httpResponseMsg) {

            super.onPostExecute(httpResponseMsg);

            progressDialog2.dismiss();

            Toast.makeText(getContext(), httpResponseMsg.toString(), Toast.LENGTH_LONG).show();



        }

        @Override
        protected String doInBackground(String... params) {

          
            hashMap.put("user_id", params[0]);

            finalResult = httpParse.postRequest(hashMap, HttpUrlDeleteRecord);

            return finalResult;
        }
    }

    DeletePosts deletePosts = new DeletePosts();

    deletePosts.execute(uerId);
}

}

这是删除代码我有两个表1_user_info(已登录的用户) 2_posts那个用户将发布它表帖子有user_id外键我想删除帖子与添加此帖子的用户只是我希望帮助我

​

<?php
if($_SERVER['REQUEST_METHOD']=='POST'){

include 'connecttomysql.php';

 $con = mysqli_connect($dbserver,$dbusername,$dbpassword,$dbname);

 $ID = $_POST['user_id'];

$Sql_Query = "DELETE FROM posts WHERE user_id = '$ID'";

 if(mysqli_query($con,$Sql_Query))
{
 echo 'Record Deleted Successfully';
}
else
{
 echo 'Something went wrong';
 }
 }
 mysqli_close($con);
?>

Answer 1

$Sql_Query = "DELETE FROM posts WHERE user_id = '$ID' and post_id='$posts_ID'";

现在您可以只删除想要的帖子。