October 23rd, 2009, 01:27 PM
|
|
Contributing User
|
|
Join Date: Jul 2008
Location: Cleveland, Ohio, USA
Posts: 411
Time spent in forums: 4 Days 18 h 54 m 24 sec
Reputation Power: 2
|
|
|
Pasting into TinyMCE
Not sure if this will turn out to be a client side issue (within TinyMCE) or if I need to do something special in PHP to fix this
I'm trying to copy an email, paste it into TinyMCE, and then submit it to a MySQL DB.
Example email after being pasted into TinyMCE (source code according to TinyMCE's 'HTML' button):
PHP Code:
<p>Message. Blah blah blah</p>
<p> </p>
<p>Thanks,</p>
<p> </p>
<p>Jim Smith</p>
<p>Tech Support</p>
<p>Company & Associates</p>
<p>555-555-5555</p>
<p> </p>
<p><strong>From:</strong> Tommy [mailto:tommy@email.com] <br /> <strong>Sent:</strong> Monday, October 05, 2009 8:57 AM<br /> <strong>To:</strong> Jim<br /> <strong>Subject:</strong> RE: Subject of email</p>
<p> </p>
<p>Jim-</p>
<p> </p>
<p>How about tomorrow?</p>
<p> </p>
<p>Thank you.</p>
<p> </p>
<p>-Tommy</p>
<p> </p>
<hr size="2" />
<p><strong>From:</strong> Jim [mailto:jim@email.com] <br /> <strong>Sent:</strong> Saturday, October 03, 2009 12:42 PM<br /> <strong>To:</strong> Tommy<br /> <strong>Subject:</strong> Subject of email</p>
<p> </p>
<p>Tommy,</p>
<p> </p>
<p>Blah Blah Blah message message message blah.</p>
<p> </p>
<p>Thanks,</p>
<p> </p>
<p>Jim Smith</p>
<p>Tech Support</p>
<p>Company & Associates</p>
<p>555-555-5555</p>
PHP/MySQL code to insert into DB:
PHP Code:
$insert_sql="INSERT INTO tbl1 (
comments,
added_date,
added_by,
parent_node
)
values(
'".mysql_real_escape_string($_POST['notes'])."',
FROM_UNIXTIME(".$timestamp."),
'".$_SESSION['csv_username']."',
'".mysql_real_escape_string($_POST['parent_node'])."'
)";
After running through this code, this is what is stored in the DB for the record in the comments column:
Any ideas on what the problem could be?
__________________
Sir, a desire of knowledge is the natural feeling of mankind; and every human being, whose mind is not debauched, will be willing to give all that he has to get knowledge.
Last edited by jamestrowbridge : October 23rd, 2009 at 01:29 PM.
|
Codewalkers Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
