Re: Question re: sql injection



On Jun 29, 9:47 am, Andrew Hutchings <i...@xxxxxxxxxxxx> wrote:
shimmyshack wrote:
On Jun 28, 10:28 pm, jb <jbri...@xxxxxxxxx> wrote:
does wrapping the string in double quotes somehow tell mysql to treat
the contents within as literal? Thus making it sql injection safe?

just use myql_real_escape_string throughout.

That won't cover things like unicode sql injection attacks for starters.
Prepared statements are much safer but you need mysqli on your PHP
installation (or a lot of voodoo with the standard mysql library).

--
Andrew Hutchings - LinuxJedi -http://www.linuxjedi.co.uk/
Windows is the path to the darkside...Windows leads to Blue Screen. Blue
Screen leads to downtime. Downtime leads to suffering...I sense much
Windows in you...

that's true, you do need to validate as well, didnt mean to suggest
that it is a magic bullet!

.



Relevant Pages

  • Re: Off-Topic
    ... > Bluescreen leads to downtime. ... > Downtime leads to suffering. ... > Powerful Unix is. ... > The No. 1 remote administration tool for Windows NT is a car. ...
    (freebsd-questions)
  • Re: Question re: sql injection
    ... That won't cover things like unicode sql injection attacks for starters. ... Windows is the path to the darkside...Windows leads to Blue Screen. ... Downtime leads to suffering...I sense much Windows in you... ...
    (comp.lang.php)
  • Re: Mail problem
    ... If you are running from your home IP address then there won't be much you can do to stop this as most ISPs block home IP addresses from sending mail. ... The -f flag assumes the server isn't running Windows, if it is remove that parameter from the command. ... Windows is the path to the darkside...Windows leads to Blue Screen. ... Downtime leads to suffering...I sense much Windows in you... ...
    (alt.php)
  • Re: Off-Topic
    ... Bluescreen leads to downtime. ... Downtime leads to suffering. ... Powerful Unix is. ... The No. 1 remote administration tool for Windows NT is a car. ...
    (freebsd-questions)
  • Re: Array_merge() Question
    ... recordID \t the rest of the data ... ... Windows is the path to the darkside...Windows leads to Blue Screen. ... Downtime leads to suffering...I sense much Windows in you... ...
    (comp.lang.php)