php - 如何过滤ListView中已登录的用户？

Question

我希望我的 Android 项目有一个 ListView，能够让用户看到他们自己的帖子。我已经使用用户名在服务器端数据库上完成了一对多关系，以确定谁是哪个帖子的发布者。如何将 ListView 过滤为登录用户名对应的用户名。我使用 SharedPreferences 进行登录...

好吧，这是我的代码。

登录

主要 Activity

public class MainActivity extends AppCompatActivity implements CompoundButton.OnCheckedChangeListener {


final String TAG = this.getClass().getName();
Button btnLogin;
EditText etUsername, etPassword;
TextView tvRegister;
CheckBox cbRemember;
SharedPreferences pref;
SharedPreferences.Editor editor;
boolean checkFlag;
int x = 0;
Toolbar toolbar;
public static final String pref_name = "your shared preference name";
String userId = "userID";


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

    toolbar = (Toolbar) findViewById(R.id.toolbar);
    setSupportActionBar(toolbar);

    etUsername = (EditText) findViewById(R.id.etFirstname);
    etPassword = (EditText) findViewById(R.id.etPassword);
    btnLogin = (Button) findViewById(R.id.btnLogin);
    tvRegister = (TextView) findViewById(R.id.tvRegister);
    cbRemember = (CheckBox) findViewById(R.id.cbRemember);
    cbRemember.setOnCheckedChangeListener(this);
    checkFlag = cbRemember.isChecked();

    pref = getSharedPreferences("Login.conf", Context.MODE_PRIVATE);
    editor = pref.edit();


    final String username = pref.getString("username", "");
    String password = pref.getString("password", "");

    HashMap postData = new HashMap();
    postData.put("username", username);
    postData.put("password", password);

    if (!username.equals("") && (!password.equals(""))) {
        PostResponseAsyncTask task1 = new PostResponseAsyncTask(MainActivity.this, postData,
                new AsyncResponse() {
                    @Override
                    public void processFinish(String s) {

                if (s.contains("renter")) {
                    Log.d(TAG, s);
                    Toast.makeText(MainActivity.this, "Renter Login Successful!", Toast.LENGTH_SHORT).show();
                    Intent in = new Intent(MainActivity.this, ListActivity.class);
                    startActivity(in);

                    finish();

                } else if (s.contains("owner")) {
                    Log.d(TAG, s);
                    Toast.makeText(MainActivity.this, "Owner Login Successful!", Toast.LENGTH_SHORT).show();
                    Intent in = new Intent(MainActivity.this, ownerhome.class);
                    startActivity(in);
                    finish();
                } else {
                    Toast.makeText(MainActivity.this, "Login Failed!", Toast.LENGTH_SHORT).show();
                }

                    }
                });
        task1.execute("http://carkila.esy.es/authenticate.php");

    }

    btnLogin.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            HashMap postData = new HashMap();


            postData.put("username", etUsername.getText().toString());
            postData.put("password", MD5.encrypt(etPassword.getText().toString()));

            PostResponseAsyncTask task1 = new PostResponseAsyncTask(MainActivity.this, postData,
                    new AsyncResponse() {
                        @Override
                        public void processFinish(String s) {
                            Log.d(TAG,s);
                            if (s.contains("renter")) {
                                if (checkFlag) {


                                    editor.putString("username", etUsername.getText().toString());
                                    editor.putString("password", MD5.encrypt(etPassword.getText().toString()));


                                    editor.apply();

                                    Log.d(TAG, pref.getString("password", ""));
                                }

                                Toast.makeText(MainActivity.this, "Renter Login Successful!", Toast.LENGTH_SHORT).show();
                                Intent in = new Intent(MainActivity.this, ListActivity.class);
                                startActivity(in);
                                finish();

                            } else if (s.contains("owner")) {

                                if (checkFlag) {


                                    editor.putString("username", etUsername.getText().toString());
                                    editor.putString("password", MD5.encrypt(etPassword.getText().toString()));


                                    editor.apply();
                                }

                                editor.putString("username", etUsername.getText().toString());
                                editor.putString("password", MD5.encrypt(etPassword.getText().toString()));
                                editor.apply();

                                Toast.makeText(MainActivity.this, "Owner Login Successful!", Toast.LENGTH_SHORT).show();
                                Intent in = new Intent(MainActivity.this, ownerhome.class);
                                startActivity(in);
                                finish();
                            } else {
                                Toast.makeText(MainActivity.this, "Login Failed!", Toast.LENGTH_SHORT).show();
                            }


                        }
                    });
            task1.execute("http://carkila.esy.es/authenticate.php");
        }
    });

    tvRegister.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {

            Intent in = new Intent(MainActivity.this, RegisterActivity.class);
            startActivity(in);
            finish();

        }
    });
}
@Override
public void onCheckedChanged(CompoundButton buttonView, boolean isChecked) {
    checkFlag = isChecked;
    Log.d(TAG, "checkflag: " + checkFlag);
}


}

验证.php

    <?php 
require 'database-config.php';

session_start();


$username = "";
$password = "";

if(isset($_POST['username'])){
$username = $_POST['username'];
}
if (isset($_POST['password'])) {
$password = $_POST['password'];
}
if (isset ($_SESSION['userID'])){
$userID = $_SESSION['userID'];
}


$q = 'SELECT * FROM tbl_user WHERE username=:username AND password=:password';

$query = $dbh->prepare($q);

$query->execute(array(':username' => $username, ':password' => $password));


