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 C9CE1CCE79 for ; Sat, 19 Jul 2003 02:15:38 +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 38029-06 for ; Sat, 19 Jul 2003 02:15:46 +0000 (GMT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 45C4BCB576 for ; Fri, 18 Jul 2003 23:15:16 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 9A3ED1024D; Fri, 18 Jul 2003 22:08:54 -0400 (EDT) Received: from [192.168.1.200] (dyn-136-14.tor.dsl.tht.net [134.22.136.14]) by mailav.tor1.inquent.com (Postfix) with ESMTP id F34F910248; Fri, 18 Jul 2003 22:08:51 -0400 (EDT) Subject: Re: postgreSQL web form; Security From: Rod Taylor To: Davi Leal Cc: pgsql-php@postgresql.org, web-dev@gnuherds.org In-Reply-To: <200307142110.14069.davileal@terra.es> References: <200307132144.02772.davileal@terra.es> <20030713200102.GA15127@wilbur.25thandClement.com> <200307142110.14069.davileal@terra.es> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-K8VHNP3H74C6iEPzGp4n" Message-Id: <1058580984.55079.10.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 18 Jul 2003 22:16:25 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/37 X-Sequence-Number: 2149 --=-K8VHNP3H74C6iEPzGp4n Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > How can we avoid this security risk using PHP & postgreSQL?. Be sure to verify all input from the untrusted source is valid, and after you do that, be sure to escape it using pg_escape_string() or pg_escape_bytea(). --=-K8VHNP3H74C6iEPzGp4n Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA/GKn46DETLow6vwwRAlRDAJ9iPYzzIiKMA8RochASOTmDHoicowCfVR4a uasEMJ4jd2y3FTQqytdvFgQ= =9cYc -----END PGP SIGNATURE----- --=-K8VHNP3H74C6iEPzGp4n--