<div>
The best way to do this (IMHO) is to save the shopping cart in a database such as mySQL.
</div>

<div>
I already know that I have to save the items related to each user in the DB before the user logged out. But the big question: how to implement it. Could you please provide an example code that do that.
</div>

<div>
I didn't know that you already know. &nbsp;You might be surprised at the number of people who are trying to keep the shopping cart in $_SESSION variables. 
 
Unfortunately, I don't have sample shopping cart code. &nbsp;Perhaps some other expert has such code in &quot;inventory.&quot; 
 
 
How about we do this? 
 
Let's see if someone shows up with some sample code. &nbsp;If you get tired of waiting, I can talk to you about design concepts. &nbsp;(For starters, you'll need a list of the information you want to store such as part #, desc, quan, price.) &nbsp;I will not have much, if any, time on Saturday to engage in discussions.
</div>

<div>
Which portion are you needing code for? The connection between your PHP cart and your MySQL database? 
 
Can you upload some sample code for your PHP cart?
</div>

<div>
That's well put CKY092. &nbsp;I think we need some more context. &nbsp;What information do you plan to store?
</div>

<div>
Here is the show_cart.php code: 
 

<pre><code class="code-10 nolinks" id="code-20-36929885-1">&lt;?php
 include ('hbargi_fns.php');
 // The shopping cart needs sessions, so start one
 session_start();

 @$new = $_GET['new'];

 if($new) {
 //new item selected
 if(!isset($_SESSION['cart'])) {
 $_SESSION['cart'] = array();
 $_SESSION['items'] = 0;
 $_SESSION['total_price'] ='0.00';
 }

 if(isset($_SESSION['cart'][$new])) {
 $_SESSION['cart'][$new]++;
 } else {
 $_SESSION['cart'][$new] = 1;
 }

 $_SESSION['total_price'] = calculate_price($_SESSION['cart']);
 $_SESSION['items'] = calculate_items($_SESSION['cart']);
 }

 if(isset($_POST['save'])) {
 foreach ($_SESSION['cart'] as $itemid =&gt; $qty) {
 if($_POST[$itemid] == '0') {
 unset($_SESSION['cart'][$itemid]);
 } else {
 $_SESSION['cart'][$itemid] = $_POST[$itemid];
 }
 }

 $_SESSION['total_price'] = calculate_price($_SESSION['cart']);
 $_SESSION['items'] = calculate_items($_SESSION['cart']);
 }
 // Delete from cart...
 if($_GET['action'] == 'deletefromcart') {
 deletefromcart($_SESSION['cart'], $_GET['id']);
 
}

 do_html_header(&quot;Your shopping cart&quot;);
 

 if(($_SESSION['cart']) &amp;&amp; (array_count_values($_SESSION['cart']))) {
 display_cart($_SESSION['cart']);
 } else {
 echo &quot;&lt;p&gt;There are no items in your cart&lt;/p&gt;&lt;hr/&gt;&quot;;
 }
 
 // get the item info out from
 
 $target = &quot;index.php&quot;;

 // if we have just added an item to the cart, continue shopping in that country
 if($new) {
 $details = get_item_details($new);
 if($details['catid']) {
 $target = &quot;show_cat.php?catid=&quot;.$details['catid'];
 }
 } 
 
 
function deletefromcart($cart, $itemid) {
 //unset ($cart[$itemid]);
 
 unset($_SESSION['cart'][$itemid]);
 $_SESSION['total_price'] = calculate_price($_SESSION['cart']);
 $_SESSION['items'] = calculate_items($_SESSION['cart']);
 header(&quot;Location:show_cart.php&quot;);
 
 
}
 
 display_button($target, &quot;continue-shopping&quot;, &quot;Continue Shopping&quot;);

 // use this if SSL is set up
 // $path = $_SERVER['PHP_SELF'];
 // $server = $_SERVER['SERVER_NAME'];
 // $path = str_replace('show_cart.php', '', $path);
 // display_button(&quot;https://&quot;.$server.$path.&quot;checkout.php&quot;,
 // &quot;go-to-checkout&quot;, &quot;Go To Checkout&quot;);

 // if no SSL use below code
 display_button(&quot;checkout.php&quot;, &quot;go-to-checkout&quot;, &quot;Go To Checkout&quot;);

 do_html_footer();
?&gt;
</code></pre>
 
And this is display_cart function: 

