twilitegxa Posted September 13, 2009 Share Posted September 13, 2009 How can I get and store the user's session id? I was working with a tutorial from a book where it uses the user's session id to save the contents fo their shopping cart and then display that shoppign cart based on the session id, but it just states to use "$PHPSESSID" to save and use their session id, but that is not working. How do i set the $PHPSESSID to the user's session id? Here are the pages I'm using it in: addtocart.php: <?php session_start(); include ("connect_db.php"); if ($_POST[sel_item_id] != "") { //validate item and get tite and price $get_iteminfo = "select item_title from store_items where id = $_POST[sel_item_id]"; $get_iteminfo_res = mysql_query($get_iteminfo) or die(mysql_error()); if (mysql_num_rows($get_iteminfo_res) < 1) { //invalid id, send away header("Location: seestore.php"); exit; } else { //get info $item_title = mysql_result($get_iteminfo_res,0,'item_title'); //add info to cart $addtocart = "insert into store_shoppertrack values ('', '$PHPSESSID', '$_POST[sel_item_id]', '$_POST[sel_item_qty]', '$_POST[sel_item_size]', '$_POST[sel_item_color]', now())"; mysql_query($addtocart); //redirect to showcart page header("Location: showcart.php"); exit; } } else { //send somewhere else header("Location: seestore.php"); exit; } ?> showcart.php: <?php session_start(); //connect to database $conn = mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("smrpg",$conn) or die(mysql_error()); $display_block = "<h1>Your Shopping Cart</h1>"; //check for cart items based on user id $PHPSESSID = session_id(); $get_cart = "select st.id, si.item_title, si.item_price, st.sel_item_qty, st.sel_item_size, st.sel_item_color from store_shoppertrack as st left join store_items as si on si.id = st.sel_item_id where session_id = '$PHPSESSID'"; $get_cart_res = mysql_query($get_cart) or die(mysql_error()); if (mysql_num_rows($get_cart_res) < 1) { //print message $display_block .= "<p>You have no items in your cart. Please <a href=\"seestore.php\">continue to shop</a>!</p>"; } else { //get info and build cart display $display_block .= " <table cellpadding=3 cellspacing=2 border=1 width=98%> <tr> <th>Title</th> <th>Size</th> <th>Color</th> <th>Price</th> <th>Qty</th> <th>Total Price</th> <th>Action</th> </tr>"; while ($cart = mysql_fetch_array($get_cart_res)) { $id = $cart['id']; $item_title = stripslashes($cart['item_title']); $item_price = $cart['item_price']; $item_qty = $cart['item_qty']; $item_color = $cart['sel_item_color']; $item_size = $cart['sel_item_size']; $total_price = sprintf("%.02f", $item_price * $item_qty); $display_block .= "<tr> <td align=center>$item_title <br></td> <td align=center>$item_size <br></td> <td align=center>$item_color <br></td> <td align=center>$item_price <br></td> <td align=center>$item_qty <br></td> <td align=center>\$ $total_price</td> <td align=center><a href=\"removefromcart.php?id=$id\">remove</a></td> </tr>"; } $display_block .= "</table>"; } ?> <html> <head> <title>My Store</title> </head> <body> <?php print $display_block; ?> </body> </html> Can anyone help? Quote Link to comment Share on other sites More sharing options...
twilitegxa Posted September 13, 2009 Author Share Posted September 13, 2009 Nevermind, I figured it out! Thanks anyway guys! $PHPSESSID = session_id(); Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.