if($query->rowCount() == 0){
header('Location: Login.php?err=1');
}else{

$row = $query->fetch(PDO::FETCH_ASSOC);
session_regenerate_id();
$_SESSION['sess_user_id'] = $row['userID'];
$_SESSION['sess_username'] = $row['username'];
$_SESSION['sess_userrole'] = $row['roles'];



if( $_SESSION['sess_userrole'] == "renter"){
echo "renter";

echo $_SESSION['sess_user_id'];



}else if ($_SESSION['sess_userrole'] == "owner"){
echo "owner";

echo $_SESSION['sess_user_id'];


}
}
?>          

我想根据谁登录来过滤谁发布的 ListView 。

业主之家

public class ownerhome extends AppCompatActivity implements AsyncResponse, AdapterView.OnItemClickListener {
final String TAG = this.getClass().getName();
private ArrayList<Cars> carList;
private ListView lvCars;
private FunDapter<Cars> adapter;
SharedPreferences pref;
SharedPreferences.Editor editor;


@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_ownerhome);
    Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
    setSupportActionBar(toolbar);

    ImageLoader.getInstance().init(UILConfig.config(ownerhome.this));


    lvCars = (ListView) findViewById(R.id.lvOnwer);

    pref = getSharedPreferences("Login.conf", Context.MODE_PRIVATE);

    Log.d(TAG, pref.getString("username", ""));
    Log.d(TAG, pref.getString("password", ""));

PostResponseAsyncTask taskRead = new PostResponseAsyncTask(ownerhome.this, this);

    taskRead.execute("http://carkila.esy.es/user.php");

    FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);
    fab.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View view) {
            Intent in = new Intent(ownerhome.this, InsertActivity.class);
            startActivity(in);
        }
    });

}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
    MenuInflater findMenuItems = getMenuInflater();
    findMenuItems.inflate(R.menu.menu_main, menu);
    return super.onCreateOptionsMenu(menu);

}

@Override
public boolean onOptionsItemSelected(MenuItem item) {
    int id = item.getItemId();

    if(id == R.id.action_logout){
        editor = pref.edit();
        editor.clear();
        editor.commit();
        Intent in = new Intent(ownerhome.this, MainActivity.class);
        startActivity(in);
        finish();
    }
    return super.onOptionsItemSelected(item);
}


@Override
public void processFinish(String s) {
    Log.d(TAG, s);


    carList = new JsonConverter<Cars>().toArrayList(s,Cars.class);

    BindDictionary<Cars> dict = new BindDictionary<Cars>();

    dict.addDynamicImageField(R.id.ivImg, new StringExtractor<Cars>() {
        @Override
        public String getStringValue(Cars product, int position) {
            return product.Image;
        }
    }, new DynamicImageLoader() {
        @Override
        public void loadImage(String url, ImageView imageView) {

            ImageLoader.getInstance().displayImage(url, imageView); // Default options will be used

        }
    });
    dict.addStringField(R.id.tvCarModel, new StringExtractor<Cars>() {
        @Override
        public String getStringValue(Cars product, int position) {
            return "Car Model: " + product.Car_Model;
        }
    });
    dict.addStringField(R.id.tvCarType, new StringExtractor<Cars>() {
        @Override
        public String getStringValue(Cars product, int position) {
            return "Car Type: " + product.Car_Type;
        }
    });

    dict.addStringField(R.id.tvCapacity, new StringExtractor<Cars>() {
        @Override
        public String getStringValue(Cars product, int position) {
            return "Capacity: " + product.Capacity;
        }
    });
    dict.addStringField(R.id.tvFuelType, new StringExtractor<Cars>() {
        @Override
        public String getStringValue(Cars product, int position) {
            return "Fuel Type: " + product.FuelType;
        }
    });
    dict.addStringField(R.id.tvPlateNumber, new StringExtractor<Cars>() {
        @Override
        public String getStringValue(Cars product, int position) {
            return "Plate Number: " + product.PlateNumber;
        }
    });
    dict.addStringField(R.id.tvPoster, new StringExtractor<Cars>() {
        @Override
        public String getStringValue(Cars product, int position) {
            return "Posted by: " + product.owner;
        }
    });


adapter = new FunDapter<>(
        ownerhome.this, carList, R.layout.layout_list, dict);

lvCars.setAdapter(adapter);
lvCars.setOnItemClickListener(this);

}



@Override
public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
    Cars selectedCars = carList.get(position);
    Intent in = new Intent(ownerhome.this, DetailActivity.class);
    in.putExtra("cars", selectedCars);
    startActivity(in);
}
}

用户.php

<?PHP
include_once("connection.php");

session_start();

$query = "SELECT * FROM tbl_cars ORDER BY Car_No DESC "; 

$result = mysqli_query($conn, $query);

while($row = mysqli_fetch_assoc($result)){
        $data[] = $row;
}
echo json_encode($data);

?>

汽车

public class Cars implements Serializable {

@SerializedName("Car_No")
public int Car_No;

@SerializedName("Car_Model")
public String Car_Model;

@SerializedName("Car_Type")
public String Car_Type;

@SerializedName("Capacity")
public  int Capacity;

@SerializedName("Image")
public String Image;

@SerializedName("fuelType")
public String FuelType;

@SerializedName("carPlatenuNumber")
public String PlateNumber;

@SerializedName("owner")
public String owner;

}

Answer 1

如果我没有正确理解您的数据存储，请纠正我，但我假设您的意思是您已经创建了某种 post 对象，该对象有一个存储数据的位置，并且知道谁发布了，user_id。

假设您想用 ID 为 34 的用户发布的所有帖子填充 ListView 。

对服务器运行查询，按 user_id 过滤帖子，应返回该用户的帖子列表。

即http://[您的 API 的网址]/posts?user_id=34 将返回一个响应，其中包括带有 "user_id"=34 的所有帖子。