List:General Discussion« Previous MessageNext Message »
From: Date:January 1 1970 12:00am
Subject:Re: HTML in MySQL?
Date: Sun, 11 Sep 2005 23:15:39 +0400
View as plain text  
Hello!

> But once you have done that, you can never recover the origional text.
> Try it on this email if you doubt it.

Why? Why not to use regular expressions?

> Use addslashes($htmlCode) and execute query normally. 
> $slashedHtmlCode = addslashes($htmlCode);

The problem is not in the executing of a query.

After the execution of the script:

<?php
$string = "\n\n\n\n 1";
echo addslashes($string);
?>

we will get:

1

and no empty lines.

If you want to output the same data, that was written using a textarea field 
of a form, you should use the "<br>" tag.

-- 
Good Luck!
Vladimir

Please, avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
Thread
HTML in MySQL?clint lenard9 Sep
  • Re: HTML in MySQL?Jasper Bryant-Greene9 Sep
    • Re: HTML in MySQL?clint lenard9 Sep
      • Re: HTML in MySQL?Jasper Bryant-Greene9 Sep
        • Re: HTML in MySQL?clint lenard9 Sep
  • Re: HTML in MySQL?douglass_davis12 Sep
    • Re: HTML in MySQL?clint lenard12 Sep
      • Re: HTML in MySQL?clint lenard12 Sep
        • Re: HTML in MySQL?clint lenard12 Sep
          • Re: HTML in MySQL?Hassan Schroeder12 Sep
RE: HTML in MySQL?SST - Adelaide)9 Sep
Re: HTML in MySQL?Unknown Sender9 Sep
Re: HTML in MySQL?Unknown Sender9 Sep
RE: HTML in MySQL?Alan Williamson9 Sep
  • Re: HTML in MySQL?Unknown Sender9 Sep
    • Re: HTML in MySQL?gerald_clark9 Sep
    • Re: HTML in MySQL?Filipe Tomita9 Sep
  • Re: HTML in MySQL?Unknown Sender9 Sep
RE: HTML in MySQL?John Trammell9 Sep
Re: HTML in MySQL?Unknown Sender11 Sep
  • Re: HTML in MySQL?Roger Baklund11 Sep
Re: HTML in MySQL?Unknown Sender11 Sep
RE: HTML in MySQL?John Trammell11 Sep
  • Re: HTML in MySQL?Jasper Bryant-Greene12 Sep
    • Re: HTML in MySQL?Jasper Bryant-Greene12 Sep
      • Re: HTML in MySQL?clint lenard12 Sep