Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:114262 Return-Path: Delivered-To: mailing list internals@lists.php.net Received: (qmail 51202 invoked from network); 4 May 2021 09:57:16 -0000 Received: from unknown (HELO php-smtp4.php.net) (45.112.84.5) by pb1.pair.com with SMTP; 4 May 2021 09:57:16 -0000 Received: from php-smtp4.php.net (localhost [127.0.0.1]) by php-smtp4.php.net (Postfix) with ESMTP id DFD621804C8 for ; Tue, 4 May 2021 03:03:16 -0700 (PDT) X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on php-smtp4.php.net X-Spam-Level: X-Spam-Status: No, score=0.1 required=5.0 tests=BAYES_20,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,FREEMAIL_ENVFROM_END_DIGIT, FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,RCVD_IN_MSPIKE_H2, SPF_HELO_NONE,SPF_PASS autolearn=no autolearn_force=no version=3.4.2 X-Spam-Virus: No X-Envelope-From: Received: from mail-il1-f170.google.com (mail-il1-f170.google.com [209.85.166.170]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by php-smtp4.php.net (Postfix) with ESMTPS for ; Tue, 4 May 2021 03:03:16 -0700 (PDT) Received: by mail-il1-f170.google.com with SMTP id p15so5895735iln.3 for ; Tue, 04 May 2021 03:03:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=Ayn/bvKyXtEyJxfoisSz/U28elP+dXWyRI3eaimBfoA=; b=iedNJqxRuYMzFNPfzFgGAJCVVw6xcbek+NRzvlu96PvivGK1+aSOvNDWWu8xCF8hOM 59GIjKPUzHk8d/+Ku6CLfd0xoC4rngpb7fc6cW5//aKWW1WZAULMCqO0d12w9bp0BQca FWOa4+uzcvHvbLHDbMPLrxvgfXPQtg11/4EooKZ/osIhbouSlTStrxBDOqWijCn2DCxb hipS7Yq9ijGByvQaxu1CiuyCs79nu9AD5tuQ+dyM3ho7pqLhSFlIbJ7H3mbS+I3eiO7N eeWIaA3Yfl5nTzqjgNuuao7mO1Wpz54cD667hpCXvMxkFzERf1k5hRsjMKL33IPlwuqg yN6Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=Ayn/bvKyXtEyJxfoisSz/U28elP+dXWyRI3eaimBfoA=; b=iJyiAt7clnMcdHLUo+ZvCGd3XAcxL7U4jQGtG7sYnRGZA/eW07ZnaFEkY5dYPVvv10 7ZTMzxEutL9vZQfPlc1lT1B+Jb91wtMGmFjDAW9oNuN3dJu0WcQ3oAlaKVSU8FO64EwG QUIfJzcFZYxXgr6sKgklV2CQhhiuvImw7zbj2jpW+L+TaTG95sg1dQPo2rEt96OdZc6L ALWtuoPiDsBEAnbmcL0Xp6vl6PQvPWwx2Uyz24fIYLN2MB7pm+nGGhLuRwFjXKCv5hqd L9guVfGz9X/aRYlNbyria+hcbNzA5Wn04wmNfGntTkpr8+GES0erqXPnEVX3AF4qMF2n lE5Q== X-Gm-Message-State: AOAM533HfNEGKoPufCl0CaIcl596CjAtKkRySvxbedcO5q0mtymxgsZE XA+qGuTXX71YCeBz+mlml1Awh0HxW4qu8REOVLMIx0bU X-Google-Smtp-Source: ABdhPJwY/wjR3hOszez8rnhFAliX0ZNT48TaVdM1ug0Lg2pQVMWHh+lF1bL4DYiT6pD8q4zm4DDB/23+fUNxFhqwL40= X-Received: by 2002:a92:cb12:: with SMTP id s18mr19674313ilo.36.1620122595427; Tue, 04 May 2021 03:03:15 -0700 (PDT) MIME-Version: 1.0 Date: Tue, 4 May 2021 12:03:03 +0200 Message-ID: To: internals@lists.php.net Content-Type: multipart/alternative; boundary="000000000000cb094805c17e2ffb" Subject: feat(pdo): add `clearParams` method From: juanrgm724@gmail.com (Juanra GM) --000000000000cb094805c17e2ffb Content-Type: text/plain; charset="UTF-8" Hi everybody. Currently it is not possible to clear the PDOStatement params, so it would be useful to add a method for it. Why? `PDOStatement::execute` admits the `$input_parameters` argument, but all values are passed as `PDO::PARAM_STR` and that hit a performance problem at MariaDB. The fix it is to be able to call the `clearParams` first and` bindValue` later for each param. I don't have permissions to create RFC :( --000000000000cb094805c17e2ffb--