I am running into a problem where as I want to store test form a text field
to a database (MySql in this case, sql type text).
Apparently, if people are cutting and
pasting text from another document (typically MS WORD) into the textfield,
the text gets only partially saved. I am assuming wierd
.
-Original Message-
From: Roger Spears [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 3:41 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Text corruption when storing to MySql
I missed a variable in my previous postshould have been this:
$submitted_text = $_POST
I am running into a problem where as I want to store test form a text field
to a database (MySql in this case, sql type text).
Apparently, if people are cutting and
pasting text from another document (typically MS WORD) into the textfield,
the text gets only partially saved. I am assuming wierd
check both single and double quotes replace them with ('') and ()
respectively, try mysql_real_escape_string() functions
bastien
From: Gaby T. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Text corruption when storing to MySql
Date: Wed, 20 Oct 2004 12:49:51 -0700
I am running
Gaby T. wrote:
I am running into a problem where as I want to store test form a text field
to a database (MySql in this case, sql type text).
Apparently, if people are cutting and
pasting text from another document (typically MS WORD) into the textfield,
the text gets only partially saved. I am
I missed a variable in my previous postshould have been this:
$submitted_text = $_POST['textFromForm'];
function clean_ms_word($submitted_text)
{
$crap =
