Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:117569 Return-Path: Delivered-To: mailing list internals@lists.php.net Received: (qmail 22152 invoked from network); 22 Apr 2022 10:35:24 -0000 Received: from unknown (HELO php-smtp4.php.net) (45.112.84.5) by pb1.pair.com with SMTP; 22 Apr 2022 10:35:24 -0000 Received: from php-smtp4.php.net (localhost [127.0.0.1]) by php-smtp4.php.net (Postfix) with ESMTP id 4F7DD1804C5 for ; Fri, 22 Apr 2022 05:09:38 -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.7 required=5.0 tests=BAYES_05,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,FREEMAIL_FROM,HTML_MESSAGE, RCVD_IN_DNSWL_NONE,RCVD_IN_MSPIKE_H2,SPF_HELO_NONE,SPF_PASS, T_SCC_BODY_TEXT_LINE autolearn=no autolearn_force=no version=3.4.2 X-Spam-ASN: AS15169 209.85.128.0/17 X-Spam-Virus: No X-Envelope-From: Received: from mail-yb1-f173.google.com (mail-yb1-f173.google.com [209.85.219.173]) (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 ; Fri, 22 Apr 2022 05:09:37 -0700 (PDT) Received: by mail-yb1-f173.google.com with SMTP id b95so14131538ybi.1 for ; Fri, 22 Apr 2022 05:09:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=DHw6rSeriNoBsTMGXXlP5KVc6OyvSFgOK+X9s/Oo1NY=; b=cV7JQALCgpmlrxppmScq9JuNkfha1evSkf3SfW637A2ZhrjqAS+0zIppRmbGvDaCEs XH/my645NilaGNuorq1HpeQ/GCEIm0JaOy1IooEw7hHSMDISi+kIov9vYRK53hxmFGau wZtWuUd5lwZ4ZHaMjX0LFEw84eFekj/Nkfb17YTaRDlwXZ6FeS9vG4+55X4kkWecyn/O 84eWEaNe7tHC5xjd9/Fyf5vCX/Yeodv3US1bOFtiuEih61r5MnwtB8wlh+0+N+BbqMre t33/jEoMJ+vPuY6yBK2mwdrpaco7zklODf0Gw+PQXfk74sojuE4g/daR8qD8vfXRA64b U1xw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=DHw6rSeriNoBsTMGXXlP5KVc6OyvSFgOK+X9s/Oo1NY=; b=rXhY3qOJ3UdUqrozAG64nADQYXMUAd+jq6Olbp3qdEgH1wxsNT16YyXYxZE6lSKwEl TRA0NWbyOPuxwghvKFFGwvPbyNTq404T0jv6hQMVrZtD3StW7kxSiVxGZsHAytxY98FF aVTvznv+oftvl77/FljEN9wapiBfU1PDtl9xrMs7SmOiImQdMJz4g2VVrECPqDtyfbK/ 5K3nnsCfVQoS08bEmQ+8hgnSnb1EiVzaAkle9xT0nP3YeBbyVxSkU869o0/5TGnDdZWz KTcfnd0UGVo+7yq6OFVoi1Mv7hQxksBzpsnW/Cnt6UKUxMZMN8mVkxHeGVsELFgIALiO Rs3g== X-Gm-Message-State: AOAM531WYND1kIb4KkqMgULDqtdeqiUrzG6kQZRvHRoEMNsKSQNtcTdM lV24C1m9/RBBKauyksG4YOeC8eFav6Ic+hFbUA== X-Google-Smtp-Source: ABdhPJylZ5/MnTZbmR5pVKTB0AuE1cyPO10U/nkLS2nQFQGx8D6GSkxIeT/C4lHyUerS2rM8neZBE68C8KxBKBQHP7k= X-Received: by 2002:a25:8911:0:b0:61e:1c66:17b0 with SMTP id e17-20020a258911000000b0061e1c6617b0mr4159404ybl.354.1650629376960; Fri, 22 Apr 2022 05:09:36 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: Date: Fri, 22 Apr 2022 14:09:26 +0200 Message-ID: To: Craig Francis Cc: PHP internals Content-Type: multipart/alternative; boundary="000000000000ab727905dd3d19d5" Subject: Re: [PHP-DEV] Re: MySQLi Execute Query RFC From: guilliam.xavier@gmail.com (Guilliam Xavier) --000000000000ab727905dd3d19d5 Content-Type: text/plain; charset="UTF-8" Hi Craig, > https://wiki.php.net/rfc/mysqli_execute_query > Thanks. Maybe add (or even start with) an example of mysqli_query(), to show how "migrating to safer" would become easier? retro-fitting your example of parameterised query: ``` $sql_format = "SELECT * FROM user WHERE name LIKE %s AND type IN (%s, %s)"; /* ... */ $sql_raw = vsprintf($sql_format, array_map(fn ($s) => "'" . $db->real_escape_string($s) . "'", [$name, $type1, $type2])); foreach ($db->query($sql_raw) as $row) { print_r($row); } ``` Regards, -- Guilliam Xavier --000000000000ab727905dd3d19d5--