Re: [PHP-DB] SQL Injection

[email protected] (Ruprecht Helms) Fri, 15 May 2015 18:16:09 +0200
Newsgroups php.db
Message-ID <[email protected]>

On 15.05.2015 07:21, Karl DeSaulniers wrote:
> On May 14, 2015, at 11:11 PM, Onatawahtaw <[email protected]> wrote:
>
>> Hi Karl,
>>
>> If you look at the link you provided you'll notice that some of the code is for ASP.net and some is for PHP.

I have looked in the link. Most problems by inject an sql-Code is to add 
something in the where-clause let it end with a semicolon and add an 
additional sql-command behind the semicolon. In this case you have two 
SQL-Command. The first maybe a Select-Command and the next can be to 
drop a whole table with all its content.

One thing you can do is to trim the Select-Statement and trough all 
behind a semicolon in addition the semicolon away.

Another securitymethod of mysql that the fieldvarables are capseled by 
escaping. So mysql get note that this is a variable content for a 
formfield and should looked like that.

Regards,
Ruprecht