I have some problems with fetching the HTML body from emails from my webserver into my MySQL database.
All the data from the email is stored correctly, it just doesn't store the HTML emails correctly.
This is the part of the PHP that has to fetch the body. I want it to fetch a plain text version and an HTML version.
-----
$message = mysqli_real_escape_string($connect,quoted_printable_decode(imap_fetchbody($inbox,$email_number,1.1)));
$message_html = mysqli_real_escape_string($connect,quoted_printable_decode(imap_fetchbody($inbox,$email_number,1.2)));
if($message == '')
{
$message = mysqli_real_escape_string($connect,strip_tags(quoted_printable_decode(imap_fetchbody($inbox,$email_number,1))));
$message_html = mysqli_real_escape_string($connect,quoted_printable_decode(imap_fetchbody($inbox,$email_number,1)));
}
-----
I checked some emails on my webserver and the encoding is not always the same:
Email 1:
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Email 2:
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: base64
Email 3:
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
So, how to do it right? Should I firstly check which encoding is used?
I won't give you access to my mailserver or webserver. Of course I can supply you with the files that are relevant.
Hi there!
Did go through your Job Description and glad to share that I have experience in working with wordpress platform. I have more than four years of industry experience and have been the part of diverse industry verticals.
I also have expertise with Magento,WordPress, PHP, PHP Scripting and CodeIgnitor along with Photoshop. So can help you with the design as well.
Looking forward to your response.
Hi!
You are right, the encoding can differ from one email to another. Therefore, you must first fetch the structure of the email and then parse the email accordingly.
I can provide you with an php script which does all that, and in the end it returns you both the plain and html content of the email.
Looking forward to hearing from you!