PLCITS
asked on
Save HTML in MySQL
how I can save html in mySQL? Using PHP
the HTML contain pictures and links
any Idea?
the HTML contain pictures and links
any Idea?
Dave Baldwin
Technically, no it doesn't. HTML is all text with Links to pictures. The pictures are not part of the HTML file and have to be loaded and saved separately.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Im Saving html from emails, with IMAP I got the html email and I want to save in mysql Im using righ now urlencode but i dont know if that is the correct way
this is one example of HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>
<body>
<table class='mailbox-read-messag
<tr>
<td>
</td>
</tr>
<tr>
<td>
<table border='0' bgcolor='#EAEAEA' width='100%'>
<tr>
<td align='left' width='10%'>
<B>From:</B>
</td>
<td align='left' width='66%'>
jorgz@plc.com </td>
<td width="24%">
<b>Sent:</b> 20/11/2017 16:42 pm </td>
</tr>
<tr>
<td>
<b>To:</b>
</td>
<td>
jose Lopez
</td>
<td>
</td>
</tr>
<tr>
<td>
<b>CC:</b>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
<b>Subject:</b>
</td>
<td>
Attachment </td>
<td>
</td>
</tr>
<tr>
<td colspan='3'>
<table bgcolor='#FFFFFF'>
<tr>
<td>
Copy of Audit_Arizona-Florida-Mich
Joez.docx
2017_07_14_14_38_54.pdf
DHCP.jpg
RFIDTest.zip
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<html xmlns:v="urn:schemas-micro
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML
o\:* {behavior:url(#default#VML
w\:* {behavior:url(#default#VML
.shape {behavior:url(#default#VML
</style><![endif]--><style
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","san
mso-fareast-language:EN-US
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans
mso-fareast-language:EN-US
span.EmailStyle17
{mso-style-type:personal-c
font-family:"Calibri","san
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans
.MsoChpDefault
{mso-style-type:export-onl
font-family:"Calibri","san
mso-fareast-language:EN-US
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![e
</head>
<body lang="ES-MX" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><o:p>&nb
<p class="MsoNormal"><o:p>&nb
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr style="height:16.5pt">
<td style="padding:0in 0in 0in 0in;height:16.5pt">
<p class="MsoNormal"><b><span
</td>
</tr>
<tr style="height:16.5pt">
<td style="padding:0in 0in 0in 0in;height:16.5pt">
<p class="MsoNormal"><span style="font-size:10.0pt;fo
</td>
</tr>
<tr style="height:16.5pt">
<td style="padding:0in 0in 0in 0in;height:16.5pt">
<p class="MsoNormal"><span style="font-size:10.0pt;fo
</td>
</tr>
<tr style="height:16.5pt">
<td style="padding:0in 0in 0in 0in;height:16.5pt">
<p class="MsoNormal"><b><span
</span></b><span style="font-size:10.0pt;fo
<span style="color:#A5A5A5">|</s
</span></b><span style="font-size:10.0pt;fo
</td>
</tr>
<tr style="height:21.0pt">
<td style="padding:0in 0in 0in 0in;height:21.0pt">
<p class="MsoNormal"><span style="font-size:10.0pt;fo
<span style="color:#A5A5A5">|</s
<span style="color:#A5A5A5">|</s
</span></b><span style="font-size:10.0pt;fo
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12.0pt;fo
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<p class="MsoNormal" align="center" style="text-align:center">
</td>
</tr>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<p class="MsoNormal" align="center" style="text-align:center">
</td>
</tr>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<p class="MsoNormal" align="center" style="text-align:center">
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12.0pt;fo
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="border:none;border-
<p class="MsoNormal"><b><span
to whom it is addressed. If you received this email in error, please notify the sender, do not disclose its contents to others and delete from your system.
</span></b><b><span style="font-size:12.0pt;fo
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12.0pt;fo
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p>&nb
</div>
</body>
</html>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
</tr>
</table>
</body>
</html>
this is one example of HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>
<body>
<table class='mailbox-read-messag
<tr>
<td>
</td>
</tr>
<tr>
<td>
<table border='0' bgcolor='#EAEAEA' width='100%'>
<tr>
<td align='left' width='10%'>
<B>From:</B>
</td>
<td align='left' width='66%'>
jorgz@plc.com </td>
<td width="24%">
<b>Sent:</b> 20/11/2017 16:42 pm </td>
</tr>
<tr>
<td>
<b>To:</b>
</td>
<td>
jose Lopez
</td>
<td>
</td>
</tr>
<tr>
<td>
<b>CC:</b>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
<b>Subject:</b>
</td>
<td>
Attachment </td>
<td>
</td>
</tr>
<tr>
<td colspan='3'>
<table bgcolor='#FFFFFF'>
<tr>
<td>
Copy of Audit_Arizona-Florida-Mich
Joez.docx
2017_07_14_14_38_54.pdf
DHCP.jpg
RFIDTest.zip
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<html xmlns:v="urn:schemas-micro
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML
o\:* {behavior:url(#default#VML
w\:* {behavior:url(#default#VML
.shape {behavior:url(#default#VML
</style><![endif]--><style
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","san
mso-fareast-language:EN-US
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans
mso-fareast-language:EN-US
span.EmailStyle17
{mso-style-type:personal-c
font-family:"Calibri","san
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans
.MsoChpDefault
{mso-style-type:export-onl
font-family:"Calibri","san
mso-fareast-language:EN-US
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![e
</head>
<body lang="ES-MX" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><o:p>&nb
<p class="MsoNormal"><o:p>&nb
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr style="height:16.5pt">
<td style="padding:0in 0in 0in 0in;height:16.5pt">
<p class="MsoNormal"><b><span
</td>
</tr>
<tr style="height:16.5pt">
<td style="padding:0in 0in 0in 0in;height:16.5pt">
<p class="MsoNormal"><span style="font-size:10.0pt;fo
</td>
</tr>
<tr style="height:16.5pt">
<td style="padding:0in 0in 0in 0in;height:16.5pt">
<p class="MsoNormal"><span style="font-size:10.0pt;fo
</td>
</tr>
<tr style="height:16.5pt">
<td style="padding:0in 0in 0in 0in;height:16.5pt">
<p class="MsoNormal"><b><span
</span></b><span style="font-size:10.0pt;fo
<span style="color:#A5A5A5">|</s
</span></b><span style="font-size:10.0pt;fo
</td>
</tr>
<tr style="height:21.0pt">
<td style="padding:0in 0in 0in 0in;height:21.0pt">
<p class="MsoNormal"><span style="font-size:10.0pt;fo
<span style="color:#A5A5A5">|</s
<span style="color:#A5A5A5">|</s
</span></b><span style="font-size:10.0pt;fo
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12.0pt;fo
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<p class="MsoNormal" align="center" style="text-align:center">
</td>
</tr>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<p class="MsoNormal" align="center" style="text-align:center">
</td>
</tr>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<p class="MsoNormal" align="center" style="text-align:center">
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12.0pt;fo
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="border:none;border-
<p class="MsoNormal"><b><span
to whom it is addressed. If you received this email in error, please notify the sender, do not disclose its contents to others and delete from your system.
</span></b><b><span style="font-size:12.0pt;fo
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12.0pt;fo
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p>&nb
</div>
</body>
</html>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
</tr>
</table>
</body>
</html>
Not sure what you mean by using the URL Encode.
I've shown you the code to save your HTML into a database using PHP. How are you planning on getting the HTML from the email into your PHP script ??
I've shown you the code to save your HTML into a database using PHP. How are you planning on getting the HTML from the email into your PHP script ??