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?