Escaping metacharacters

Поиск
Список
Период
Сортировка
Искать
От
DarkSamurai
Тема
Escaping metacharacters
Дата
Msg-id
Y9DJc.619$ZD81.585@news04.bloor.is.net.cable.rogers.com
Список
Дерево обсуждения
Escaping metacharacters DarkSamurai <julio@invlaid.linux.net>
Re: Escaping metacharacters Oliver Elphick <olly@lfix.co.uk>
Re: Escaping metacharacters Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Escaping metacharacters Greg Stark <gsstark@mit.edu>
Hi,

To prevent SQL injections, I try to neutralize SQL metacharacters.

ex:

Code:


> function SQLString($s) {
>     $s = str_replace("'", "\\s", $s)'
>     $s = str_replace("\\", "\\\\", $s);
>     return "'" . $s . "'";



And suppose I use this :

> $cat = $GET["category"];
> $query = " SELECT Id, Title, Abstract FROM News " . "Where Category=" . $cat;




If a malicious user tries to input
1' UNION SELECT 1, Usr, Pass FROM Usr

it would just pass as plain text like 1 \' UNION SELECT 1, Usr, Pass 
FROM Usr

[edit]
And if he tried 1\' UNION (...) it would pass 1\\\' UNION (...) to the 
database server.
[/edit]

Is that safe from SQL injection?

В списке pgsql-hackers по дате отправления
От: Christopher Browne
Дата:
Сообщение: Re: Release planning
От: Marc G. Fournier
Дата:
FAQ