Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:123266
Feedback-ID: i6f4c46c2:Fastmail
Message-ID: <cc9412fc-f42f-40a6-afe2-28ef3f848ae1@beccati.com>
Date: Fri, 3 May 2024 20:46:59 +0200
Precedence: bulk
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: [PHP-DEV] Inconsistencies between parameter number and index when
 reflecting a method/function
To: Hans Henrik Bergan <divinity76@gmail.com>, internals@lists.php.net
Cc: "Gina P. Banyard" <internals@gpb.moe>, Derick Rethans <derick@php.net>
References: <88ea5de8-22ea-4c23-b570-229acd546c10@app.fastmail.com>
 <28215C90-191D-4159-9C47-86D03B9A683D@php.net>
 <63GXg3pF4DIRrXn-zuvO46emeZTrmkMOuiLUFwDA18PdV0y8BNqFvwidOxktGf3Z8geBiwCksbQ-Jpzg9OaxPv6VxDJRDkWCE5S2kabhmF4=@gpb.moe>
 <5b7ac8bb-6f88-a7e2-ac7e-f57b0970a5ba@php.net>
 <CAJmy8YE_n5AhnETBRO4iB=yRRvcEffhevDBU=PVk0nL1P++hSw@mail.gmail.com>
Content-Language: en-GB
In-Reply-To: <CAJmy8YE_n5AhnETBRO4iB=yRRvcEffhevDBU=PVk0nL1P++hSw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
From: php@beccati.com (Matteo Beccati)

Hi,

Il 03/05/2024 17:53, Hans Henrik Bergan ha scritto:
> On Fri, 3 May 2024 at 17:49, Derick Rethans <derick@php.net> wrote:
>>
>> Which *API* in PHP is 1-indexed?
>>
>> cheers,
>> Derick
> 
> Certainly isn't normal but found 1 (and only 1!):
> 
> $stmt = $pdo->prepare('SELECT name FROM users WHERE id = ?');
> $stmt->bindParam(1, $id);

I suppose numbering is derived from external (database) standards. E.g. 
Postgres uses $1, $2, etc. as parameter placeholders.

Also it is in turn is inconsistent with:

$stmt = $pdo->prepare('SELECT name FROM users WHERE id = ?');
$stmt->execute([$id]);

That said, 0-indexed for the reflection PR seems the best choice to me too.


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/