close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Shipping rate calculator for Canada

Thread began 9/08/2019 7:22 pm by Roxana | Last modified 9/11/2019 2:09 pm by Ray Borduin | 48 views | 14 replies |

Roxana

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.

Sign in to reply to this post

Roxana

Screen shots of the database tables.

Sign in to reply to this post

Ray BorduinWebAssist

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:
<?php

if (!isset($_SESSION["taxexempt"])) $_SESSION["taxexempt"] = 0;
?>
Sign in to reply to this post

Roxana

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.

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post

Roxana

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.

Sign in to reply to this post

Ray BorduinWebAssist

On cart.php on line 39 you have:

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


try:

php:
$_SESSION['userpostcode'] = (isset($_POST["postcode"]))?substr($_POST["postcode"],0,1):"";
Sign in to reply to this post

Roxana

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):"";
}
?>

Sign in to reply to this post

Ray BorduinWebAssist

You may need to set a default tax rate like:

php:
<?php

if (!isset($_SESSION["canadausertaxrate"])) $_SESSION["canadausertaxrate"] = 0;
?>
Sign in to reply to this post

Roxana

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...