Storing HTML in a DB field...
| From: | Jonathan Villa | Date: | Mon, 28 Apr 2003 20:57:29 +0000 |
| Subject: | Storing HTML in a DB field... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27419@lists.php.net to get a copy of this message | ||
I know I have seen this before, but can't remember and am hard pressed
for time.
I have an app which wrote a bunch of HTML (tables, style definitions,
etc) to a file and then it was displayed later. Well now, instead of
saving it to a file, I want to store it in MySQL. It keeps failing. Do
I need to do anything special before I insert it?
Right now, my query looks like this:
$sql = "INSERT INTO orders SET user_id = ".$_POST['user_id'].", order =
'".$WRITE_TO_FILE."'";
Where WRITE_TO_FILE is a var which has all the data via
$WRITE_TO_FILE .= "blah blah";
$WRITE_TO_FILE .= "blah blah";
$WRITE_TO_FILE .= "blah blah";
$WRITE_TO_FILE .= "blah blah";