Ad:

MySQL Discussion Thread
Unsolved
Views: 15811

Sep 14th, 2007

store HTML is a text field in a table on a MySQL Database

Expand Post »

I am emailing a field from a MySQL DB table. The field type is text. Basically, it is an accept email. How can I make it so the email sent is capable of emailing HTML to make the message more attractive?

I have already tried to insert < html > into the text field, but that doesn't work....The received email, just diplays the text < html > and then the rest of the text.
ANy suggestions?

Similar Threads

woocha

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

48 posts
since Dec 2006

Permalink

Sep 14th, 2007

Re: store HTML is a text field in a table on a MySQL Database

The problem was in the PHP code...I needed to add a few steps that were missing the code went from:

MySQL Syntax (Toggle Plain Text)
 
if ($action == "decline")
{
$query = "delete from orders where id=$id and merchant=$merchant";
mysql_query( $query);
 
if ($sendemail == "yes") 
{
 
  mail("\"$name\" <$email>", 
     "Your order has been declined!", 
     stripslashes($r['emaildecline']),
      "From: \"".$r['company_name']."\" <".$r['email'].">\nReply-To: ".$r['email']); 
}
}
 
if ($action == "decline")
{
$query = "delete from orders where id=$id and merchant=$merchant";
mysql_query( $query);

if ($sendemail == "yes") 
{

  mail("\"$name\" <$email>", 
     "Your order has been declined!", 
     stripslashes($r['emaildecline']),
      "From: \"".$r['company_name']."\" <".$r['email'].">\nReply-To: ".$r['email']); 
}
}

to:

MySQL Syntax (Toggle Plain Text)
$company_name = $r['company_name'];
$company_email = $r['email']; 
if ($action == "decline")
{
 $query = "delete from orders where id=$id and merchant=$merchant";
 mysql_query( $query);
$message = stripslashes($r['emaildecline']);
 
$headers  = "MIME-Version: 1.0 \r\n" .
            "Content-type: text/html; charset=iso-8859-1\r\n" .
            "From: $company_name <$company_email>\r\n" .
            "Reply-To: $company_email"; 
if ($sendemail == "yes") 
{
  mail("\"$name\" <$email>", 
     "Your order has been declined!", 
     $message,
      $headers); 
}
}
$company_name = $r['company_name'];
$company_email = $r['email']; 
if ($action == "decline")
{
 $query = "delete from orders where id=$id and merchant=$merchant";
 mysql_query( $query);
$message = stripslashes($r['emaildecline']);

$headers  = "MIME-Version: 1.0 \r\n" .
            "Content-type: text/html; charset=iso-8859-1\r\n" .
            "From: $company_name <$company_email>\r\n" .
            "Reply-To: $company_email"; 
if ($sendemail == "yes") 
{
  mail("\"$name\" <$email>", 
     "Your order has been declined!", 
     $message,
      $headers); 
}
}

I am only posting this so other people can fix this problem without having to go through what I went throuygh....If you have any questions, reply to this thread

woocha

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

48 posts
since Dec 2006

Permalink

Mar 5th, 2008

Re: store HTML is a text field in a table on a MySQL Database

ummm this is sorta something like this - i think.

Wat I am doing is creating a div overlay website- which basically i am putting the layout code into the mysql database... There are two parts to the code

the about me part which is basically the css of the layout

And the who i'd like to meet part - which is the html code.

My problem is - that i have a php file and to print this code as text - i have used a textarea box - because i need the code to come up into two different text area boxes that way when users click on - it just automatically copies.

My problem is - is that the 2nd set of code which is the html stuff - is printing half of it as text into the box - but the other half the web browser is literally taking as code... so wat do i do? - Do you know what is wrong with it???

Here is my site to see what i am talking about-

http://mydivspot.com/plaincart/index.php?c=24&p=15

Thank you

sandy

myluvstefan

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Mar 2008

Permalink

Mar 5th, 2008

Re: store HTML is a text field in a table on a MySQL Database

Use PHP's htmlspecialchars() function to output the HTML as text. e.g.

MySQL Syntax (Toggle Plain Text)
echo htmlspecialchars("<html></html>");
echo htmlspecialchars("<html></html>");

mwasif

Reputation Points: 29

Solved Threads: 47

Posting Whiz

Offline

312 posts
since Dec 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: database query limitations

Next Thread in MySQL Forum Timeline: Myisam and InnoDB

DaniWeb Message

Cancel Changes

User Name
Password