title: Product ID and ordered quantity in same table cell
body: <p>I am working ond my exam PHP project, which is based around creating E-Shop.
  Everything went ok until i saw the tables for database, and my professor insist they must be as he is requesting.</p>
  
  <p>What is the problem.
  There are 3 table, users, products, and orders.</p>
  
  <p>users table should contain:</p>
  
  <pre><code>| username| password | name | last name | email | adress | phone | **CART** |
  </code></pre>
  
  <p>product table looks like this:</p>
  
  <pre><code>| product_id | product_name | description | price | image |
  </code></pre>
  
  <p>Orders table:</p>
  
  <pre><code>| order_id | user_id | ordered products |
  </code></pre>
  
  <p>The functionality should be like this:</p>
  
  <p>When user clicks on "add to cart" button prduct id and quantity should be stored in users table -->cart cell, divided by separator.</p>
  
  <p>For example:</p>
  
  <pre><code>| username| password | name | last name | email | adress    | phone | **CART** | should have data
  |  John   | 125544   | john |     doe   |john@g | 1st Stret | 12324 | **14  2;**   |
  </code></pre>
  
  <p>And this info should be displayed on cart.php page.
  When user clicks on Purchase button data goes to Orders table and again in the
  | ordered products | cell should be product_id and quantity.</p>
  
  <p>Then admin should be able to see all order on his page.</p>
  
  <p>We are not allowed to use sessions for cart.</p>
  
  <p>I dont have an idea how can i extract data from a <strong>CART</strong> cell which will look like string ( 14 2;15 4;12 1; ), 1st number is id of product second is quantity ordred then goes separator. Also how to update exact product quantity in that string, at least i dont know any resonable solution.</p>
  
  <p>Any tips, ideas or any other kind of advice would be greatly appreciated.</p>