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

apostrophes print funny in email

Thread began 10/09/2010 8:59 am by sam308940 | Last modified 10/19/2010 4:25 pm by sam308940 | 1363 views | 12 replies



I did some more testing. And here is what i found:

There are 2 separate issues (sorry but as I am testing I realized that its really 2 issues)

Im attaching my files here as well as giving instructions on how to reproduce the error and submit test orders to get the email confirmation.
-the server takes 10 minutes to send out the email confirmations
-cart_checkout2 and cart_confirm2 are the test mode cart pages
-waue_cart_confirm4_1.php is the email confirmation file

so i check the database record to see how the "puppy's head" was stored.
it is stored as "puppy’s head"
so the apostrophe in there shows that its really some special character apostrophe.

- this displays correctly in the cart
- this shows as "puppy’s head" in the email

I also reproduced this error in another product field that the user can enter on the order form called "Personalization".
The persons name was Téa
- this displays correctly in the cart
- this shows as "Téa" in the email

I also ran a test using a special character in the firstname on the checkout page
(i wanted to test a non-product field)
and i still got the same issue - shows as "Téa" in the email

So I need to resolve the issue of the special characters not showing properly in the emails.

To reproduce this error go here:
select design ELLIE CAT
note the second menu option is CAT'S HEAD
when you add to cart it shows correctly.
if you want to checkout to get the confirmation email
after you hit checkout, change the url at the top to cart_checkout2.php
this will submit to cart_confirm2.php and will run it in test mode for authorization purposes.


to further test the issue listed in #1 I edited the database to be just a plain apostrphe (not the special character made to look like an apostrophe.)
so i changed: "puppy’s head"
into: "puppy's head"
and a new problem resulted.....

an apostrophe in the PRODUCT NAME field it shows fine in the cart pages, and in the confirmation email.
an apostrophe in the PRODUCT DESCRIPTION field it shows fine in the cart pages, and in the confirmation email.

but if i have an apostrophe in any of the fields that I have added (ie columns that I added when running the cart setup wizard) i get this displayed in BOTH the cart pages and the confirmation email:
"puppy|WA|s head"

and if I have an apostrohphe on a checkout field (like first or last name) i get the slash:
Téa O\'Hare.
your stripslashes code solves this on the cart display, but its going to be a bit of work to do this on every field (ie first, last, address, city etc).

And I tested another site that I built with ecart4 and it DOES NOT do this. So I "think" this is an ecart5 related issue? i dont know what i could have done differently (although its possible).

To reproduce these errors......:

select design GOOD PUPPY
note the second menu option is PUPPY'S HEAD
when you add to cart it shows the error "puppy|WA|s head"
this is the "DesignChar" field(column) I added during cart setup/wizard.

this item has an apostrphe in the product name.
please enter something with an apostrphe in the "special requests".
(this is passed to the cart as the product description field)
if you add it to the cart you do not get an error in the cart or the email confirmation.
BOth of these fields are fields that were default setup in the cart.

Continue to checkout:
after you hit checkout, change the url at the top to cart_checkout2.php

be sure to enter into the Name field and Comments/Notes field, something with an apostrophe.

on the cart_confirmation page, you will see the name field displays with the\.
the comments/notes field does not since I added your stripslashes code to it.

if you submit this email, you will see that the emails show the \ as well.
And when I tested your code for the stripslashes($MailBody) it did not solve this issue on these fields.

thanks in advance for you help on this.
I hope all my testing has helped to find the real issue (bug or not)


Attached Files

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





Ease of use


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...