Re: Using mysql_real_escape_string without connecting to mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 23/01/2008, Eric Butera <eric.butera@xxxxxxxxx> wrote:> On Jan 22, 2008 8:01 PM, Dotan Cohen <dotancohen@xxxxxxxxx> wrote:> > I have a file of my own functions that I include in many places. One> > of them uses mysql_real_escape_string, however, it may be called in a> > context that will or will not connect to a mysql server, and worse,> > may already be connected. So I must avoid connecting. However, when I> > run the script without connecting I get this error:> >> > Warning: mysql_real_escape_string()> > [function.mysql-real-escape-string]: Access denied for user:> > 'nobody@localhost' (Using password: NO)> >> > I was thinking about checking if there is a connection, and if not> > then connecting. This seems redundant to me, however. What is the> > list's opinion of this situation? Thanks in advance.> >> > Dotan Cohen> >> > http://what-is-what.com> > http://gibberish.co.il> > א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת> >> > A: Because it messes up the order in which people normally read text.> > Q: Why is top-posting such a bad thing?> >>> By not connecting to the server you don't have the correct context for> using mysql real escape string, therefore it is pointless.>
Yes, I realize this. Note that I _always_ connect via UTF-8, so I'dlike to tell mysql_real_escape_string to do it's magic as if I wereconnected via UTF-8. I realize that this is impossible.
However, I do not think that the script should throw an error until Iactually call mysql_clean. Merely having it in an include should notthrow an error if the function is not being used.
Dotan Cohen
http://what-is-what.comhttp://gibberish.co.ilא-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת;
A: Because it messes up the order in which people normally read text.Q: Why is top-posting such a bad thing?

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux