mysql_real_escape_string()

[fer0an]

I want using this code to escape ' .

can anyone help me?

[Mchl]

What problems are you having?

[fer0an]

I use this function code to replace ' ,... from my text to add it on mysql db.

function escape($text)
        {
                $search=array("\\","\0","\n","\r","\x1a","'",'"');
                $replace=array("\\\\","\\0","\\n","\\r","\Z","\'",'\"');
                return str_replace($search,$replace,$text);
        }

 

but I recived an error : atal error: Cannot redeclare escape() (previously declared in /home/...

[Mchl]

How is that problem with mysql_real_escape_string(), and why do you want to use this function, while mysql_real_escape_string() is more versatile?

[fer0an]

I want add some text to my db that have ' same as "Unitá del 25 Luglio 2010".

But I recived an error below:

Error: exist You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Unitá del 25 Luglio 2010'' at line 1.

how I can resolve this problem?

[Mchl]

Yes, you should use mysql_real_escape_string function to escape it BEFORE putting it into your query.

[fer0an]

can you write correct code for me ?

I added $text to my db.

Is this is correct?

$text = mysql_real_escape_string(');

[trq]

Read the examples in the manual. Its not rocket science.

[Zagga]

but I recived an error : atal error: Cannot redeclare escape() (previously declared in /home/...

You are getting this error because you already have a function called "escape".

 

 

Zagga