Connecting Tech Pros Worldwide Help | Site Map

Still experiencing mysql_real_escape_string difficulties.

  #1  
Old November 9th, 2005, 06:25 PM
frizzle
Guest
 
Posts: n/a
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.

  #2  
Old November 9th, 2005, 07:05 PM
Andy Hassall
Guest
 
Posts: n/a

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Still experiencing mysql_real_escape_string difficulties. frizzle answers 0 November 9th, 2005 06:25 PM