MySQL RSS MySQL RSS

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

Reply

•
•
Join Date: Dec 2006
Posts: 48
Reputation: woocha is an unknown quantity at this point 
Solved Threads: 0
woocha's Avatar
woocha woocha is offline Offline
Light Poster

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

 
0
  #1
Sep 14th, 2007
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?
FREE Online Auctions At:
http://www.woocha.com/auctions
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2006
Posts: 48
Reputation: woocha is an unknown quantity at this point 
Solved Threads: 0
woocha's Avatar
woocha woocha is offline Offline
Light Poster

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

 
0
  #2
Sep 14th, 2007
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) 
  1.  
  2. if ($action == "decline")
  3. {
  4. $query = "delete from orders where id=$id and merchant=$merchant";
  5. mysql_query( $query);
  6.  
  7. if ($sendemail == "yes") 
  8. {
  9.  
  10.   mail("\"$name\" <$email>", 
  11.      "Your order has been declined!", 
  12.      stripslashes($r['emaildecline']),
  13.       "From: \"".$r['company_name']."\" <".$r['email'].">\nReply-To: ".$r['email']); 
  14. }
  15. }

to:
MySQL Syntax (Toggle Plain Text) 
  1. $company_name = $r['company_name'];
  2. $company_email = $r['email']; 
  3. if ($action == "decline")
  4. {
  5.  $query = "delete from orders where id=$id and merchant=$merchant";
  6.  mysql_query( $query);
  7. $message = stripslashes($r['emaildecline']);
  8.  
  9. $headers  = "MIME-Version: 1.0 \r\n" .
  10.             "Content-type: text/html; charset=iso-8859-1\r\n" .
  11.             "From: $company_name <$company_email>\r\n" .
  12.             "Reply-To: $company_email"; 
  13. if ($sendemail == "yes") 
  14. {
  15.   mail("\"$name\" <$email>", 
  16.      "Your order has been declined!", 
  17.      $message,
  18.       $headers); 
  19. }
  20. }

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
FREE Online Auctions At:
http://www.woocha.com/auctions
Reply With Quote Quick reply to this message  
•
•
Join Date: Mar 2008
Posts: 1
Reputation: myluvstefan is an unknown quantity at this point 
Solved Threads: 0
myluvstefan myluvstefan is offline Offline
Newbie Poster

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

 
0
  #3
Mar 5th, 2008
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
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2007
Posts: 190
Reputation: mwasif is an unknown quantity at this point 
Solved Threads: 25
mwasif mwasif is offline Offline
Junior Poster

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

 
0
  #4
Mar 5th, 2008
Use PHP's htmlspecialchars() function to output the HTML as text. e.g.

MySQL Syntax (Toggle Plain Text) 
  1. echo htmlspecialchars("<html></html>");
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the MySQL Forum
Thread Tools Search this Thread



agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright court crm database design developer development distinct dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux maintenance managing mariadb matchingcolumns metron microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC