Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:107858
MIME-Version: 1.0
References: <MN2PR18MB25894DE93EF773D3CF05B28AED4A0@MN2PR18MB2589.namprd18.prod.outlook.com>
In-Reply-To: <MN2PR18MB25894DE93EF773D3CF05B28AED4A0@MN2PR18MB2589.namprd18.prod.outlook.com>
Date: Tue, 26 Nov 2019 01:41:05 +0200
Message-ID: <CA+hqhpe82W-VN9-vRdPxL4hvnEn5buVhBW8hHAA2XaDffuBsTA@mail.gmail.com>
To: Joel Hutchinson <Joel.Hutchinson@onlinecommercegroup.com>
Cc: "internals@lists.php.net" <internals@lists.php.net>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Subject: Re: [PHP-DEV] mysqli needs a method to bind a single parameter
From: weirdan@gmail.com (Bruce Weirdan)

On Mon, Nov 25, 2019 at 8:06 PM Joel Hutchinson
<Joel.Hutchinson@onlinecommercegroup.com> wrote:

> This proposal would leave the previous mysqli_stmt_bind_param mostly unto=
uched. Instead, the two could be used in tandem
> $sql =3D 'SELECT name FROM db.customer WHERE record_id =3D ? AND shipping=
_zip =3D ?';
> if(isset($_GET['zip'])) $sql .=3D ' AND billing_zip =3D ?';
>
> $stmt =3D $db->prepare($sql);
> $stmt->bind_param('is', $_GET['record_id'], $_GET['shipping_zip']);
> if(isset($_GET['zip'])) $stmt->bind_single('s', $_GET['billing_zip'], 3);
> $stmt->execute();
> This necessitates a small change to mysqli_stmt_bind_param, in that the c=
urrent function has a parameter check to ensure that the number of binds ma=
tches the number of parameters in the query (or else it emits an E_WARNING)=
. That check would have to move to mysqli_stmt_execute, if it is still to b=
e performed.

If `bind_param` is allowed to do incomplete bind (as in your example
where you supply 2 out of 3 required bound parameters) t
hen there's no need for additional method, as you could simply do:

  if (isset($_GET['zip'])) $stmt->bind_param('s', $_GET['zip']);


--=20
  Best regards,
      Bruce Weirdan                                     mailto:weirdan@gmai=
l.com