html - Show the orders values based on each PERSON from MySQL in PHP when the user logged in -

right have page, users can sign email adres , name , password, when registered .. see order form. if place order .. want show product ordered in users profile page.

so right have 1 database , 1 table , 2 columns.

database: admin_myweb

table : admin_myweb

column 1: customers

column 2: orders

in customers there are 4 rows: id, name, email, password

in orders there 3 rows: id, cus_name, product_name

now if register, details stored in customers. when place order.. example: fruit , press submit button details stored in orders.

but want show ordered details on user profile page like: orders: fruit

i want can show ordered product user on page. this:

$ echo = product_name 

i using php session login, when user log in see page:

    <h1> <?php echo "hi ".$_session['user_name']; ?> <i class="fa fa-user"></i></h1>             <h3><?php echo "".$_session['user_email']; ?></h3>             <hr>             no orders yet <br>              <a href="order" > click here order</a> 

but if place order, want show order (product_name) after place order!

<h1> <?php echo "hi ".$_session['user_name']; ?> <i class="fa fa-user"></i></h1>                 <h3><?php echo "".$_session['user_email']; ?></h3>                 <hr>                 have ordered 1 product:                 - fruit  <br>                  <a href="order" > click here order more</a> 

try save users orders in other table, did in orders, , make inner join retrieving products users have ordered.

like : select * users user = "$_session[user]"

just notice injections.

for example:

 <h1> <?php echo "hi ".$_session['user_name']; ?> <i class="fa fa-user"></i></h1>             <h3><?php echo "".$_session['user_email']; ?></h3>             <hr>             $query = "select * orders user = $_session[user_name]; "   // excute query methods , assume $array result  echo "my great turkish user: " . count($array) . " orders ! <br />";  foreach ($array $record) {  echo "$record[product_name] <br />";   }              <a href="order" > click here order more</a>