id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
11622,switch to PDO::prepare when we require PHP 5.1,sirzooro,ryan,"This discussion started in #11608:

'''(me)''': Replying to Denis-de-Bernardy:
> In retrospect we should have used the syntax that is accepted by PDO for this stuff, i.e. either of: {{{ ""SELECT * FROM foo WHERE bar = ?"" # ? gets replaced by first variable ""SELECT * FROM foo WHERE bar = :bar"" # :bar gets replaced by variable named bar }}}

We can consider adding new function prepare2() which will use PDO-like syntax, and mark prepare() as deprecated. This will require a lot of work (quick search showed 43 files), but we will avoid such problems in the future. This can be done under another ticket.

'''miqrogroove''':
>If you're going to re-invent the wheel, query parsing seems like a bad approach in general, and that particular syntax improvement offers very marginal benefit above the needed documentation.

'''hakre''':
> I think it's a good approach to shift away from the broken design.",enhancement,closed,normal,,Database,,normal,maybelater,,miqrogroove@… magnus.melin@…