I am writing code to store a bunch of email files, in MIME format, into a
database. The body of some of these emails, but not all, are in HTML format.
If I use addslashes (after checking get_magic_quotes_gpc()), the database
record won't get saved. There's no error message, just no record saved. But
if I use htmlentities(), it saves the record no problem.
I would have thought that addslashes would have been enough to format the data
correctly. Why would I need to use htmlentities? And will using htmlentities
cause me any problems?
here's the code in question:
$from = $this->SentFrom();
$to = $this->To();
$cc = $this->Cc();
$subject = $this->Subject();
$body = htmlentities($this->Body()); // this works
//$body = $this->Body();
if (get_magic_quotes_gpc() == 0)
{
echo "<br>adding slashes...";
$body = addslashes($body); // this runs but
doesn't work
}
$sql = "insert emails(projectid, mailfrom, mailto,
mailcc, subject, body) values(1, '$from', '$to', '$cc', '$subject', \"$body\")";
echo "<br>sql:<pre><code>$sql</code></pre>";
$link = mssql_connect($server, $user, $pwd)
or die('Could not
connect: ' . mysql_error());
mssql_select_db('EmailDB') or die('Could not select
database');
try
{
$result = @mssql_query($sql);
}
catch (Exception $e)
{
echo "<br>Error: " . $e->getMessage;
}
Thanks.
Regards,
Bruce
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
