mseerob

Please visit my website. It involves online blog where I like to provide information and talk about my personal life, and you can view my portfolio on the websites that I've worked on in the past. http://www.robslounge.com Please let me know what you think! PS: If you are interested in a link exchange then please let me know!!!!!

Yeah I dont know if your going to get traffic on this website. I dont want this comment to upset you but I dont really find anything interesting on that website. There just pictures on the website thats all. Spice it up more, try to turn it more into a social network where people can post images and can interact with each other. Also include comment system so people can post comments on the pictures. Good luck!!!

Ok I managed to change the quantities of the shopping cart thankfully!! The only problem Im having is displaying the subtotal correctly. If you go on the webapage and let's say you add 3 products to the shopping cart for instance it does display the subtotal (I was doing some testing and it is showing this under the table that displays the total) but it also shows the other calculated subtotals and I dont want to display that. www.robslounge.com/robs_shoppingcart <?php require_once('Connections/shoppingcart.php'); ?> <? session_start(); require("functions.php"); if(isset($_POST['Submit'])){ // Select Database mysql_select_db($database_shoppingcart, $shoppingcart); $query_UpdateQuantity = "SELECT * FROM cart"; $UpdateQuantity = mysql_query($query_UpdateQuantity, $shoppingcart) or die(mysql_error()); $row_UpdateQuantity = mysql_fetch_assoc($UpdateQuantity); $totalRows_UpdateQuantity = mysql_num_rows($UpdateQuantity); // Add Variables $id = $_POST['id']; $quantity = $_POST['quantity']; $storeprice = $_POST['storeprice']; // Update quantity $c = array_combine($id, $quantity); foreach ($c as $itemid => $quant) { // Going through a loop, updating it by each ID mysql_query("UPDATE cart SET quantity = '$quant' WHERE id = '$itemid'") or die (mysql_error()); // Delete the product from the database if the user sets the quantity to "0" mysql_query("DELETE FROM cart WHERE quantity='0' AND session_id='$session_id'") or die (mysql_error()); } } ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $maxRows_view_cart = 10; $pageNum_view_cart = 0; if (isset($_GET['pageNum_view_cart'])) { $pageNum_view_cart = $_GET['pageNum_view_cart']; } $startRow_view_cart = $pageNum_view_cart * $maxRows_view_cart; mysql_select_db($database_shoppingcart, $shoppingcart); $query_view_cart = "SELECT * FROM cart WHERE session_id = '$session_id'"; $query_limit_view_cart = sprintf("%s LIMIT %d, %d", $query_view_cart, $startRow_view_cart, $maxRows_view_cart); $view_cart = mysql_query($query_limit_view_cart, $shoppingcart) or die(mysql_error()); $row_view_cart = mysql_fetch_assoc($view_cart); if (isset($_GET['totalRows_view_cart'])) { $totalRows_view_cart = $_GET['totalRows_view_cart']; } else { $all_view_cart = mysql_query($query_view_cart); $totalRows_view_cart = mysql_num_rows($all_view_cart); } $totalPages_view_cart = ceil($totalRows_view_cart/$maxRows_view_cart)-1; mysql_select_db($database_shoppingcart, $shoppingcart); $query_totalcost = "SELECT SUM(storeprice) FROM cart WHERE session_id='$session_id'"; $totalcost = mysql_query($query_totalcost, $shoppingcart) or die(mysql_error()); $row_totalcost = mysql_fetch_assoc($totalcost); $totalRows_totalcost = mysql_num_rows($totalcost); mysql_select_db($database_shoppingcart, $shoppingcart); $query_calculatetotal = "SELECT * FROM cart WHERE session_id = '$session_id'"; $calculatetotal = mysql_query($query_calculatetotal, $shoppingcart) or die(mysql_error()); $row_calculatetotal = mysql_fetch_assoc($calculatetotal); $totalRows_calculatetotal = mysql_num_rows($calculatetotal); ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> <table width="990" height="654" border="1" align="center" cellspacing="3"> <tr> <td width="135" valign="top"> </td> <td width="636" valign="top"><br /> <form id="form1" name="form1" method="post" action=""> <p> </p> <? # If the shopping cart in the current session is not empty if($row_view_cart['id']!=""){ ?> <table width="631" border="1"> <tr> <td width="120"> </td> <td width="324"><br /> </td> <td width="95"><label>quantity</label></td> <td width="64">Price</td> </tr> <?php do { ?> <tr> <td><img name="" src="products/<?php echo $row_view_cart['image']; ?>" width="120" height="120" alt="" /></td> <td><a href="productdetails.php?productid=<?php echo $row_view_cart['product_id']; ?>"><?php echo $row_view_cart['product_name']; ?></a><br /> Price: $<?php echo $row_view_cart['storeprice']; ?></td> <td><select name="quantity[]" id="quantity[]"> <option value="0" <?php if (!(strcmp(0, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>0</option> <option value="1" <?php if (!(strcmp(1, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>1</option> <option value="2" <?php if (!(strcmp(2, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>2</option> <option value="3" <?php if (!(strcmp(3, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>3</option> <option value="4" <?php if (!(strcmp(4, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>4</option> <option value="5" <?php if (!(strcmp(5, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>5</option> <option value="6" <?php if (!(strcmp(6, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>6</option> </select> <input name="id[]" type="hidden" id="id[]" value="<?php echo $row_view_cart['id']; ?>" /> <input name="storeprice[]" type="hidden" id="storeprice[]" value="<?php echo $row_view_cart['storeprice']; ?>" /></td> <td>$<?php echo sprintf("%01.2f", $row_view_cart['price']); ?></td> </tr> <?php } while ($row_view_cart = mysql_fetch_assoc($view_cart)); ?> </table> <br /> <table width="100%" border="1"> <tr> <td><div align="right">Total: $<? echo $row_totalcost['SUM(storeprice)']; ?></div></td> </tr> </table> <?php do { ?> <? $calculate += $row_calculatetotal['quantity'] * $row_calculatetotal['storeprice']; echo $calculate; echo "<br />"; ?> <?php } while ($row_calculatetotal = mysql_fetch_assoc($calculatetotal)); ?> <br /> <br /> <label> <div align="right"> <input type="submit" name="Submit" id="Submit" value="Submit" /> </div> </label> <? # If it's been found that the current session does not have any products in the shopping cart. } else { echo "<p align=center>Shopping cart is currently empty!</p>"; } ?> <p align="center"><a href="index.php">Main menu</a></p> <p> </p> <p> </p> <p></p> <p> </p> <p> </p> <p> </p> </form> <p align="center"> </p></td> <td width="197" valign="top"> </td> </tr> </table> </body> </html> <?php mysql_free_result($view_cart); mysql_free_result($totalcost); mysql_free_result($calculatetotal); if(isset($_POST['Submit'])){ mysql_free_result($UpdateQuantity); } ?> how can I just display the calculated subtotal? Is there a way where you can calculate the price * quantity in the mysql database?

