[wp-trac] [WordPress Trac] #11622: switch to PDO::prepare when we require PHP 5.1

[WordPress Trac]

#11622: switch to PDO::prepare when we require PHP 5.1
-------------------------+--------------------------------------------------
 Reporter:  sirzooro     |       Owner:  ryan                    
     Type:  enhancement  |      Status:  new                     
 Priority:  normal       |   Milestone:  Future Release          
Component:  Database     |     Version:  2.9                     
 Severity:  normal       |    Keywords:  needs-patch dev-feedback
-------------------------+--------------------------------------------------

Comment(by hakre):

 Replying to [comment:9 josephscott]:
 > By that time we can just use mysqli and the built in prepare function -
 http://us.php.net/manual/en/mysqli.prepare.php
 The switch to PDO would offer the benefit that at least some kind of
 database abstraction would be in. Not that it is solving all issues, but
 it will help other to switch over to other DBs. Wicht mysqli this is not
 possible.

 Next to this argument for PDO instead of mysqli, using mysqli prepare as
 referenced by you has implications:

  ''A true prepared statement would be very bad, because it would do a
 return trip to the server for every query, and the server would actually
 prepare the statement ...'' ([/ticket/11608#comment:24 Ref. to Denis-de-
 Bernardy])

 Hopefully this is usefull info for the ticket.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/11622#comment:10>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software