Req #63799 [Opn->Csd]: Make interface for prepared statements easier
| From: | cmb@php.net | 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