Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:25254
Return-Path: <manchokapitancho@gmail.com>
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Delivered-To: mailing list internals@lists.php.net
Received: (qmail 37388 invoked by uid 1010); 9 Aug 2006 08:25:46 -0000
Delivered-To: ezmlm-scan-internals@lists.php.net
Delivered-To: ezmlm-internals@lists.php.net
Received: (qmail 37373 invoked from network); 9 Aug 2006 08:25:46 -0000
Received: from unknown (HELO lists.php.net) (127.0.0.1)
  by localhost with SMTP; 9 Aug 2006 08:25:46 -0000
Authentication-Results: pb1.pair.com header.from=manchokapitancho@gmail.com; domainkeys=good
DomainKey-Status: good
X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01
X-PHP-List-Original-Sender: manchokapitancho@gmail.com
X-Host-Fingerprint: 64.233.182.187 nf-out-0910.google.com Linux 2.4/2.6
Received: from ([64.233.182.187:62350] helo=nf-out-0910.google.com)
	by pb1.pair.com (ecelerity 2.1.1.3 r(11751M)) with ESMTP
	id 6A/3F-13488-80C99D44 for <internals@lists.php.net>; Wed, 09 Aug 2006 04:25:46 -0400
Received: by nf-out-0910.google.com with SMTP id p48so92049nfa
        for <internals@lists.php.net>; Wed, 09 Aug 2006 01:25:42 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:mime-version:content-type;
        b=mWVze2yH39oAd0s9GpGUk36uuHqWvFeYfABmvkzpNjAwHlS7bSKU9Me4ZkyHK+ue0MwGaw44qmcZ/1uYX0ib8XGjAFT/KTUmLmK/CO0172U0QuzMqiu4TXLwOtMstP9XaXhG2GSdcy50331a847ihm8SNqvcqWmM5Z58QD3yJQc=
Received: by 10.78.127.2 with SMTP id z2mr202149huc;
        Wed, 09 Aug 2006 01:25:41 -0700 (PDT)
Received: by 10.78.169.10 with HTTP; Wed, 9 Aug 2006 01:25:41 -0700 (PDT)
Message-ID: <bec76cf90608090125m7a5dd6f4q1003722f7efd298d@mail.gmail.com>
Date: Wed, 9 Aug 2006 11:25:41 +0300
To: internals@lists.php.net
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_36586_26305470.1155111941823"
Subject: PDO statement execute enhancement
From: manchokapitancho@gmail.com ("Marian Kostadinov")

------=_Part_36586_26305470.1155111941823
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I have a suggestion that is related a little to my bug report #38394 (
http://bugs.php.net/bug.php?id=38394).

It's about the execution of a prepared statement.
Let's say we have a prepared statement for

UPDATE table SET field1 = :field1, field2 = :field3 WHERE id = :id

in order to execute it we have something like this:
$data = array ('id' => 3, 'field1' => 'value1', 'field2' => 'value2');
$stmt->execute ($data);

But I think that it is so common to have things like this
$data = array ('id' => 3, 'field1' => 'value1', 'field2' => 'value2',
'field3' => 'value3', 'field4' => 'value4');
$stmt->execute ($data);

But that is not executed because we have some additional key/value pairs.
So the idea is to allow this. Also I suggest we allow using object along
with an array. This is a common situation also.

But I have to ask you about the C implementation because it may need a lot
of rewriting about this but if it is easy, it think it may be good to be
done.

------=_Part_36586_26305470.1155111941823--