Req #63799 [Opn->Csd]: Make interface for prepared statements easier

From: Date: Tue, 20 Jul 2021 11:01:49 +0000
Subject: Req #63799 [Opn->Csd]: Make interface for prepared statements easier
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-235203@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=63799&edit=1 ID: 63799 Updated by: cmb@php.net Reported by: thbley at gmail dot com Summary: Make interface for prepared statements easier -Status: Open +Status: Closed Type: Feature/Change Request Package: MySQLi related Operating System: win7 x64 PHP Version: 5.5.0alpha1 -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: This is basically available as of PHP 8.1.0[1]; well, it's still a two step process (::prepare() and ::execute()), but that should be a sufficient improvement. [1] <https://wiki.php.net/rfc/mysqli_bind_in_execute> Previous Comments: ------------------------------------------------------------------------ [2012-12-18 21:29:33] thbley at gmail dot com or sprintf-style instead of auto-detection: foreach ($db->query('select * from bla where someint=%d and somechar=%s', MYSQLI_STORE_RESULT, [10, 'hello_world']) as $row) {...} ------------------------------------------------------------------------ [2012-12-18 21:27:07] thbley at gmail dot com Description: ------------ Please offer an easier interface to run prepared statements, e.g. $db = new mysqli_db('127.0.0.1', 'root', 'some_pw', 'test'); foreach ($db->query('select * from bla where someint=? and somechar=?', MYSQLI_STORE_RESULT, [10, 'hello_world']) as $row) {...} ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=63799&edit=1

« previous php.bugs (#235203) next »