When you add the first item in the shopping cart, it can update the quantity with no problem. When you add the second item, it can still update the first item you add to the shopping cart but it wont update the quantity on the second item. Thats the problem that Im having... that is all?!

Look cooldude832 I dont know how to program it so it can update all the quantities accordingly thats why I am asking on here?! Thats why you will see mysql_query("UPDATE cart SET quantity = '$quantity' WHERE id = '$id'"); I have read many tutorials but it didnt help..

I posted this before too and nobody replied ??? The page should be working now <?php require_once('Connections/shoppingcart.php'); ?> <? session_start(); require("functions.php"); if(isset($_POST['Submit'])){ $id = $_POST['id']; $quantity = $_POST['quantity']; mysql_query("UPDATE cart SET quantity = '$quantity' WHERE id = '$id'"); } ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $maxRows_view_cart = 10; $pageNum_view_cart = 0; if (isset($_GET['pageNum_view_cart'])) { $pageNum_view_cart = $_GET['pageNum_view_cart']; } $startRow_view_cart = $pageNum_view_cart * $maxRows_view_cart; mysql_select_db($database_shoppingcart, $shoppingcart); $query_view_cart = "SELECT * FROM cart WHERE session_id = '$session_id'"; $query_limit_view_cart = sprintf("%s LIMIT %d, %d", $query_view_cart, $startRow_view_cart, $maxRows_view_cart); $view_cart = mysql_query($query_limit_view_cart, $shoppingcart) or die(mysql_error()); $row_view_cart = mysql_fetch_assoc($view_cart); if (isset($_GET['totalRows_view_cart'])) { $totalRows_view_cart = $_GET['totalRows_view_cart']; } else { $all_view_cart = mysql_query($query_view_cart); $totalRows_view_cart = mysql_num_rows($all_view_cart); } $totalPages_view_cart = ceil($totalRows_view_cart/$maxRows_view_cart)-1; mysql_select_db($database_shoppingcart, $shoppingcart); $query_totalcost = "SELECT SUM(price) FROM cart WHERE session_id='$session_id'"; $totalcost = mysql_query($query_totalcost, $shoppingcart) or die(mysql_error()); $row_totalcost = mysql_fetch_assoc($totalcost); $totalRows_totalcost = mysql_num_rows($totalcost); ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> <table width="990" height="654" border="1" align="center" cellspacing="3"> <tr> <td width="135" valign="top"> </td> <td width="636" valign="top"><br /> <form id="form1" name="form1" method="post" action=""> <p> </p> <? # If the shopping cart in the current session is not empty if($row_view_cart['id']!=""){ ?> <table width="631" border="1"> <tr> <td width="120"> </td> <td width="324"><br /> </td> <td width="95"><label>quantity</label></td> <td width="64">Price</td> </tr> <?php do { ?> <tr> <td><img name="" src="products/<?php echo $row_view_cart['image']; ?>" width="120" height="120" alt="" /></td> <td><a href="productdetails.php?productid=<?php echo $row_view_cart['product_id']; ?>"><?php echo $row_view_cart['product_name']; ?></a><br /> Price: $<?php echo $row_view_cart['storeprice']; ?></td> <td><select name="quantity" id="quantity"> <option value="1" <?php if (!(strcmp(1, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>1</option> <option value="2" <?php if (!(strcmp(2, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>2</option> <option value="3" <?php if (!(strcmp(3, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>3</option> <option value="4" <?php if (!(strcmp(4, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>4</option> <option value="5" <?php if (!(strcmp(5, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>5</option> <option value="6" <?php if (!(strcmp(6, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>6</option> </select> <input name="id" type="hidden" id="id" value="<?php echo $row_view_cart['id']; ?>" /></td> <td>$<?php echo sprintf("%01.2f", $row_view_cart['price']); ?></td> </tr> <? echo "$row_view_cart[id],";?> <?php } while ($row_view_cart = mysql_fetch_assoc($view_cart)); ?> </table> <br /> <table width="100%" border="1"> <tr> <td><div align="right">Total: $<?php echo sprintf("%01.2f", $row_totalcost['SUM(price)']); ?></div></td> </tr> </table> <br /> <br /> <label> <div align="right"> <input type="submit" name="Submit" id="Submit" value="Submit" /> </div> </label> <? # If it's been found that the current session does not have any products in the shopping cart. } else { echo "<p align=center>Shopping cart is currently empty!</p>"; } ?> <p align="center"><a href="index.php">Main menu</a></p> <p> </p> <p> </p> <p></p> <p> </p> <p> </p> <p> </p> </form> <p align="center"> </p></td> <td width="197" valign="top"> </td> </tr> </table> </body> </html> <?php mysql_free_result($view_cart); mysql_free_result($totalcost); ?>

