Re: PHP: query with parameter for SET

2021-07-27 Thread Ray O'Donnell
On 27/07/2021 18:20, Pavel Stehule wrote: When you use client side prepared statements, then it can be possible. But I don't know how it works in PHP. Server side prepared statements are not possible in this case. "set" statement has not execution plan. But you  You can use Adrian's proposal,

Re: PHP: query with parameter for SET

2021-07-27 Thread Pavel Stehule
Hi út 27. 7. 2021 v 19:10 odesílatel Ray O'Donnell napsal: > Hi everyone, > > Using PHP (or indeed maybe more generally), is it possible to issue a > SET TIME ZONE statement with a parameter for the new runtime setting? > > In a PHP application I'm issuing a SET TIME ZONE command just after the

Re: PHP: query with parameter for SET

2021-07-27 Thread Adrian Klaver
On 7/27/21 10:10 AM, Ray O'Donnell wrote: Hi everyone, Using PHP (or indeed maybe more generally), is it possible to issue a SET TIME ZONE statement with a parameter for the new runtime setting? In a PHP application I'm issuing a SET TIME ZONE command just after the database connection is cr

PHP: query with parameter for SET

2021-07-27 Thread Ray O'Donnell
Hi everyone, Using PHP (or indeed maybe more generally), is it possible to issue a SET TIME ZONE statement with a parameter for the new runtime setting? In a PHP application I'm issuing a SET TIME ZONE command just after the database connection is created, and for security I'd like to pass th