[RESOLVED] $_SESSION help

[cash09]

Hi,

I'm trying to use a session to store a value for an already calculated total.

The problem I have is that when this session is used in another script, and the value stored within the session is entered into my database, it rounds the number up or down instead of using two decimal places as needed.

For example, the calculated total could be 29.97, but when it is entered into the database, it is entered as 30.

		// Calculate the total and sub-totals.
		$subtotal = $_SESSION['cart'][$row['isbn']]['quantity'] * $_SESSION['cart'][$row['isbn']]['price'];
		$total += $subtotal;
		$_SESSION['total'] = number_format ($total, 2);

	// Print the row.
	echo "	<tr>
	<td align=\"left\">{$row['title']}</td>
	<td align=\"left\">{$row['name']}</td>
	<td align=\"right\">£{$_SESSION['cart'][$row['isbn']]['price']}</td>
	<td align=\"center\"><input type=\"text\" size=\"3\" name=\"qty[{$row['isbn']}]\" value=\"{$_SESSION['cart'][$row['isbn']]['quantity']}\" /></td>
	<td align=\"right\">£" . number_format ($subtotal, 2) . "</td>
</tr>\n";
} // End of the WHILE loop.

mysqli_close($dbc); // Close the database connection.

// Print the footer, close the table, and the form.
echo '	<tr>
	<td colspan="4" align="right"><b>Total:<b></td>
	<td align="right">£' . number_format ($total, 2) . '</td>
</tr>
</table><div align="center"><input type="submit" name="submit" value="Update My Basket" />	
<input type="hidden" name="submitted" value="TRUE" />
</form><br /><br /><a href="submit_order.php"><font size="+2">Submit Order</font></a></div>';

Above is the code used to calculate this total and the creation of the session. I have tried to use a number_format for the session but this doesn't work it the same way that it does in the other two instances it is used within this code.

Any help would be greatly appreciated. Thanks in advance.

[laserlight]

Are you sure that the value is being stored in the database correctly?

[cash09]

I think so. How would I find out if its not?

[laserlight]

Well, a manual way is to print $_SESSION['total'] just before it is used in the SQL statement, then check the database in some other way, e.g., some database management script like phpmyadmin.

[cash09]

Okay i've done that and its printing out the value with decimals. But then when its inserted into the database its only a whole number?

[laserlight]

Well, the rounding is a little weird, but check another thing: is the type of the column in the database an integer type or a floating point type?

[cash09]

Its a decimal at the moment. What should it be?

[laserlight]

That would be correct, if it is a DECIMAL(n, 2), where n is at least 4. But if the 2 were a 0 instead, then that could explain the problem.

[cash09]

Yeah at the moment its set to DECIMAL (10,2). I can't see a problem unless its the way its being inserted?

[laserlight]

Maybe. Why not show the code that performs the insertion?

[cash09]

Okay here it is:

// Assume that the customer is logged in and that this page has access to the customer's ID.
$customer = (int) $_SESSION['customer_id'];

// Assume that this page receives the order total.
$total = (int) $_SESSION['total'];

require_once ('/mysqli_connect.php'); // Connect to the database.

// Turn autocommit off.
mysqli_autocommit($dbc, FALSE);

// Add the order to the orders table.
$query = "INSERT INTO orders (customer_id, total) VALUES ($customer, $total)";
$result = mysqli_query($dbc, $query);
if (mysqli_affected_rows($dbc) == 1) {

// Need the order ID.
$oid = mysqli_insert_id($dbc);

// Insert the specific order contents into the database.
$query = "INSERT INTO order_lines (order_id, isbn, quantity, price) VALUES ";
foreach ($_SESSION['cart'] as $isbn => $value) {
	$query .= "($oid, $isbn, {$value['quantity']}, {$value['price']}), ";
}
$query = substr($query, 0, -2); // Chop off last two characters.
$result = mysqli_query ($dbc, $query) or die("Error: ".mysqli_error($dbc));	

// Report on the success.
if (mysqli_affected_rows($dbc) == count($_SESSION['cart'])) {

	// Commit the transaction.
	mysqli_commit($dbc);
	mysqli_close($dbc);

	// Clear the cart.
	unset($_SESSION['cart']);

[laserlight]

Ah, look at this line:

$total = (int) $_SESSION['total'];

You are casting $_SESSION['total'] to an int instead of a float.

[cash09]

I feel like such a noob now! Thanks very much for the help... I really appreciate it 🙂