PHP preg-replace bbcodes

Question

Please am creating a wap forum and I want the admin to be able to add bbcodes from database named mycodes with columns: id, name, code, html

Row1
Name: bold
Code: \[b\](.*?)\[/b]
Html: < b >$1< / b >

Row2
Name: undaline
Code: \[u\](.*?)\[/u]
Html: < u >$1< / u >

When I use preg replace it worked only when I have one row, if I have more than one it won't work, it would only parse bold but not underline?

function myparse($text){
  $q = mysql_query("SELECT * FROM mycodes");
  while($row = mysql_fetch_array($q)) {
    $code=$row['code'];
    $html=$row['html']
    $Result=preg_replace('#'.$code.'#is', $html, $text);
    return $result;
  }
}

myparse("hey am [b]bold[/b] but he is [u]undalined[/u]");

Where does `$row` come from? If you want to apply multiple expressions I would expect to see a loop of some kind. — Ja͢ck, Oct 24 '12 at 10:07

score 1 · Answer 1 · answered Oct 24 '12 at 10:09

1

Why re-invent the wheel:

http://www.christian-seiler.de/projekte/php/bbcode/index_en.html (also has links to some alternatives)

Or even the PECL lib: http://uk1.php.net/manual/en/book.bbcode.php

answered Oct 24 '12 at 10:09

Brian

8,418
2
25
32

score 0 · Answer 2 · answered Oct 24 '12 at 10:11

I don't see anything in your myparse function that loops through your rows of codes. So based on your current code you'll need a loop to call preg_replace multiple times:

function myparse($text){
    // Loop through rows (this might be a database or whatever stores your rows.
    // Since your code doesn't tell us I'll assume it's an array for now
    foreach ($rows as $row) {
        $code=$row['code'];
        $html=$row['html'];
        $Result=preg_replace('#'.$code.'#is', $html, $text);
    }
}

score 0 · Answer 3 · answered Oct 24 '12 at 10:36

You have couple of errors in your code. Correct function should be like this:

function myparse($text){
    $q = mysql_query("SELECT * FROM mycodes");
    while($row = mysql_fetch_array($q)) {
        $code=$row['code'];
        $html=$row['html']
        $text=preg_replace('#'.$code.'#is', $html, $text);
    }
    return $text;
}

In your code - only first line in mycodes is actually used.

PHP preg-replace bbcodes

3 Answers3

Linked