How can i retrieve the ordered products by user, and display them? using SESSION PHP

Question

How can i retrieve the ordered products by user, and display them?

I have 2 Tables: Orders_good & Users, if someone register all wil go into users, and if someone order a product everything will go in orders_good.

Everything is working fine, but except 1 thing.

After the user will submit a order, i want that they will see their ordered products on their page.

So let say i want to do this : If the user is logged in, then search the name in the Table: ('orders_good").. And if find that name in that table then search if he has some products orders, if yes: then show the orders, row by row, if no then show: No orders Yet .....

The table: orders_good, haves 2 columns: user_name & product_order

I am tyring with this, the User_Name session is working.

But how can i show the users their ordered products row by row???

$sql = "SELECT * FROM orders";

$result = mysql_query($sql);

if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}

if (mysql_num_rows($result) == 0) {
echo "No rows found, nothing to print so am exiting";
exit;
}


session_id($id);
session_start();
echo $_SESSION['user_name'];
echo $row["product_order"];

This is the DB structure:

enter image description here

Please, [stop using `mysql_*` functions](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php). They are no longer maintained and are [officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). Learn about [prepared statements](http://en.wikipedia.org/wiki/Prepared_statement) instead, and consider using PDO, [it's not as hard as you think](http://jayblanchard.net/demystifying_php_pdo.html). — Jay Blanchard, Jun 02 '15 at 21:40

score 3 · Answer 1 · answered Jun 02 '15 at 21:58

Okay,

First a general warning. Mysql functions are deprecated. Use Mysqli or PDO.

Then.. You should not link tables with usernames. What will happen if you have two users with te same name? things would get mixed through each other.

So the first thing to do is to give your user table and your order table a primary key with autoincrement. And call this column user_id and order_id.

So this would be your user table:

user_id (primary key / autoincrement / integer)
name (varchar)
email (varchar)
...

For your orders table you need a "foreign key" to your users table.

this foreign key stores the user_id .

So this would be your order table:

order_id (primary key / autoincrement / integer)
user_id (integer)
order_date (datetime)
...

You will also need a orderrule table which stores one article that belongs to your order

orderrule_id (primary key / autoincrement / integer)
order_id (integer)
quantity (integer)
description (varchar)
amount (decimal 10,2)

schematic:

user 1: --> order 1: --> orderrule 1
                     --> orderrule 2
                     --> orderrule 3

        --> order 2: --> orderrule 4
                     --> orderrule 5

user 2: --> order 3: --> orderrule 6
                     --> orderrule 7
                     --> orderrule 8
                     --> orderrule 9

        --> order 4: --> orderrule 10

How can i retrieve the ordered products by user, and display them? using SESSION PHP

1 Answers1