Reading values

[Anon]

I seem to be having a problem in actually reading in a user id from a cookie and inserting this in to a database.

Any ideas here is the code I am trying to run without any success, although the other variables are being put in to the database ok:

<?
//Check for required fields
if ((!($sel_item)) || (!($sel_item_title)) || (!($sel_item_qty)) || (!($sel_item_price))) {
header("Location: http://www.aboutsuck.com/eshop/showcds.php");
exit;
}

if (!isset($user_id)) {

$token = md5(uniqid(rand())); 
setcookie("user_id",$token,time()+86400,"/",".digitalbeatbox.com"); 

}

//create connection
$connection = mysql_connect("localhost", "username", "password") or die ("Sorry a connection to the server could not be established");

//select database
$db = mysql_select_db("username", $connection) or die ("Sorry a connection to the database could not be established");

//Calculate price
$sel_item_totalprice = $sel_item_qty * $sel_item_price;

//Format datestamp
$date_added = date("d-m-y");

//SQL statement to add record to tracking db
$sql = "INSERT INTO TRACKING VALUES(\"$user_id\", \"$sel_item\", \"$sel_item_title\", \"$sel_item_qty\", \"$sel_item_price\", \"$sel_item_totalprice\", \"$date_added\")";

//Execute SQL and exit if failure
$sql_result = mysql_query($sql, $connection) or die ("Sorry the query could not be executed");
?>

[samscripts]

Hi, I thionk the problem is that the user id cookie value will not be available to use in the script until the next time the page is called, due to the way cookies are set.

Try doing this instead and see if it works:

// uses variable $user_id in place of $token
if (!isset($user_id)) {
$user_id = md5(uniqid(rand()));
setcookie("user_id",$user_id,time()+86400,"/",".digitalbeatbox.com");
}

hope this helps, Sam

[Anon]

That is now put something within the database in the user id field, but now at the next page I cannot get it back out again.

Any ideas on this?

<?
if (!isset($user_id))
{
$token = md5(uniqid(rand()));
setcookie("user_id", $token, time( )+86400, "/",".digital beatbox.com");
}

//create connection
$connection = mysql_connect("localhost", "aboutsuck", "w204094e") or die ("Sorry a connection to the server could not be established");

//select database
$db = mysql_select_db("aboutsuck", $connection) or die ("Sorry a connection to the database could not be established");

//Cart subtotal
$get_itemtot = "SELECT SUM(sel_item_totalprice) FROM TRACKING WHERE user_id = \$user_id\"";
$itemtot_result = mysql_query($get_itemtot) or die ("Sorry we can't add up");
$itemtot = mysql_result($itemtot_result,0, "SUM(sel_item_totalprice)");
$fmt_itemtot = sprintf("%0.2f",$itemtot);

if ($itemtot <"50") {
	$shipping = 2.50;
}
else {
	$shipping = 0;
}

$fmt_shipping = sprintf("%0.2f",$shipping);
$total = $itemtot + $shipping;
$fmt_total =sprintf("%0.2f", $total);

//Get cart
$get_cart = "SELECT sel_item, sel_item_title, sel_item_qty, sel_item_price, sel_item_totalprice FROM TRACKING WHERE user_id = \"user_id\"";
$cart_result = mysql_query($get_cart) or die ("Couldn't get cart!");

$num_rows = mysql_numrows($cart_result);

if ($num_rows =="0"){
echo "You do not have anything in your cart, to checkout.";
} else {

echo " table goes here "