Storing php code in mysql

[Chris97b]

Hello all,

I'm writing a small forum, and I'm currently in the process of implementing BB code. I have it working well, except for the php tags. When I attempt to store the text in mysql, it tries to interpret it as a command, and errors.

For example, when I try to insert
Replace ()'s with []'s

(php)
//this
if(is=='a')
{
Test();
}
(/php)

I get the following error:

You have an error in your SQL syntax near 'a') { test(); } [/code]', '02/16/2005 04:41 PM', '41', 'test', '216.12.19' at line 1

Does anyone know of a good way to tell mysql to store it exactly as-is, rather than interpreting it as code?

Thanks,

Chris

[Weedpacket]

You'd probably want to use [man]mysql_escape_string[/man] so that the apostrophes in the text don't get interpreted as ending the field.

[Chris97b]

excellent, thanks!

I figured there was a function for that, but I couldn't seem to find it 🙂