测试代码:
<?php
$pdo = new PDO("mysql:host=example;dbname=test;","test","test");
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$st = $pdo->prepare("select * from account where username =? limit ?,?");
$st->execute(array('buding',0,2));
$res = $st->fetchAll();
var_dump($res);
?>
当在 PHP 5.1.6 测试时,Wireshark检测到发送的语句是:
select * from account where username ='23' limit '2'
当在 PHP 5.3 测试时,Wireshark检测到发送的语句是:
select * from account where username =? limit ?
如何才能在PHP 5.1.6使用真的的mysql预处理呢?这是一个Bug,还是我使用的方式不对?