Is anyone experiencing in coding php shopping cart? I am having a really difficult time in one little part and if I can solve this problem then I will be able to code a php shopping cart with no problem. I am having a hard time changing quantities on all the saves products in the when you have more than 1 product in the shopping cart. http://www.robslounge.com/robs_shoppingcart/ I am really frustrated, I have also referenced to many other tutorials but did not find them helpful.

Thank you very much for responding to my thread but I still do not understand Where did you get 56 for input name and 4 for value and how would I go abouts in looping it?

Ok here it goes.. I am creating a practice php shopping cart website and I am kinda stuck. I would like to make it so when the user has multiple products in the shopping cart they can easily change the quantity and it will make the updates in the database. When you add only 1 product in the database it has no problem editing the quantity and changing the prices accordingly but when you start having more than 1 item lets say 2 or more items in the shopping cart I can not make it so it can change the quantities on all the products at once. Can anyone please help me on this, I can not figure this out. www.robslounge.com/robs_shoppingcart/ <?php require_once('Connections/shoppingcart.php'); ?> <? session_start(); require("functions.php"); if(isset($_POST['Submit'])){ $id = $_POST['id']; $quantity = $_POST['quantity']; mysql_query("UPDATE cart SET quantity = '$quantity' WHERE id = '$id'"); } ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $maxRows_view_cart = 10; $pageNum_view_cart = 0; if (isset($_GET['pageNum_view_cart'])) { $pageNum_view_cart = $_GET['pageNum_view_cart']; } $startRow_view_cart = $pageNum_view_cart * $maxRows_view_cart; mysql_select_db($database_shoppingcart, $shoppingcart); $query_view_cart = "SELECT * FROM cart WHERE session_id = '$session_id'"; $query_limit_view_cart = sprintf("%s LIMIT %d, %d", $query_view_cart, $startRow_view_cart, $maxRows_view_cart); $view_cart = mysql_query($query_limit_view_cart, $shoppingcart) or die(mysql_error()); $row_view_cart = mysql_fetch_assoc($view_cart); if (isset($_GET['totalRows_view_cart'])) { $totalRows_view_cart = $_GET['totalRows_view_cart']; } else { $all_view_cart = mysql_query($query_view_cart); $totalRows_view_cart = mysql_num_rows($all_view_cart); } $totalPages_view_cart = ceil($totalRows_view_cart/$maxRows_view_cart)-1; mysql_select_db($database_shoppingcart, $shoppingcart); $query_totalcost = "SELECT SUM(price) FROM cart WHERE session_id='$session_id'"; $totalcost = mysql_query($query_totalcost, $shoppingcart) or die(mysql_error()); $row_totalcost = mysql_fetch_assoc($totalcost); $totalRows_totalcost = mysql_num_rows($totalcost); ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> <table width="990" height="654" border="1" align="center" cellspacing="3"> <tr> <td width="135" valign="top"> </td> <td width="636" valign="top"><br /> <form id="form1" name="form1" method="post" action=""> <p> </p> <? # If the shopping cart in the current session is not empty if($row_view_cart['id']!=""){ ?> <table width="631" border="1"> <tr> <td width="120"> </td> <td width="324"><br /> </td> <td width="95"><label>quantity</label></td> <td width="64">Price</td> </tr> <?php do { ?> <tr> <td><img name="" src="products/<?php echo $row_view_cart['image']; ?>" width="120" height="120" alt="" /></td> <td><a href="productdetails.php?productid=<?php echo $row_view_cart['product_id']; ?>"><?php echo $row_view_cart['product_name']; ?></a><br /> Price: $<?php echo $row_view_cart['storeprice']; ?></td> <td><select name="quantity" id="quantity"> <option value="1" <?php if (!(strcmp(1, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>1</option> <option value="2" <?php if (!(strcmp(2, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>2</option> <option value="3" <?php if (!(strcmp(3, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>3</option> <option value="4" <?php if (!(strcmp(4, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>4</option> <option value="5" <?php if (!(strcmp(5, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>5</option> <option value="6" <?php if (!(strcmp(6, $row_view_cart['quantity']))) {echo "selected=\"selected\"";} ?>>6</option> </select> <input name="id" type="hidden" id="id" value="<?php echo $row_view_cart['id']; ?>" /></td> <td>$<?php echo sprintf("%01.2f", $row_view_cart['price']); ?></td> </tr> <? echo "$row_view_cart[id],";?> <?php } while ($row_view_cart = mysql_fetch_assoc($view_cart)); ?> </table> <br /> <table width="100%" border="1"> <tr> <td><div align="right">Total: $<?php echo sprintf("%01.2f", $row_totalcost['SUM(price)']); ?></div></td> </tr> </table> <br /> <br /> <label> <div align="right"> <input type="submit" name="Submit" id="Submit" value="Submit" /> </div> </label> <? # If it's been found that the current session does not have any products in the shopping cart. } else { echo "<p align=center>Shopping cart is currently empty!</p>"; } ?> <p align="center"><a href="index.php">Main menu</a></p> <p> </p> <p> </p> <p></p> <p> </p> <p> </p> <p> </p> </form> <p align="center"> </p></td> <td width="197" valign="top"> </td> </tr> </table> </body> </html> <?php mysql_free_result($view_cart); mysql_free_result($totalcost); ?> It would be so great if someone could help me with this