X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id 272D3CCF06 for ; Sat, 19 Jul 2003 11:07:04 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 01444-02 for ; Sat, 19 Jul 2003 11:07:24 +0000 (GMT) Received: from mwinf0203.wanadoo.fr (smtp7.wanadoo.fr [193.252.22.29]) by svr1.postgresql.org (Postfix) with ESMTP id E66D3CB576 for ; Sat, 19 Jul 2003 08:06:51 -0300 (ADT) Received: from michelle2.michelle-is.com (Mix-Strasbourg-107-2-131.w193-250.abo.wanadoo.fr [193.250.15.131]) by mwinf0203.wanadoo.fr (SMTP Server) with SMTP id 8D6CE100016D for ; Sat, 19 Jul 2003 13:07:25 +0200 (CEST) Message-Id: <3.0.6.16.20030719130632.0bf78806@pop3.01019freenet.de> X-Disclaimer: Eine weitere Verwendung oder die Veroeffentlichung X-Disclaimer: dieser Mail oder dieser Mailadresse ist nur mit der X-Disclaimer: Einwilligung des Autors gestattet. X-Sender: linux2.mailinglists@pop3.01019freenet.de X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.6 (16) Date: Sat, 19 Jul 2003 13:06:32 +0200 To: pgsql-php@postgresql.org From: Michelle Konzack Subject: Re: postgreSQL web form; Security In-Reply-To: <001d01c34dd3$2fdf08d0$926bd9d9@clairvo> References: <200307132144.02772.davileal@terra.es> <20030713200102.GA15127@wilbur.25thandClement.com> <200307142110.14069.davileal@terra.es> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/39 X-Sequence-Number: 2151 Hello Adrian, Am 10:53 2003-07-19 +0200 hat Adrian Tineo geschrieben: >What I do is verify all user input ($_GET and $_POST array) and not allow >certain characters, most importantly ";". If they can't put a ";" they can't >close a query and they can't do SQL injection. How do you do that ? With a Java-Script in the WebPage ? or On the Server-Side ? I think, we must use all two, the first one to prevent to much work on the Server-Side and the second one if someone hack the input field or use Commandline to access the URL. Hmm, have no clue how to check it with Java-Script... Does anyone have a small GPL'ed code for it ? (I do not code Java-Script) Thanks Michelle