如果我在数据库中有两个表，并且我想从一个表用户id获取到其他表数据，那么如何从php中的数据库中获取数据[关闭]

Question

I have created two table name is 'orders' and 'registration' in one database. when I am registering that is working fine and when i am trying to logged in with current registration that is also working fine. but

problem is only that suppose 5 users registered there and they submitted different orders. after loggin while going to see history of orders all users are seeing the same history and all are able to see each others orders in his account after logged in . I am only trying to stop this. so that only logged users can see their own submission only. they should be able to see others user order

Answer 1

As database schema is not available, I'm assuming the structure like this. Change it where you need.

registration table

Id | firstName | lastName | email | ....

Where, Id is Primary Key and auto-incremented

orders table

orderId | userID | orderName | ...

Where, orderId is Primary Key and auto-incremented ; userID is Id of registration table.

So, when you are logged in through registration table. Create one session for Id.

$_Session['user_id']; (Id of registration table will be stored here.)

For viewing his/her orders

<?
$userID=$_SESSION['user_id'];
$orderQuery="SELECT * FROM orders WHERE userID=$userID";
.
.//Execute Your query
.
?>