PHP - Preg_replace Html Formatting

Hi There,

In some of my forms, I am using <textarea> boxes in order for lot's of information to be entered. When submitted, these forms pump data into a database. Is there any way of carrying through the carriage returns with the form? So that when it is displayed back on the page, it looks exactly how it was entered.

For example, if someone puts the following in the text box:

Hello,

This is line 1
This is line 2

This is how I would like it to be displayed

Thanks
Matt

I have a function that removes html, javascript and php from a text box that users of my site can write in.  The problem is when a user types
say;

hello.  My name is Danny


And I love php freaks

into my text box.  Its also removing the new line entry's. I would very much stop to stop it doing that so it looks like I have paragraphs.  Can someone please help me.  Here is how I call the function.

 $description = strip_word_html($_POST['description'], $allowed_tags = '<b><i><sup><sub><em><strong><u><br><br/><br />'); 

And the function itself with notes.


//remove html java and php
function strip_word_html($text, $allowed_tags = '<b><i><sup><sub><em><strong><u><br><br/><br />') 
    { 
        mb_regex_encoding('UTF-8'); 
        //replace MS special characters first 
        $search = array('/&lsquo;/u', '/&rsquo;/u', '/&ldquo;/u', '/&rdquo;/u', '/&mdash;/u'); 
        $replace = array('\'', '\'', '"', '"', '-'); 
        $text = preg_replace($search, $replace, $text); 
        //make sure _all_ html entities are converted to the plain ascii equivalents - it appears 
        //in some MS headers, some html entities are encoded and some aren't 
        $text = html_entity_decode($text, ENT_QUOTES, 'UTF-8'); 
        //try to strip out any C style comments first, since these, embedded in html comments, seem to 
        //prevent strip_tags from removing html comments (MS Word introduced combination) 
        if(mb_stripos($text, '/*') !== FALSE){ 
            $text = mb_eregi_replace('#/\*.*?\*/#s', '', $text, 'm'); 
        } 
        //introduce a space into any arithmetic expressions that could be caught by strip_tags so that they won't be 
        //'<1' becomes '< 1'(note: somewhat application specific) 
        $text = preg_replace(array('/<([0-9]+)/'), array('< $1'), $text); 
        $text = strip_tags($text, $allowed_tags); 
        //eliminate extraneous whitespace from start and end of line, or anywhere there are two or more spaces, convert it to one 
        $text = preg_replace(array('/^\s\s+/', '/\s\s+$/', '/\s\s+/u'), array('', '', ' '), $text); 
        //strip out inline css and simplify style tags 
        $search = array('#<(strong|b)[^>]*>(.*?)</(strong|b)>#isu', '#<(em|i)[^>]*>(.*?)</(em|i)>#isu', '#<u[^>]*>(.*?)</u>#isu'); 
        $replace = array('<b>$2</b>', '<i>$2</i>', '<u>$1</u>'); 
        $text = preg_replace($search, $replace, $text); 
        
        //some MS Style Definitions - this last bit gets rid of any leftover comments */ 
        $num_matches = preg_match_all("/\<!--/u", $text, $matches); 
        if($num_matches){ 
              $text = preg_replace('/\<!--(.)*--\>/isu', '', $text); 
        } 
        return $text; 
    } 

Hello.  I am interested in taking a result returned from a database and having it displayed in a certain way/style on the user's screen; For example, the user enters text into a field and hits "submit" - the data is saved in the database then displayed to the user (This part I have working just fine so far due to help I received here.)

My question is if I would like to, for example, have said text not simply dumped to the top of the screen, inline, but nicely formatted in a boxed, text area, I assume I will use HTML/CSS, and I was wondering if anyone had any good links/tutorials regarding this topic so I may look further into it (my search thus far has not turned up the correct topic or results).

Thank-you in advance for any assistance.
~Matty

Hi there!

I need to echo some text from a database table, this text should be linked to a url stored in the same database. I am trying to do this with preg_replace but I am terrible at it! I keep getting this error:

Warning: Wrong parameter count for preg_replace()

while($row = mysql_fetch_array( $result ))
 {

$reg_exUrl = "/(http|https|ftp|ftps)\:\/\/[a-zA-Z0-9\-\.]+\.[a-zA-Z]{2,3}(\/\S*)?/";

echo preg_replace ($reg_exUrl, $row['title');


Any suggestion?

Thanks

I'm trying to search a string for all occurences of a pattern, then append text after that pattern.  The example is:   SUM("foo") as "bar"   and have it display as:   SUM("foo") over() as "bar"   The "SUM" could be any SQL aggregate and be case insensitive.  So For bonus points, let's say the valid aggregates are  array('SUM', 'MAX', 'MIN', 'AVG').  My plan right now is to figure it out for SUM, then loop it replacing the aggregate.   This is what I have so far... and it is not working.   $l= 'SUM("foo") as "bar"'; $l=preg_replace('/([^"]+")/','\0 over()',$l);   Thanks,   Ryan