X-Original-To: pgsql-php-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B4BC79FB1E1 for ; Tue, 11 Jul 2006 15:14:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 96862-08 for ; Tue, 11 Jul 2006 15:14:17 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.177]) by postgresql.org (Postfix) with ESMTP id 9BC379FB1DE for ; Tue, 11 Jul 2006 15:14:17 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id b36so3972479pyb for ; Tue, 11 Jul 2006 11:14:16 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ddh8VdHX0KHPrsXKVEkMcgPHLwQcXxyYR2eefJl/CHI3qXl+uk0PH3dey4vjnLBw6cFsMP9IRSKpdnelYnO7Je+OE1Dq49Ya4Vi1pbFI32CnriBkb4/E0P3gbQ3Hy/a1GpkyKV/sqp9pQaLC06J9/X5o6/OYlnWV7P/aMfJtInY= Received: by 10.35.85.1 with SMTP id n1mr6940706pyl; Tue, 11 Jul 2006 10:49:52 -0700 (PDT) Received: by 10.35.68.16 with HTTP; Tue, 11 Jul 2006 10:49:52 -0700 (PDT) Message-ID: <5887d1f40607111049i545d7207u284ed61b5934b31d@mail.gmail.com> Date: Tue, 11 Jul 2006 13:49:52 -0400 From: DCarrero To: "John DeSoi" Subject: Re: entrance from php to postgresql Cc: pgsql-php@postgresql.org In-Reply-To: <7EFA12A7-3CC7-49CC-AF2C-6AC681B33F7C@pgedit.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <5887d1f40607110739g6de31636n8a6a18d7159cc646@mail.gmail.com> <2D22D53B-4658-4976-B26D-41279B229350@pgedit.com> <5887d1f40607111023n6d95d0a4r8d0a2658800bd2ef@mail.gmail.com> <7EFA12A7-3CC7-49CC-AF2C-6AC681B33F7C@pgedit.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/5 X-Sequence-Number: 3559 2006/7/11, John DeSoi : > > On Jul 11, 2006, at 1:23 PM, DCarrero wrote: > > > I was asking if this useful, or secure to do a transaction on web, or > > you recomend use a function with parameters an inside this insert > > data, thank for the information too... > > If you are inserting user entered data (especially from the web) I > highly recommend you use prepared statements. This will deal with > security issues related to SQL injection. I prefer to use functions, > but it is not necessary. Here is a short article I wrote which you > might find helpful in using prepared statements from PHP: > > http://pgedit.com/resource/php/pgfuncall Thanks again :D