<pre><code class="code-10 nolinks" id="code-20-36929885-2">function display_cart($cart, $change = true, $images = 1) {
 // display items in shopping cart
 // optionally allow changes (true or false)
 // optionally include images (1 - yes, 0 - no)

 echo &quot;&lt;table border=\&quot;0\&quot; width=\&quot;100%\&quot; cellspacing=\&quot;0\&quot;&gt;
 &lt;form action=\&quot;show_cart.php\&quot; method=\&quot;post\&quot;&gt;
 &lt;tr&gt;&lt;th colspan=\&quot;&quot;.(1 + $images).&quot;\&quot; bgcolor=\&quot;#cccccc\&quot;&gt;Item&lt;/th&gt;
 &lt;th bgcolor=\&quot;#cccccc\&quot;&gt;Price&lt;/th&gt;
 &lt;th bgcolor=\&quot;#cccccc\&quot;&gt;Quantity&lt;/th&gt;
 &lt;th bgcolor=\&quot;#cccccc\&quot;&gt;Total&lt;/th&gt;
 &lt;th bgcolor=\&quot;#cccccc\&quot;&gt;Remove&lt;/th&gt;
 &lt;/tr&gt;&quot;;

 //display each item as a table row
 foreach ($cart as $itemid =&gt; $qty) {
 $item = get_item_details($itemid);
 echo &quot;&lt;tr&gt;&quot;;
 if($images == true) {
 echo &quot;&lt;td align=\&quot;left\&quot;&gt;&quot;;
 if (file_exists(&quot;images/&quot;.$itemid.&quot;.jpg&quot;)) {
 $size = GetImageSize(&quot;images/&quot;.$itemid.&quot;.jpg&quot;);
 if(($size[0] &gt; 0) &amp;&amp; ($size[1] &gt; 0)) {
 echo &quot;&lt;img src=\&quot;images/&quot;.$itemid.&quot;.jpg\&quot;
 style=\&quot;border: 1px solid black\&quot;
 width=\&quot;&quot;.($size[0]/3).&quot;\&quot;
 height=\&quot;&quot;.($size[1]/3).&quot;\&quot;/&gt;&quot;;
 }
 } else {
 echo &quot;&amp;nbsp;&quot;;
 }
 echo &quot;&lt;/td&gt;&quot;;
 }
 echo &quot;&lt;td align=\&quot;left\&quot;&gt;
 &lt;a href=\&quot;show_item.php?itemid=&quot;.$itemid.&quot;\&quot;&gt;&quot;.$item['name'].&quot;&lt;/a&gt;
 &lt;/td&gt;
 &lt;td align=\&quot;center\&quot;&gt;\$&quot;.number_format($item['price'], 2).&quot;&lt;/td&gt;
 

 &lt;td align=\&quot;center\&quot;&gt;&quot;;

 // if we allow changes, quantities are in text boxes
 if ($change == true) {
 echo &quot;&lt;input type=\&quot;text\&quot; name=\&quot;&quot;.$itemid.&quot;\&quot; value=\&quot;&quot;.$qty.&quot;\&quot; size=\&quot;3\&quot;&gt;&quot;;
 } else {
 echo $qty;
 }
 echo &quot;&lt;/td&gt;&lt;td align=\&quot;center\&quot;&gt;\$&quot;.number_format($item['price']*$qty,2).&quot;&lt;/td&gt;
 
 
 &lt;td align=\&quot;center\&quot;&gt; &lt;a href=\&quot;show_cart.php?action=deletefromcart&amp;id=&quot;.$itemid.&quot;\&quot;&gt;Delete from cart&lt;/a&gt;
 
 &lt;/td&gt;
 &lt;/tr&gt;\n&quot;;
 }
 
 // display total row
 echo &quot;&lt;tr&gt;
 &lt;th colspan=\&quot;&quot;.(2+$images).&quot;\&quot; bgcolor=\&quot;#cccccc\&quot;&gt;&amp;nbsp;&lt;/td&gt;
 &lt;th align=\&quot;center\&quot; bgcolor=\&quot;#cccccc\&quot;&gt;&quot;.$_SESSION['items'].&quot;&lt;/th&gt;
 &lt;th align=\&quot;center\&quot; bgcolor=\&quot;#cccccc\&quot;&gt;
 \$&quot;.number_format($_SESSION['total_price'], 2).&quot;
 &lt;/th&gt;
 &lt;th align=\&quot;center\&quot; bgcolor=\&quot;#cccccc\&quot;&gt;&lt;/th&gt;
 &lt;/tr&gt;&quot;;

 // display save change button
 if($change == true) {
 echo &quot;&lt;tr&gt;
 &lt;td colspan=\&quot;&quot;.(2+$images).&quot;\&quot;&gt;&amp;nbsp;&lt;/td&gt;
 &lt;td align=\&quot;center\&quot;&gt;&amp;nbsp&amp;nbsp&amp;nbsp;
 &lt;input type=\&quot;hidden\&quot; name=\&quot;save\&quot; value=\&quot;true\&quot;/&gt;
 &lt;input type=\&quot;image\&quot; src=\&quot;images/save-changes.gif\&quot;
 border=\&quot;0\&quot; alt=\&quot;Save Changes\&quot;/&gt;
 &lt;/td&gt;
 &lt;td&gt;&amp;nbsp;&lt;/td&gt;
 &lt;/tr&gt;
 &lt;tr&gt;&lt;/tr&gt;&quot;;
 }
 echo &quot;&lt;/form&gt;&lt;/table&gt;&quot;;
}
</code></pre>
</div>

<div>
Do you already have your MySQL database and table set up? If so, what fields are in the table?
</div>

<div>
I have two tables that deal with sessions. 
 
php_session: 
 
session_id, date_created, last_updated. 
 
session_item: 
 
session_id, customerid, itemid
</div>

<div>
How are you planning to store multiple items? &nbsp;(Item ID could be an array)
</div>

<div>
Each user can have many items in his cart. If he logged out and logged in again, the items he picked from the previous session will show up.
</div>

<div>
You should be able to store an array. &nbsp;I haven't done that myself (that I recall). &nbsp; 
 
What do you need help with next? &nbsp;Saving to mySQL? &nbsp;Do you have the table definition done? &nbsp;(Something you can copy/paste?)
</div>

<div>
<div class="content wysiwyg-content">
Hi experts, 
 
I'm doing a shopping cart coding using php and I'm stuck in how to save items in the shopping cart. For example, a user logged in and saved items in the shopping cart. Then, he decided to buy the items later so he logged out. When he logged in again, he should view what what items he has chosen from the pervious session in the shopping cart. I already created a session table in the database but don't know how to implement that in php. 
 
Thanks!
</div>
</div>

Hi experts,

I'm doing a shopping cart coding using php and I'm stuck in how to save items in the shopping cart. For example, a user logged in and saved items in the shopping cart. Then, he decided to buy the items later so he logged out. When he logged in again, he should view what what items he has chosen from the pervious session in the shopping cart. I already created a session table in the database but don't know how to implement that in php.

Thanks!

Save items for the previous session!

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.