TYPO3 Core

wip patch attached. Xavier will work on this in the next weeks.

+1 on that, thanks!

I took a closer look here.

To sum it up: quite hard

1. Our DB API supports named parameters (:placeholder), but MySQL does not.
2. The patch from Benni does not take DBAL into account at all. So this is a no go.
3. The mysqli_stmt::get_result() (buffered result) method is only available with mysqlnd driver according to php docs.

We'd need to:

1. Get DBAL straight for 6.2 (#50752)
2. Implement a translation layer from named to positioned parameters, which would involve some sort of query parsing again.
3. Make the PreparedStatement class independent of any database link, as the exact link used is different for every driver used in DBAL.
4. Emulate a buffered result, if mysqlnd is not available, to make the PreparedStatement::seek() function work

So IMHO this is a topic for 6.3+

Xavier will work on this and tries to push a WIP patch this evening. In the morning I will have a look and possibly pick up ...

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/28231

Applied in changeset 5487900c5ad094cd8dc733f5e8cdc627673e94ff.