Re: Re: mysql query

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


Ethan Rosenberg wrote:
I'm probably wrong, but in some contexts; eg, sql query, $ signs are not used.
I tried and added the incorrect $ sign, and Netbeans did not complain.  If
anyone knows of an editor that will able to spot this kind of error, please
inform the list.

You do need to take a little more care when using variables IN strings and watch that they are highlighted. As you say, the parsing is not actually wrong as it is valid 'text' and adding SQL parsers for every database is not really practical and probably would not fix the problem anyway? Personally I use Firebird, and have always built the SQL using parameters, so that the SQL is pure text, and values are passed in an array. This is something MySQL was a lot later in catching onto, but many of the simple security problems are totally eliminated using that approach.

Lester Caine - G8HFL
Contact -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Rainbow Digital Media -

PHP Database Mailing List (
To unsubscribe, visit:

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux