php - 查询中带有 "declare"的 PDO Dblib 返回 false

Question

让我们检查一下这段代码:

$p = new PDO('dblib:host=HOST;dbname=DBNAME',USER,PASS);
$sql = "
declare @tutu int = 100;
select @tutu [tutu];
";
$stmt = $p->prepare($sql);
$stmt->execute();
var_dump($stmt->fetch(PDO::FETCH_ASSOC));

返回:

bool (假)

Answer 1

使用 nextRowset();

$p = new PDO('dblib:host=HOST;dbname=DBNAME',USER,PASS);
$sql = "
declare @tutu int = 100;
select @tutu [tutu];
";
$stmt = $p->prepare($sql);
$stmt->execute();
$stmt->nextRowset();
var_dump($stmt->fetch(PDO::FETCH_ASSOC));

返回:

array(1) {
  [0]=>
  array(1) {
    ["tutu"]=>
    string(3) "100"
  }
}