Swoole-src: How to prepare a statement using swoole-mysql?
I cannot find prepare method. Only query is available. any supports?
shtse8
All 9 comments
use escape to sanitize use input
gouchaoer
on 18 Oct 2017
escaping is not the same as prepare. prepare can be faster for the same query running multiple times with different bindings.
shtse8
on 19 Oct 2017
sad enough, swoole doesn't have it.
mysql support for swoole is built from scratch, obviously prepare just has not been implemented.
so yeah, it's gonna take extra work and got worse performance to do it manually in PHP.
dizys
on 20 Oct 2017
prepare does not give a noticable performance improvement in most cases. pdo does emulated prepare by default for that reason. swoole has very limited contributors. you can manually implement a emulated prepare just like pdo.
gouchaoer
on 20 Oct 2017
@gouchaoer for event-driven server side program, the performance increase a lot.
shtse8
on 20 Oct 2017
The prepare method is not currently supported. You can use escape and query instead of prepare.
We will support prepare in this version of 2.0.11
matyhtf
on 26 Oct 2017
@matyhtf That's great. I am looking forward to this.
shtse8
on 26 Oct 2017
Supported.
https://github.com/swoole/swoole-src/commit/a26f71c5961a437bd10777644e9910854f97df81
https://github.com/swoole/swoole-src/blob/master/examples/coroutine/mysql_prepare.php
matyhtf
on 21 Dec 2017
@matyhtf is there going to be an info on that in the docs?
aolko
on 23 Jan 2019
Related issues
pthreat
路
3Comments
chenye2017
路
3Comments
AndyChanCode
路
3Comments
erDong01
路
3Comments
daslicht
路
4Comments
Most helpful comment
The
prepare methodis not currently supported. You can useescapeandqueryinstead ofprepare.We will support prepare in this version of 2.0.11