ereg_replace() BB -> HTML

[Kudose]

In thoery, would this work?

<form name="eventadd" method="post" action="eventadd.php">

<textarea name="lineup" cols="50" id="lineup" scroll="no" style="background-color: transparent"></textarea>

<input type="submit" value="Post Event">

</form>

<input value="red" type="button" onclick="eventadd.lineup.value=eventadd.lineup.value + '[ color=red ][ /color ]'">

I know the above code works, now here is where I am not sure, above we send the data to eventadd.php, without the spaces in the [ ] of course 🙂

$query = mysql_query("INSERT INTO events (lineup)
VALUES ('$lineup')");

ereg_replace('[ color=red ]', '<font color=red>', $query);
ereg_replace('[ /color ]', '</font>', $query);
ereg_replace('\n', '<br>', $query);

mysql_query($query);

Would this convert my bb code to HTML tages properly?

Thank you everyone that provides me with information, in advance. 🙂

[Kudose]

Anyone know anything about this?

[Kudose]

Am I doing something right or wrong. Anybody? Please.

[BeatOne]

I don´t use SQL databases, however, I use your method for bbcodes, so I think it sould work.
(99% sure)
BTW, I am new here, Thanks for any happy comments! 🙂

[xblue]

I'd suggest removing the first call to mysql_query() since you probably want to make these changes before inserting. then, you need to modify the input you receive ($lineup). also, str_replace() is enough, and saves you from escaping square brackets.

$lineup = str_replace('[ color=red ]', '<font color=red>', $lineup);

EDIT: Oh, and Hi BeatOne! I hope you will like this place as much as I do.

[Kudose]

So I need to move this above the $query, and could I add as many ereg_replace()'s as I need to $lineup?

(i.e. one for color=red, one for \n, one for [/color], etc...)

Without it hurting the text entered in lineup textarea?

[xblue]

yes, you can do as many manipulations to the string as you like before saving it to the database.

btw, I saw the same post in another forum, could you try to avoid cross-posting? It's just getting messy when you receive one advice here and the other there, and in the end nobody will know what your code actually looks like currently and what the problem is.

[martyn]

You may also want to consider running the phraser when it comes to showing the page. Then you can change your mind as to whether colours are allowed, etc.

It does put more load onto the server if the text blocks are big, but it all depends on what you want to use it for...