Connecting Tech Pros Worldwide Help | Site Map

Still experiencing mysql_real_escape_string difficulties.

frizzle
Guest
 
Posts: n/a
#1: Nov 9 '05
Hi there,

I had another topic about this problem, and i thought i figured it
out, but i didn't :(


I tested inserting the following text:
'"\ (single quote, double quote, backslash)

Via PHP:
$new_var = mysql_real_escape_string($_POST['var']);
$put_info = mysql_query(" INSERT INTO `test` ( `id` , `text` )
VALUES ('', '".$new_var."');");

And via phpMyAdmin.
If i view the first raw data , i see the following:
\'\"\\

If i view the text inserted via phpMyAdmin, i see
'"\ (the way it should be)

What am i still missing? :s

Greetings Frizzle.

Andy Hassall
Guest
 
Posts: n/a
#2: Nov 9 '05

re: Still experiencing mysql_real_escape_string difficulties.


On 9 Nov 2005 10:17:25 -0800, "frizzle" <phpfrizzle@gmail.com> wrote:
[color=blue]
>I had another topic about this problem, and i thought i figured it
>out, but i didn't :([/color]

Why repost it then? You only posted an identical message to this one to that
thread yesterday.
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Closed Thread