Shipping rate calculator for Canada

A tax calculator for Canada is implemented and working on the live page.

But after upgrading to MSQLi it no longer works. Both on the live test page and on the local test server.

It is set up to compare the first letter in the postal code. If only the first letter is used like "E", it calculates correctly, but if a full postal code is entered like "E7M 2M9", it returns a zero value.

Screen shots of the database tables.

It looks like your taxexempt session variable doesn't have a default value set. Try adding this code near the top of the page... maybe after line 59:

<?php

if (!isset($_SESSION["taxexempt"])) $_SESSION["taxexempt"] = 0;

?>

Hi, I added the code to cart.php

It didn't change anything. Like before, if I enter the complete postal code "E7M 2M9" it returns 0 tax with all the messy warnings. If I enter just "E", it calculates the tax correctly.

I wonder, if the recordset should somehow reflect, that only the first letter is compared to the database.

The code had to be added to checkout.php probably... What is the current error?

Image in private message

What baffles me is, that if I only enter the first letter of the postal code, or if I check tax exempt, all works well. It just can't handle the complete postal code.

On cart.php on line 39 you have:

$_SESSION['userpostcode'] = (isset($_POST["postcode"]))?$_POST["postcode"]:"";

try:

$_SESSION['userpostcode'] = (isset($_POST["postcode"]))?substr($_POST["postcode"],0,1):"";

Yes, progress. The calculator on the cart page now works. Some customers don't bother with the calculator, so the postal code entered on the checkout page has to be used to automatically add tax.

On the checkout page, only entering the first letter or checking the tax exempt will provide results, the complete postal code throws the error messages.

Just to be sure, I added the code to the checkout page and then also to the confirm page. But no luck.

<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION['userpostcode'] = (isset($_POST["postcode"]))?substr($_POST["postcode"],0,1):"";
}
?>

You may need to set a default tax rate like:

<?php

if (!isset($_SESSION["canadausertaxrate"])) $_SESSION["canadausertaxrate"] = 0;

?>

A little progress. The tax will display correctly on the success page, but not on the confirm page.

I added the code to the checkout page, confirm page and the cart page in that order, testing after each add.

Like before, just using the first letter of the postal code, works.