Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:113308 Return-Path: Delivered-To: mailing list internals@lists.php.net Received: (qmail 59451 invoked from network); 27 Feb 2021 17:07:43 -0000 Received: from unknown (HELO php-smtp4.php.net) (45.112.84.5) by pb1.pair.com with SMTP; 27 Feb 2021 17:07:43 -0000 Received: from php-smtp4.php.net (localhost [127.0.0.1]) by php-smtp4.php.net (Postfix) with ESMTP id 2B0881804D1 for ; Sat, 27 Feb 2021 08:57:16 -0800 (PST) X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on php-smtp4.php.net X-Spam-Level: X-Spam-Status: No, score=-1.8 required=5.0 tests=BAYES_00,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-ed1-f51.google.com (mail-ed1-f51.google.com [209.85.208.51]) (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 ; Sat, 27 Feb 2021 08:57:15 -0800 (PST) Received: by mail-ed1-f51.google.com with SMTP id d13so9858833edp.4 for ; Sat, 27 Feb 2021 08:57:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=73SozSdNwgRzUUcILKlPPNVMek2c1e1cXdz10Drgi6U=; b=qg2wjfrIT5N+lWPzLAvKpR0qBQJYX86O9kmsojqnzB5CbEQnKK8M4ilbSQ0gdPWzNg yX9EDy92YtjrjYNB1dCWyvEGmhkvcKfE8LPuDX+4OBW2gY2M/JwRYKZfWyYlqXACg6PP G2hQ379TSYAvyjpRsFfWDZhJ+P7/vXaPJxK4nQ96Ang90BOy+DQBJCi2/tfqVYKxz7SR U80mT6qgYTftCurmhofwUzilWeuYccD0wxLDGwAYTrH2evtB+eBSRutQzA9BSgIsF3Bj PwzqXjfnbtdoOTWGwQJd8gs5hc7oQwN1n2iZBdnf7/6OBQj4Hax6BJ8nzPD5eABKCZN2 19Gw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=73SozSdNwgRzUUcILKlPPNVMek2c1e1cXdz10Drgi6U=; b=JeaKz+hWgjNvYzLYoC0xvNDy10kKIkE9AfHdubbUF/Su3AmY9sft3Ho2bDYtmBGP/c hSmRR55M/kJs8ffB0yYBciyXRDFIIOqek1e5qduQjM0NWi9N/lD0GXeHwpRMg/PwjUaA hDKtTkXUZ/obymQLU1sBlliJFRdM5GQki9dxt33x24mdNQ+eKhrwGa7yS80JfyVZY8n/ q+66QyGLvDIRS740JD54MDa3ZE2bx9J99qy7/prSCzkgk2SzFq1c+2ylVTUm3Jh0gCOV aHqD8DmkxIELlbbjJPKjLQeCBu6T3eLQH3wYFgdimCa/ZyeTwuo5qnLU8jDAaamDP676 NKQw== X-Gm-Message-State: AOAM531TlEbgkXQI87BW9Ez9ArQDHploDRpNpNuMpIIMQsuLTKLyLPSp x8u19Tul9k4YQwlNTgoXZGqRgrrIpJglHEgJ64g= X-Google-Smtp-Source: ABdhPJyX2RAwSI4SQIaJzf6LAshyB4YDiXqMHkTrMc9dY7tICxUpcZ2oUIyX1vT9wwhZv/2qTjcDmWcvKS1Oca+14cE= X-Received: by 2002:aa7:d656:: with SMTP id v22mr6632149edr.119.1614445033550; Sat, 27 Feb 2021 08:57:13 -0800 (PST) MIME-Version: 1.0 References: <84a86f15-313e-1fb3-eb09-7fd6bbdeb5ce@php.net> <821813eb972cd5dad30a0e10385a115a9a8908a2.camel@schlueters.de> <2d9e003c-2a05-9cfa-8625-5aedf5b069f6@gmail.com> In-Reply-To: <2d9e003c-2a05-9cfa-8625-5aedf5b069f6@gmail.com> Date: Sat, 27 Feb 2021 16:57:02 +0000 Message-ID: To: Rowan Tommins Cc: PHP internals Content-Type: multipart/alternative; boundary="000000000000bbf65e05bc54466d" Subject: Re: [PHP-DEV] [RFC]: Change Default mysqli Error Mode From: tekiela246@gmail.com (Kamil Tekiela) --000000000000bbf65e05bc54466d Content-Type: text/plain; charset="UTF-8" > > If product_id is actually an integer column, this function is > technically broken: given a non-integer input, it will produce an error > in the database. > I'm sorry, but I do not understand why would that code produce an error. The value is properly escaped and formatted so there should be no error at all. Is this based on some SQL setting? That SQL looks correct to me and I do not see any syntax errors. Also, silenced or not, if an error occurs on MySQL side then PHP has to check for it one way or another or it will break with some other horrendous error. --000000000000bbf65e05bc54466d--